Reading Binary XMLTypes in Java

In Java applications, you can read XMLTypes from Oracle XML DB. The following example shows how to query binary XMLTypes in the Oracle database, and use them in a Java program.

To run the Java program, you need to make sure that the xmlparserv2.jar, ojdbc5.jar, and xdb.jar are included in the Java CLASSPATH. You can refer to Chapter 11 for the details of the Java libraries required by the Oracle XML DB applications. Chapter 16 explains how to add these libraries into Oracle JDeveloper projects.

Oracle XML DB Tip: Why do I get the “oracle.jdbc.driver.OracleSQlXML cannot be cast to oracle.xdb.XMLType” exception?

You have to use the correct JDBC driver. In Oracle Database 11.2.0.2, Oracle XML DB is compliant with ...

Get Oracle Database 11g Building Oracle XML DB Applications now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.