[resolved] tooracleoutput, jdbc

[Anonymous]

Hi talend pro,
I have TOS version 5.4.1,
and I would use toracleouput for insert my data from a .txt file to an oracle table
but the problem is the component toracleoutput insert and commit just the fist 10000 lines and in the second commit bum error :
Exception in component tOracleOutput_1
java.lang.ArrayIndexOutOfBoundsException: -32353
at oracle.jdbc.driver.OraclePreparedStatement.setupBindBuffers(OraclePreparedStatement.java:2677)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9270)
at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:210)
i see in the forum but i can't resolve this problem i change value of commit every
and the batch size int the advanced settings but no way same error
what should i do ? can you help me please

Thanks
Fetyna

[Anonymous]

Hi Fetyna,
java.lang.ArrayIndexOutOfBoundsException: -32353- This exception occurs when during processing if some condition is not available.. are you doing any string handling steps during your flow... can you tell what you are doing in the job with the input data and what is your job design?
thanks
Vaibhav

[Anonymous]

Thanks Vaibhav for your reply
in my job i use tfileinputdelimited--> tmap---> toracleoutput
so what should i do ?

[Anonymous]

Hi,
If you are not performing any string handling operations..
Use connection component, enable autocommit, in tPreJob and Enable use existing connection in your output component, disable batchsize... disable die on erro..connect reject.. to logrow and check again..
Vaibhav

[Anonymous]

I disable use batch size
and i make in the commit every the number of lines in the file.txt
the job inserts the totally of lines but there is an error in toracleouput
you can see in the snop show
any help please !
thanks

[Anonymous]

You haven't used reject... you would get errorneous records.. connect reject to some output and then check
Vaibhav

[Anonymous]

it is strange !
how can exist an erroneous records and toraleouput load exactly all lines in the file ?
how can do the reject ?
thanks Vaibhav for your help

[Anonymous]

Sorry... I haven't carefully read your statement that all the records were inserted.....
There must be some other problem...

[Anonymous · Accepted solution]

no problem Vaibhav
I resolve the problem by disabling use batch size and runs properly
thanks for your help

[Anonymous]

Glad that it worked.
Vaibhav