java.sql.SQLRecoverableException: Closed Connection at oracle.jdbc.driver.PhysicalConnection.needLine(PhysicalConnection.java:3525)

[Gagan1]

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

[gjeremy1617088143]

Hi @Not defined Not defined​ , Have you tried to increase the timeout of your connection ?

Send me love and kudos

[Anonymous]

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

[NNekkanti1658462243]

Exception in component tDBInput_1 (JobMsreels)

java.sql.SQLRecoverableException: Closed Connection

I got above error.What is the solution for above error

[Anonymous]

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

[NNekkanti1658462243]

Hi ,

I don't have option of extended timeout option in tDB connection.

Is there any option to resolve this issue.