tOracleInput XMLType NoClassDefFoundError

Anonymous — Sat, 16 Nov 2024 10:37:36 GMT

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

Re: tOracleInput XMLType NoClassDefFoundError

Anonymous — Tue, 24 May 2016 23:03:54 GMT

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.

Re: tOracleInput XMLType NoClassDefFoundError

Anonymous — Wed, 25 May 2016 12:43:24 GMT

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

topic tOracleInput XMLType NoClassDefFoundError in Talend Studio

tOracleInput XMLType NoClassDefFoundError

Re: tOracleInput XMLType NoClassDefFoundError

Re: tOracleInput XMLType NoClassDefFoundError