My Oracle Support Banner

"java.sql.SQLRecoverableException: Closed Connection" Reported By Application Intermitently (Doc ID 2849254.1)

Last updated on MARCH 16, 2022

Applies to:

JDBC - Version 12.2.0.0.0 and later
Information in this document applies to any platform.

Symptoms

An application is reporting the next error sporadically depending on the load.
No errors on the listener and alert logs.
Database is 19.12 version.
This has been tested using JDBC 18.3 and 19.3 with the same error.

ERROR
-----------------------
02/09/2022 08:51:30 [DEBUG] [] [pool-1-thread-1] ORACLE Did not match duplicate key error code: 17002
02/09/2022 08:51:30 [INFO] [] [pool-1-thread-1] Found Closed Connection: IO Error: Socket read interrupted <<<<<<<<==========
02/09/2022 08:51:30 [DEBUG] [] [pool-1-thread-1] Closed Connection
java.sql.SQLRecoverableException: Closed Connection
at oracle.jdbc.driver.PhysicalConnection.getAutoCommit(PhysicalConnection.java:1943)
at org.apache.commons.dbcp.DelegatingConnection.getAutoCommit(DelegatingConnection.java:337)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.getAutoCommit(PoolingDataSource.java:235)
at com..processRecord(RJDatabaseWriter.java:1680)
at com..processRecords(RJDatabaseWriter.java:882)
at com..RJDatabaseWriter.run(RJDatabaseWriter.java:142)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.