Hello,
I am getting a java.lang.arrayoutofbounds exception as below when i am trying dump data into an Oracle 11G instance.
*******
Exception in component tOracleOutput_2
java.lang.ArrayIndexOutOfBoundsException: -32503
at oracle.jdbc.driver.OraclePreparedStatement.setupBindBuffers(OraclePreparedStatement.java:2673)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10689)
at proofofvalue.dnbin_0_1.DNBin.tOracleInput_2Process(DNBin.java:6327)
at proofofvalue.dnbin_0_1.DNBin.runJobInTOS(DNBin.java:6750)
at proofofvalue.dnbin_0_1.DNBin.main(DNBin.java:6618)
*******
I was looking here for help and found that article
https://community.talend.com/t5/Design-and-Development/Oracle-Load-errors-out-after-10000-records/td... was reffered to being solved the issue.
I followed the steps to change the value for commit every under the advanced properties tab of my toracleoutput component and somethign very strange is happening.
the default value is 10k so it first stopped at 20k. When I changed the commit everyt o 50k, it still stopped at 20k.
when I changed commit every to 5k, it stopped at 10k. When I changed it back to 50k, it stopped at 20k.
PLease help.
Best,
Karan
Hi everyone, I'm getting this error. I'm using TIS Version: 5.3.1 Build id: r104014-20130618-0337. My source and target database are Oracle 11g. I'm doing just a select and insert. How can I solve this issue? Thanks in advance. Nuno
Problem solved. I used the oracle 11g driver. Thanks!
Hi everyone, I'm getting this error. I'm using TIS Version: 5.3.1 Build id: r104014-20130618-0337. My source and target database are Oracle 11g. I'm doing just a select and insert. How can I solve this issue? Thanks in advance. Nuno
