topic Re: [resolved] tooracleoutput, jdbc in Talend Studio

[resolved] tooracleoutput, jdbc

Anonymous — Thu, 10 Jul 2014 09:45:45 GMT

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

Re: [resolved] tooracleoutput, jdbc

Anonymous — Thu, 10 Jul 2014 09:48:36 GMT

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

Re: [resolved] tooracleoutput, jdbc

Anonymous — Thu, 10 Jul 2014 10:02:48 GMT

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

Re: [resolved] tooracleoutput, jdbc

Anonymous — Thu, 10 Jul 2014 10:27:01 GMT

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

Re: [resolved] tooracleoutput, jdbc

Anonymous — Thu, 10 Jul 2014 10:35:50 GMT

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

Re: [resolved] tooracleoutput, jdbc

Anonymous — Thu, 10 Jul 2014 10:50:22 GMT

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

Re: [resolved] tooracleoutput, jdbc

Anonymous — Thu, 10 Jul 2014 11:30:57 GMT

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

Re: [resolved] tooracleoutput, jdbc

Anonymous — Thu, 10 Jul 2014 11:58:23 GMT

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

Re: [resolved] tooracleoutput, jdbc

Anonymous — Thu, 10 Jul 2014 12:10:33 GMT

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

Re: [resolved] tooracleoutput, jdbc

Anonymous — Thu, 10 Jul 2014 12:22:36 GMT

Glad that it worked.
Vaibhav