Simple Example Using SQLXML JDBC 4.0 XML Data Type (Doc ID 1275888.1)

Last updated on AUGUST 03, 2016

Applies to:

JDBC - Version: 11.2.0.2 to 11.2.0.2 - Release: 11.2 to 11.2
Information in this document applies to any platform.

Goal

One of the most important updates in JDBC 4.0 standard is the support for the XML data type, defined by the SQL 2003 standard. Now JDBC offers a mapping interface to support the SQL/XML database data type, that is, java.sql.SQLXML. This new JDBC interface defines Java native bindings for XML, thus making handling of any database XML data easier and more efficient. This how to will give a small demo on how to use the new SQLXML data type in the 11.2.0.2 JDBC driver.

In order to use JDBC 4.0 you must be using JDK 1.6 and ojdbc6.jar (11.2.0.2) which can be downloaded from here
http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms