Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Here is a related topic:https://community.talend.com/t5/Design-and-Development/tOracleInput-ArrayIndexOutOfBoundsException/m....
Feel free to post your issue here with more detailed information.
Best regards
Sabrina
Hi @xdshi,
Thanks in advance,
I have tried the solutions which are provided in previous link but its not useful enough to fix the issue which i am facing ,Kindly see the attched error details for the same.
I am using ojdbc6.jar and TOS 6.1.1. still facing the same issue again and again, The job is failing whenever i tried to execute the same as standalone job on unix box.
Error Details :
Exception in component tOracleOutput_1
java.lang.ArrayIndexOutOfBoundsException: -32453
@AToracle.jdbc.driver.OraclePreparedStatement.setupBindBuffers(OraclePreparedStatement.java:2677)
@AToracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9270)
@AToracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:210)
Thanks
Rick
@Ricky9905,this is Jars issue,did you verified below link?
https://community.talend.com/t5/Archive/tOracleInput-doesn-t-work-on-TOS-2-4/td-p/168948
Hi,
my solution was setting a number less than 10000 in commit size. In tOracleOutput--> Advanced Settings: Use Batch BatchSize=500 (you can try empirically another number) See the image attached.
Best regards
jaiko