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