Oracle XML SQL Utility is used to map an XML document to a relational database and vice versa. The XML SQL Utility (XSU) does not store the attributes in an XML document. The attributes can be stored by applying an XSLT to the XML document. In this chapter, the Oracle database has been used to store an XML document. We can also use the open-source MySQL database to do the same. We used the Oracle database 11g JDBC 4.0 driver to map an XML document to an Oracle database table, and also to map an Oracle database table to an XML document. We used some of the new features in JDBC 4.0, such as automatic driver loading, and enhanced support for chained SQLExceptions
.
JDBC 4.0 and Oracle JDeveloper for J2EE Development
JDBC 4.0 and Oracle JDeveloper for J2EE Development
Overview of this book
Table of Contents (20 chapters)
JDBC 4.0 and Oracle JDeveloper for J2EE Development
Credits
About the Author
About the Reviewer
Preface
Free Chapter
JDBC 4.0
Configuring JDBC in Oracle JDeveloper
Connecting to a Database with JSTL SQL Tag Library
Configuring JDBC in JBoss Application Server
Configuring JDBC in WebLogic Server
Configuring JDBC in WebSphere Application Server
XML SQL Utility
XSQL
Oracle Web RowSet
Creating a JSF Data Table
Creating a JSF Panel Grid
Creating a Report with JasperReports
Creating a Spreadsheet with Apache POI
Creating Oracle ADF Business Components
Hibernate
Customer Reviews