Use XML type with JDBC

366556

Hello,

Where can I find xmlparserv2.jar? I need oracle/xml/binxml/BinXMLMetadataProvider. This class is found in
Oracle® Database XML Java API Reference
11g Release 1 (11.1)
B28391-01

If you could post a simple example how to fetch XML type from ResultSet I'd appreciate very much because all my tries ended with a nullpointer exception.

Thanks.

Unknown

>
Where can I find xmlparserv2.jar? I need oracle/xml/binxml/BinXMLMetadataProvider
>
Take your pick. There are 5 versions of it included with the Oracle database and it is also part of the Sql Developer and JDeveloper downloads.
>
If you could post a simple example how to fetch XML type from ResultSet I'd appreciate very much because all my tries ended with a nullpointer exception.
>
The XML DB Developer's Guide has examples of using JDBC to do that.
http://docs.oracle.com/cd/B28359_01/appdev.111/b28369/xdb11jav.htm
>
14 Java DOM API for XMLTypeThis chapter describes how to use XMLType in Java, including fetching XMLType data through Java Database Connectivity (JDBC).

366556

Thanks so much. I found the jars.

Unknown

Then please mark your question ANSWERED.