topic tOracleRow in Talend Studio

tOracleRow

MZein — Sat, 16 Nov 2024 03:27:49 GMT

Hi friend

I hope I can find a solution to this persistance error.

I am using tOracleRow component with sql query and it throw the following excepion

java.sql.SQLRecoverableException: Closed Connection

why this exception and how to resolve it

Best regards

Re: tOracleRow

Anonymous — Mon, 27 Jan 2020 16:35:49 GMT

This could either be a timeout issue, a firewall issue or maybe a connection pool issue (are you using a connection pool?). What exactly are you doing with the tOracleRow component? Are you selecting, inserting or updating? Has this ever worked? How long did it take (if it has worked)? Have you tried adding an extended timeout to the additional settings?

Re: tOracleRow

MZein — Wed, 05 Feb 2020 08:33:35 GMT

Hi rhall_2

Thank you very much for your replay and I highly appreciate your interaction. I found the error. It is raised because i use tConnection component and I did some processing (read from csv file check data ) then I use the component tOracleRow. but When I use tconnection then tOracleRow the job run smoothly without error

Regards

Re: tOracleRow

Anonymous — Wed, 05 Feb 2020 11:49:31 GMT

Hmmm this sounds like it could be a DB timeout issue. Moving when you open the connection looks like it is giving you a window of time to complete your CSV read before starting your DB access. Interesting.