Hello:
We are attempting to create an XMLType object from a string in order to enqueue the object onto an AQ queue. This has worked fine with 10g, 11g JDBC drivers, but runs into trouble with the 12c JDBC driver. During runtime a ClassDefNotFound exception is thrown for oracle.xdb.XMLType. Has anyone else had similar issues using XMLType with the 12c thin JDBC driver? This is in a WebSphere 8.5 environment.
Snippet below:
public Message createMessage (Connection conn, Session session, String xmlMessage) {
XMLType payload = null;
AdtMessage msg = null;
payload =XMLType.createXML((java.sql.Connection) conn, xmlMessage);
msg = ((AQjmsSession) session).createORAMessage(payload);
return msg;
StackTrace:
Exception:java.lang.NoClassDefFoundError SourceId:com.ibm.ejs.container.BusinessExceptionMappingStrategy.setUncheckedException ProbeId:506 Reporter:com.ibm.ejs.container.BusinessExceptionMappingStrategy@f4461508
java.lang.NoClassDefFoundError: oracle.xdb.XMLType
at java.lang.J9VMInternals.verifyImpl(Native Method)
at java.lang.J9VMInternals.verify(J9VMInternals.java:93)
at java.lang.J9VMInternals.initialize(J9VMInternals.java:170)
at oracle.jdbc.oracore.OracleTypeADT.applyTDSpatches(OracleTypeADT.java:1081)
at oracle.jdbc.oracore.OracleTypeADT.parseTDSrec(OracleTypeADT.java:1002)
at oracle.jdbc.oracore.OracleTypeADT.parseTDS(OracleTypeADT.java:936)
at oracle.jdbc.oracore.OracleTypeADT.init(OracleTypeADT.java:489)
at oracle.jdbc.oracore.OracleTypeADT.init(OracleTypeADT.java:470)
at oracle.sql.OpaqueDescriptor.initPickler(OpaqueDescriptor.java:258)
at oracle.sql.OpaqueDescriptor.<init>(OpaqueDescriptor.java:75)
at oracle.sql.OpaqueDescriptor.createDescriptor(OpaqueDescriptor.java:180)
at oracle.xdb.XMLType.<init>(XMLType.java:951)
at oracle.xdb.XMLType.createXML(XMLType.java:1082)
at oracle.xdb.XMLType.createXML(XMLType.java:1072)
at <...>.jms.aq.AQMessageCreator.createPayload(Unknown Source)
at <...>.jms.aq.AQMessageCreator.createMessage(Unknown Source)
at <...>.jms.aq.AQMessageSender.send(Unknown Source)
... 153 more
Caused by: java.lang.ClassNotFoundException: oracle.xdb.XMLType
at java.net.URLClassLoader.findClass(URLClassLoader.java:599)
at com.ibm.ws.bootstrap.ExtClassLoader.findClass(ExtClassLoader.java:204)
at java.lang.ClassLoader.loadClassHelper(ClassLoader.java:743)
at java.lang.ClassLoader.loadClass(ClassLoader.java:720)
at com.ibm.ws.bootstrap.ExtClassLoader.loadClass(ExtClassLoader.java:119)
at java.lang.ClassLoader.loadClass(ClassLoader.java:690)
... 170 more