Hi
I have a simple load from a flat file into a remote Oracle database. The first 10k records fly into the database but the load errors out afterwards
Starting job LoadHUBAccounts at 15:12 23/03/2009. connecting to socket on port 3827
connected
Exception in component tOracleOutput_1
java.lang.ArrayIndexOutOfBoundsException: -32303
at oracle.jdbc.driver.OraclePreparedStatement.setupBindBuffers(OraclePreparedStatement.java:2673)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10689)
at custody_plus.loadhubaccounts_0_1.LoadHUBAccounts.tFileInputPositional_1Process(LoadHUBAccounts.java:3260)
at custody_plus.loadhubaccounts_0_1.LoadHUBAccounts.runJobInTOS(LoadHUBAccounts.java:3434)
at custody_plus.loadhubaccounts_0_1.LoadHUBAccounts.main(LoadHUBAccounts.java:3343)
disconnected
I'm assuming this is an Oracle driver issue but not sure.
Cheers
Al
java.lang.ArrayIndexOutOfBoundsException
We are upgrading from 5.1 to 5.6.1 and I could not figure out what this tOracleOutput error was until I found this thread. The issue was that Oracle components that used cursor setting needed to be changed to 1000 and then they worked. Thank you
oscarvalles!
Try switching to the ojdbc7 (instead of ojdbc6) jar, since it's a newer version that does not appear to have this problem.
You might have to edit your connection .properties file with a text editor to switch it from ojdbc6-11 to ojdbc7-12, then go into talend and "modify" it without changing anything, when you hit finish it will prompt to update all jobs that use it.
(FYI, the ojdbc7-12 driver is compatible with oracle 11g as well as 12c, probably 10g too, but I hope you aren't using that)
Same problem here loading several rows into an Oracle table and using JDBC driver ojdbc6.jar
Exception in component tOracleOutput_1
java.lang.ArrayIndexOutOfBoundsException: -32467
Buliding the job to run it out of TOS DI (replacing ojdbc6.jar in lib folder with ojdbc7.jar and adjusting the batch file to start the job), the problem is solved, no more errors.
Now, how can I tell Talend (TOS DI) to use ojdbc7.jar instead of ojdbc6 in all tOracle* components and without using tOracleConnection as I need to specify the commit interval? In this way I could run it inside TOS.
Try switching to the ojdbc7 (instead of ojdbc6) jar, since it's a newer version that does not appear to have this problem. You might have to edit your connection .properties file with a text editor to switch it from ojdbc6-11 to ojdbc7-12, then go into talend and "modify" it without changing anything, when you hit finish it will prompt to update all jobs that use it. (FYI, the ojdbc7-12 driver is compatible with oracle 11g as well as 12c, probably 10g too, but I hope you aren't using that)
Hi, Can you explain me where can I find .properties file to switch it from ojdbc6-11 to ojdbc7-12 please?
Get new Oracle ojdbc6.jar from Oracle 11.2.0.4, it has this problem fixed: Copy it to c:/talend/TOS_BD-20150908_1633-V6.0.1/workspace/<your project>/temp/dbWizard and replace old one there. Andrew
