topic Re: java.sql.SQLRecoverableException: Closed Connection at oracle.jdbc.driver.PhysicalConnection.needLine(PhysicalConnection.java:3525) in Talend Studio

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

Gagan1 — Fri, 15 Nov 2024 23:42:10 GMT

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

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

gjeremy1617088143 — Thu, 23 Sep 2021 06:44:52 GMT

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

Send me love and kudos

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

Anonymous — Fri, 24 Sep 2021 02:52:34 GMT

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

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

NNekkanti1658462243 — Mon, 14 Nov 2022 11:08:17 GMT

Exception in component tDBInput_1 (JobMsreels)

java.sql.SQLRecoverableException: Closed Connection

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

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

Anonymous — Tue, 15 Nov 2022 03:24:31 GMT

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

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

NNekkanti1658462243 — Tue, 15 Nov 2022 04:06:09 GMT

Hi ,

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

Is there any option to resolve this issue.