O'Reilly logo

JDBC 4.0 and Oracle JDeveloper for J2EE Development by Deepak Vohra

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 8. XSQL

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required