java.sql.SQLRecoverableException: Closed Connection (Doc ID 3076199.1)

Last updated on MARCH 12, 2025

Applies to:

Symptoms

The following exception is received in production and pre-production systems. UCP version is 21.7.0.0

ERROR
-----------

java.sql.SQLRecoverableException.No more data to read from socket

at oracle.jdbc.driver.T4CMAREngineNIO.prepareForUnmarshall(T4CMAREngineNIO.java:850)
at oracle.jdbc.driver.T4CMAREngineNIO.unmarshalUB1(T4CMAREngineNIO.java:482)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:617)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:294)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:493)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:147)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:932)
at oracle.jdbc.driver.OracleStatement.prepareDefineBufferAndExecute(OracleStatement.java:1167)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1096)
at oracle.jdbc.driver.OracleStatement.executeSQLSelect(OracleStatement.java:1421)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1304)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3741)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3850)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1093)
at oracle.ucp.jdbc.proxy.oracle$1ucp$1jdbc$1proxy$1oracle$1StatementProxy$2oracle$1jdbc$1internal$1OraclePreparedStatement$$$Proxy.executeQuery(Unknown Source)
at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:722)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:648)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:713)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:744)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:757)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:810)
at org.springframework.jdbc.core.JdbcTemplate.queryForList(JdbcTempla

Cause

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