Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team ,
Could you help in below error resolution : Faced when i defined packet size to read DB records .
java.sql.SQLRecoverableException: Closed Connection
at oracle.jdbc.driver.PhysicalConnection.needLine(PhysicalConnection.java:3525)
Thanks in advance
Hi @Not defined Not defined , Have you tried to increase the timeout of your connection ?
Send me love and kudos
Hello,
The most likely cause is a firewall between you and the database that is killing connections after a certain amount of idle time.
Best regards
Sabrina
Exception in component tDBInput_1 (JobMsreels)
java.sql.SQLRecoverableException: Closed Connection
I got above error.What is the solution for above error
Hello @Navyasri Nekkanti
It looks like it could be a DB timeout issue. Did you use any tDBConnection component in your workflow and have you tried adding an extended timeout to the additional settings?
Best regards
Sabrina
Hi ,
I don't have option of extended timeout option in tDB connection.
Is there any option to resolve this issue.