ClassCastException With 184.108.40.206 Oracle JDBC Driver When Getting XMLTYPE Column Value
(Doc ID 1305209.1)
Last updated on JUNE 24, 2021
Applies to:JDBC - Version 220.127.116.11.0 to 18.104.22.168.0 [Release 11.2]
Information in this document applies to any platform.
When getting XMLTYPE column value as an oracle.xdb.XMLType object,
with the version 22.214.171.124 of Oracle JDBC driver, the following exception is thrown:
java.lang.ClassCastException: oracle.jdbc.driver.OracleSQLXML cannot be cast to oracle.xdb.XMLType
To illustrate this problem, the warehouse_spec XMLTYPE column is defined and filled as the following:
JDK 6 version is used, and,the CLASSPATH contains the 126.96.36.199 ojdbc6.jar (Oracle JDBC driver, OH/jdbc/lib directory ), xdb.jar (XDB product, OH/RDBMS/jlib directory) and xmlparserv2.jar (XDK product, OH/lib directory) libraries. (OH stands for the Oracle Home 188.8.131.52 database server directory).
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document