In Chapter 7, we discussed the mapping of XML to SQL and SQL to XML. XML SQL Utility is a Java API. However, SQL to XML mapping may also be done with XSQL using the JDBC driver without any Java code. The Oracle XSQL Pages Publishing Framework, which is included in Oracle JDeveloper 10g, supports the processing of SQL queries to generate XML. XSQL may also be used to run SQL DML (Data Manipulation Language) statements other than SQL SELECT
such as INSERT, UPDATE
, and DELETE
. An XSQL page consists of the XSQL tags in the urn:oracle-xsql
namespace. An XSQL page request is sent to the XSQL Servlet, which invokes the XSQL Page Processor.
The XSQL Pages Publishing Framework integrates XML, SQL, and XSLT. The XSQL Page Processor processes XSQL page templates. The XSQL Page Processor uses the Oracle XML Parser to parse XSQL Page templates and uses the XSLT Stylesheets to transform output from XSQL page processing. XSQL Pages Framework uses XML SQL Utility (XSU) to query the database...