Receiving 'No More Data To Read From Socket Error' and ORA-1013 From Application using Universal Connection Pool (Doc ID 1547604.1)

Last updated on JUNE 05, 2023

Applies to:

Symptoms

Java application running in Tomcat and using JDBC 11.2.0.2 with Universal Connection Pool (UCP) 11.2.0.2 fails intermittently with error:

org.springframework.dao.DataAccessResourceFailureException: Sql operation; SQL []; No more data to read from socket;
nested exception is java.sql.SQLRecoverableException: No more data to read from socket
Caused by: java.sql.SQLRecoverableException: No more data to read from socket


Along with the java.sql.SQLRecoverableException: No more data to read from socket, the following error stack occurs during execution of a query:

java.sql.SQLTimeoutException: ORA-01013: user requested cancel of current operation
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1010)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1185)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3620)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)

Cause

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