XML Parser for Java: Creates and parses XML using industry standard DOM and SAX interfaces. Includes an XSL Transformation (XSLT) Processor that transforms XML to XML or other text-based formats, such as HTML.

XML Schema Processor for Java: Supports simple and complex types and is built on the Oracle XML Parser for Java v2.

XML Class Generator for Java: Creates source files from an XML DTD or XML Schema definition.

XML SQL Utility (XSU) for Java: Enables you to transform data retrieved from object-relational database tables or views into XML, extract data from an XML document and:

• Use canonical mapping to insert data into appropriate columns or attributes of a table or a view
• Apply this data to update or delete values of the appropriate columns or attributes

XSQL Servlet: Processes SQL queries embedded in an XSQL file. Returns results in XML format. Uses XML SQL Utility and XML Parser for Java.

Oracle Soap: An implementation of the Simple Object Access Protocol.

Oracle TransX Utility: This utility makes it easier to load translated seed data and messages into the database.

You can use any of the XDK for Java components in Oracle9i JDeveloper. The XML parser, XML Schema processor, the XML SQL Utility for Java, the Oracle SOAP implementation libraries and the XSQL servlet runtime all ship with the IDE. You can easily add the XML class generator and the TransX Utility into Oracle9i JDeveloper and create applications using these components of the XDK.

XSQL Servlet
XSQL Servlet is a tool that processes SQL queries and outputs the result set as XML. This processor is implemented as a Java servlet and takes as its input an XML file containing embedded SQL queries. It uses the XML Parser for Java, XML-SQL Utility, and Oracle XSL Transformation (XSLT) Engine to perform many of its operations.

You can use XSQL Servlet to perform the following tasks:

• Build dynamic XML datapages from the results of one or more SQL queries and serve the results over the Web as XML datagrams or HTML pages using server-side XSLT transformations.
• Receive XML posted to your web server and insert it into your database.

Assembling and transforming information for publishing requires no programming. In fact, most of the common things you will want to do can be easily achieved in a declarative way. However, since the XSQL publishing framework is extensible, if one of the built-in features does not fit your needs, you can easily extend the framework using Java to integrate custom information sources or to perform custom server-side processing.

Using the XSQL Pages framework, the assembly of information to be published is cleanly separated from presentation. This simple architectural detail has profound productivity benefits. It allows you to:

• Present the same information in multiple ways, including tailoring the presentation appropriately to the kind of client device making the request (brower, cellular phone, PDA, etc.).
• Reuse information easily by aggregating existing pages into new ones
• Revise and enhance the presentation independently of the information content being presented.

The diagram below depicts the flow of control in a typical web application built using the XSQL framework.

Oracle9i JDeveloper simplifies the task of building XSQL files by including XSQL tags in its component palette. You can drag XSQL tags into your XSQL page and use wizards to set the tags values. In addition, Orcale9i JDeveloper allows you to build XSQL pages based applications on top of the BC4J framework by providing easy to use XSQL elements in the component palette. It provides easy to use interface to BC4J View Objects.

Below: XSQL file and component palette in Oracle9i JDeveloper

	XSQL Servlet in Action - On-Line Demo
	Oracle9i Application Developer's Guide - Chapter 10: XSQL Pages Publishing Framework
	XSQL Sample

Archives