Java – Where to get the Oracle XML parsing jars for the Oracle Database 11g Release 2 11.2.0.2.0 and older

javajdbcoracle11g

Trying to read some data stored in a Oracle Database 11g Release 2 (11.2.0.2.0) database stored as the data type "XMLTYPE", using the JDBC driver.

Oracle® XML DB
Developer's Guide
11
g
Release 2 (11.2) seems to indicate I should be using an XMLType and that I will need a xdb.jar and an xmlparserv2.jar file

Oracle Database 11g Release 2 JDBC Drivers for the 11.2.0.2 and earlier seem to be missing the xdb.jar and xmlparserv2.jar files?

Where does one find these files To be able to correctly utilize the java import for "oracle.xdb.XMLType" for this version of 11g?

Best Answer

Try looking on the database server.

Page 31-7 of the Oracle XML DB Developer's Guide you linked to mentions that the xmlparserv2 JAR file can be found in $ORACLE_HOME/lib. On my Oracle XE database I found a copy of xdb.jar under $ORACLE_HOME/rdbms/jlib. Having said that, though, XE is not a full Oracle database so I'm not promising that you'll find this JAR in the same location on your database.

If you have an Oracle client installed, you may also want to try looking in similar folders within the client installations.

Related Topic