tOracleInput XMLType NoClassDefFoundError

Six Stars

tOracleInput XMLType NoClassDefFoundError

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(
at oracle.jdbc.oracore.OracleTypeADT.parseTDSrec(
at oracle.jdbc.oracore.OracleTypeADT.parseTDS(
at oracle.jdbc.oracore.OracleTypeADT.init(
at oracle.jdbc.oracore.OracleTypeADT.init(
at oracle.sql.TypeDescriptor.getTypeDescriptor(
at oracle.jdbc.driver.NamedTypeAccessor.otypeFromName(
at oracle.jdbc.driver.TypeAccessor.initMetadata(
at oracle.jdbc.driver.T4CStatement.executeForDescribe(
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
at oracle.jdbc.driver.OracleStatement.executeQuery(
at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(

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.
Talend Open Studio 6.1.1 for ESB
Oracle Database 11g Enterprise Edition Release - 64bit Production
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.
Six 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 

Cloud Free Trial

Try Talend Cloud free for 30 days.


Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.