
Specialist III
2008-11-21
11:29 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Pb driver ojdbc14-9i.jar with component tOracleInput and tOracleRow
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
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
197 Views
4 Replies

Contributor
2008-11-21
11:35 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
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
197 Views

Anonymous
Not applicable
2008-11-21
11:40 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Resolved in 3.0.2
Regards,
Regards,
197 Views

Specialist III
2008-11-23
06:25 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Ok,
I will test it monday.
Regards,
Julien
I will test it monday.
Regards,
Julien
197 Views

Specialist III
2008-11-24
10:05 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
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
197 Views
