In a nutshell XSql allows developers to populate a database with data. Imagine XSql to be a database injector that inserts rows of data onto any database. What makes XSql unique is that the data that is uses is as realistic as you make it through the use of resource files. XSql is capable of this realistic data population by the use of resource files. For each column a resource file may be assigned that is the designated file where the data will be collected from. XSql is 100% Java and XML.

This section contains several XSQL examples, inluding the famous "Hello World" example.

April 8th and 9th 2001 saw the first conference dedicated to XSLT take place at Keble College in Oxford. While the basis of the conference was XSLT, this didn't stop people talking about the XSL effort in general or about other vocabularies and technologies that work with or against XSLT.

This section contains several XSLT and XSQL examples.

In the previous exercise you created a database for your book selling site and two of the Web pages. In this exercises, you will complete your Web site, using Servlets, XSQL and JSP. You will also allow programic access to your Web site, using SOAP.

Includes an XML fragment representing the names and values of all HTTP parameters, cookies, and session variables.

Executes an arbitrary stored function returning a REF CURSOR and includes the result set in canonical XML format.

Sets the value of a top-level XSLT stylesheet parameter.

Sets the value of an HTTP Cookie, and optionally specifies the maximum age and domain of the cookie.

This sample application demonstrates the use of the XSQL servlet to connect to a BC4J middle tier project and update the database.

Executes a SQL DML statement or PL/SQL anonymous block.

This sample application demonstrates the use of the XSQL servlet to connect to a BC4J middle tier project and query and update the database. It also shows you how you can apply different stylesheets to the same document and view the results on an HTML browser or a cell phone simulator.

Executes a PL/SQL stored procedure that uses the OWA packages to generate XML content, and includes the resulting XML.

Includes the XML output of another XSQL page.

Although most of Oracle's XML functionality is handled through the XSQLServlet and its associated tools, the servlet itself is actually just one component of a full Java library for using XML with an Oracle database. Many of the tasks you would perform using the XSQLServlet can also be performed in Java using the oracle.xml.xsql package. This package contains a wealth of classes and methods to perform almost any task using XML and Oracle.

JDeveloper's XML Editor supports syntax highlighting, Structure window view, and the Property Inspector. You can also select tags from the Component Palette to insert in your pages while you are editing.

An action handler in an XSQL page is a Java class that gets invoked to perform a specific task. There are prebuilt action handlers for various tasks such as setting cookies, applying style sheets, performing queries against databases, etc. However, if you choose to perform some operation which is not provided by the built-in action handlers, then you can write what is called a custom action handler. A custom action handler is a Java class that can be invoked from an XSQL page just as easily as a predefined action handler.

After you have completed your XSQL file, you should check your XML syntax and then run it.

You can check your XSQL file to determine if it is a well-formed XML document and if not, to find any errors.

You can create XML based clients for XSQL servlets using XSQL tags. XSQL servlets allow you to easily get data in and out of the database in XML format. The following procedure shows how to use the XSQL Query tag to display data.