[resolved] tooracleoutput, jdbc

One Star

[resolved] tooracleoutput, jdbc

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

Accepted Solutions
One Star

Re: [resolved] tooracleoutput, jdbc

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

All Replies
Four Stars

Re: [resolved] tooracleoutput, jdbc

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
One Star

Re: [resolved] tooracleoutput, jdbc

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

Re: [resolved] tooracleoutput, jdbc

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
One Star

Re: [resolved] tooracleoutput, jdbc

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
Four Stars

Re: [resolved] tooracleoutput, jdbc

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

Re: [resolved] tooracleoutput, jdbc

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
Four Stars

Re: [resolved] tooracleoutput, jdbc

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

Re: [resolved] tooracleoutput, jdbc

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

Re: [resolved] tooracleoutput, jdbc

Glad that it worked.
Vaibhav