Book Image

JDBC 4.0 and Oracle JDeveloper for J2EE Development

Book Image

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

XML Document to SQL Database Mapping


If the XML document had been stored with XSU, only the element tags in the XML document would have got stored. The attributes in the XML document would not have got stored. Attributes in an XML document can be stored by mapping them to elements. The attributes can be converted to elements by applying an XSLT stylesheet to the XML document. This section discusses the procedure to store an XML document with attributes in a database table. The XML document is stored in a database table using the OracleXMLSave class, which is imported in the XMLToDatabase.java application.

Create a connection with the database. If we were using a JDBC 3.0 driver, we would have registered the Oracle JDBC driver with DriverManager using the registerDriver(Driver) method. JDBC 4.0 adds support for automatic driver registration using the Java SE Service Provider mechanism. The Oracle database 11g JDBC 4.0 drivers JAR file, ojdbc6.jar, includes a META-INF/services/java.sql.Driver...