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 !
