tOracleInput XMLType NoClassDefFoundError

Six 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
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.
Highlighted
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 

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

An API-First Approach to Modernizing Applications

Learn how to use an API-First Approach to Modernize your Applications

Watch Now

Talend API Designer – Technical Overview

Take a look at this technical overview video of Talend API Designer

Watch Now

Getting Started with APIs

Find out how to get started with APIs

Read