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


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 ( instead of classes12.jar or ojdbc14.jar, it works. yes it works but I dont know why !

Leave a comment

Leave a Reply

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

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

Google photo

You are commenting using your Google 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 )

Connecting to %s

%d bloggers like this: