AnsweredAssumed Answered

After adding ojdbc7 to Lib folder for Oracle 12c database support, getting a NoClassFound error. Any idea ?

Question asked by VirajSingh on Dec 8, 2016
Latest reply on Dec 13, 2016 by VirajSingh

After adding ojdbc7 to Lib folder for Oracle 12c database support, getting a parsing error.
I have added the ojdbc7-12.1.0.2.jar to support the latest upgrade for our databases to oracle 12c.
Now if i am running the individual JDBC step to the test connection , i am able to connect..so that's great
But now when i am running the ITR , i am getting the below error.

The catch here is that when i am removing the classes12.jar from Lib folder i get this error.
But if i include the classes12.jar file in the lib folder then i am unable to connect to the new DB servers with oracle 12c upgrades.Then i get a no security authentication protocol error.
Has anyone faced something similar?
Earlier, before the 12c upgrade, i was using ojdbc5.jar and classes12.jar together and it worked fine.

===========================================================================
| Exception:
============================================================================
| Message: Test Execution Stopped due to exception
----------------------------------------------------------------------------
| Trapped Exception: oracle/xml/parser/v2/XMLParseException
| Trapped Message: java.lang.NoClassDefFoundError: oracle/xml/parser/v2/XMLParseException
----------------------------------------------------------------------------
STACK TRACE
java.lang.NoClassDefFoundError: oracle/xml/parser/v2/XMLParseException
at oracle.jdbc.driver.NamedTypeAccessor$XMLFactory.createXML(NamedTypeAccessor.java:118)
at oracle.jdbc.driver.NamedTypeAccessor.getOracleObject(NamedTypeAccessor.java:249)
at oracle.jdbc.driver.NamedTypeAccessor.getString(NamedTypeAccessor.java:354)
at oracle.jdbc.driver.GeneratedStatement.getString(GeneratedStatement.java:327)
at oracle.jdbc.driver.GeneratedScrollableResultSet.getString(GeneratedScrollableResultSet.java:882)
at com.mchange.v2.c3p0.impl.NewProxyResultSet.getString(NewProxyResultSet.java:934)
at com.itko.lisa.jdbc.JDBCResultSetCache.getRowData(JDBCResultSetCache.java:69)
at com.itko.lisa.jdbc.JDBCResultSetCache.<init>(JDBCResultSetCache.java:54)
at com.itko.lisa.jdbc.JDBCNode.makeGenericCall(JDBCNode.java:463)
at com.itko.lisa.jdbc.JDBCNode.executeSQL(JDBCNode.java:387)
at com.itko.lisa.jdbc.JDBCNode.execute(JDBCNode.java:341)
at com.itko.lisa.test.TestNode.executeNode(TestNode.java:981)
at com.itko.lisa.test.TestCase.execute(TestCase.java:1295)
at com.itko.lisa.test.TestCase.execute(TestCase.java:1210)
at com.itko.lisa.test.TestCase.executeNextNode(TestCase.java:1195)
at com.itko.lisa.utils.ExecSubProcessNode.doFullExec(ExecSubProcessNode.java:354)
at com.itko.lisa.utils.ExecSubProcessNode.execute(ExecSubProcessNode.java:268)
at com.itko.lisa.test.TestNode.executeNode(TestNode.java:981)
at com.itko.lisa.test.TestCase.execute(TestCase.java:1295)
at com.itko.lisa.test.TestCase.execute(TestCase.java:1210)
at com.itko.lisa.test.TestCase.executeNextNode(TestCase.java:1195)
at com.itko.lisa.editor.WalkThruPanel.prepAndExecNode(WalkThruPanel.java:1057)
at com.itko.lisa.editor.WalkThruPanel.access$900(WalkThruPanel.java:70)
at com.itko.lisa.editor.WalkThruPanel$10.doCallback(WalkThruPanel.java:964)
at com.itko.util.swing.panels.ProcessingDialog$2.run(ProcessingDialog.java:194)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.ClassNotFoundException: oracle.xml.parser.v2.XMLParseException
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
... 26 more

Outcomes