Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
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
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.