Application Returns Error "java.sql.SQLException Closed Connection" When Using A Datasource (Doc ID 883326.1)

Last updated on MAY 25, 2023

Applies to:

Symptoms

An application using a datasource to connect to the database returns the following error when trying to access database:

FINER: RMIServer.logError RMIServer acceptNewConnection() exception: java.net.SocketTimeoutException: Accept timed out
FINEST: EJBJoinPointImpl.invoke Invoking method public <Package_name.Function_name>
java.sql.SQLException: Closed Connection
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:175)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:240)
at oracle.jdbc.driver.PhysicalConnection.createStatement(PhysicalConnection.java:778)
at oracle.jdbc.driver.PhysicalConnection.createStatement(PhysicalConnection.java:752)
at oracle.jdbc.OracleConnectionWrapper.createStatement(OracleConnectionWrapper.java:70)
at oracle_jdbc_driver_LogicalConnection_Proxy.createStatement()...........

<applicaton trace..........>

Changes

Cause

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