Five Stars

tOracleInput XMLType NoClassDefFoundError

Hello,
I am trying to read from an Oracle XMLtype DB but I'm getting the error below:
Exception in thread "main" java.lang.NoClassDefFoundError: oracle/xdb/XMLType
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.TypeDescriptor.getTypeDescriptor(TypeDescriptor.java:981)
at oracle.jdbc.driver.NamedTypeAccessor.otypeFromName(NamedTypeAccessor.java:78)
at oracle.jdbc.driver.TypeAccessor.initMetadata(TypeAccessor.java:71)
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:823)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:897)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1034)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1244)
at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:420)
disconnected

I have downloaded both xdb.jar and xdb6.jar from Oracle and put them in the studio plugin folder (and restarted Talend Studio); still getting the error.
Environment: 
Talend Open Studio 6.1.1 for ESB
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
2 REPLIES
Seventeen Stars

Re: tOracleInput XMLType NoClassDefFoundError

You have to use the libraries in your job. Please use the tLoadLibrary component to load these libs in your job. Putting them in the Studio lib folder is not enough.
Five Stars

Re: tOracleInput XMLType NoClassDefFoundError

Thank you @jlolling
That worked perfectly.
For anyone in same boat, you need to add xmlparserv2.jar in addition to xdb6.jar