[resolved] got minus one from a read call...ERROR!

[Anonymous]

Hi,
my job consist in read froma a table and match this with other and insert in the same table. See th screenshot IS BETTER!
I have the error got minus one from a read call, randomly on the tables of the job and if i close and reopen Talend, all warks good!!!
Why?
I work on oracle 11g and windows server2008
Thanks in advance,
Gino.

[Anonymous]

Hi Sabrina,
I took your advice to use tOracleConnection, and all works FINE!
Once again you have given me useful advice!
Thanks,
Gino.

[Anonymous]

Hi,

I took your advice to use tOracleConnection, and all works FINE!
Once again you have given me useful advice!

It is a good news. BTW, tOracleConnection may refer to performance issue. If you face it, please view the related https://community.talend.com/t5/Design-and-Development/Reduce-tOracleInput-Outpu-s-performance/td-p/...
Best regards
Sabrina

[Anonymous]

Hi,
did you mean that the performance are better with tOracleConnection component? Because my performance has improved with tOracleConnection...

[Anonymous]

Hi,
Usually, using tXXXConnection component will make the performance fall. But in your old job, your design is not proper so when you use tXXXConnection, you will find the performance is good.
Best regards
Sabrina