topic Re: Pb driver ojdbc14-9i.jar with component tOracleInput and tOracleRow in Talend Studio

Pb driver ojdbc14-9i.jar with component tOracleInput and tOracleRow

_AnonymousUser — Sat, 16 Nov 2024 14:09:01 GMT

Hi every body,

We use TOS 3.0.0, we've an Oracle 9i patch 7 database and we want just extract rows from tables or sql queries with the components tOracleInput and tOracleRow.
We've not problem to execute querie with Talend but when we concept a job with two components tOracleInput and tFileOutput... or tOracleRow and tFileOutput we've the following error :
Exception in component tOracleInput_1
java.sql.SQLException: ORA-00600: code erreur interne, arguments : , , [], [], [], [], [], []
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:169)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:889)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1826)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2015)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:571)
at vdc.extract_test_0_1.extract_test.tOracleInput_1Process(extract_test.java:534)
at vdc.extract_test_0_1.extract_test.runJobInTOS(extract_test.java:882)
at vdc.extract_test_0_1.extract_test.main(extract_test.java:797)
Any body hace an idea of problem ?
Me I believe that problem come from Talend driver for Oracle database.

Thanks Julien

Re: Pb driver ojdbc14-9i.jar with component tOracleInput and tOracleRow

youssef2 — Fri, 21 Nov 2008 16:35:19 GMT

Hi,
Yes, you 're right. You can download classes12.jar form oracle website then rename it to overwrite ojdbc14-9i.jar in the lib diractory of your talend directory.
Regards,
Youssef

Re: Pb driver ojdbc14-9i.jar with component tOracleInput and tOracleRow

Anonymous — Fri, 21 Nov 2008 16:40:34 GMT

Resolved in 3.0.2
Regards,

Re: Pb driver ojdbc14-9i.jar with component tOracleInput and tOracleRow

_AnonymousUser — Sun, 23 Nov 2008 11:25:59 GMT

Ok,
I will test it monday.
Regards,
Julien

Re: Pb driver ojdbc14-9i.jar with component tOracleInput and tOracleRow

_AnonymousUser — Mon, 24 Nov 2008 15:05:33 GMT

Hi,

I tested my Jobs with TOS 3.0.2 and the problem resolved. So, I tried to use the ojdbc14-9i.jar from TOS 3.0.2 in TOS 3.0.0 but I'd the same the problem before.
Is there a solution to resolve the problem with TOS 3.0.0 without export and import my project in TOS 3.0.2 ?

Regards,
Julien