OracleXMLQuery: Exception when accessing nested tables

Problem When using OracleXMLQuery to access nested tables, generated XML contains error message

oracle.xml.sql.OracleXMLSQLException: getCollectionMetaData:  this method is not supported by ‘OracleXMLDataSetGenJdbc’ class.  Please use ‘OracleXMLDataSetExtJdbc’ instead.

Description when using OracleXMLQuery to query a view which has a column of user defined type (or Table TYPE column), query executed successfully without any exception.

But when the XML string is obtained using

oxq.getXMLString()

XML String contains above error message.

Driver: Oracle JDBC Driver.

Databse: Oracle 10g

Solution: Looking for solution, if you know the solution, please let me know.

I have found that If I use oracle 9I driver (classes12.zip) instead of classes12.jar or ojdbc14.jar, it works. yes it works but I dont know why !

Advertisements
Leave a comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: