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 MARCH 08, 2017

Applies to:

JDBC - Version 11.2.0.1 and later
Universal Connection Pool - Version 11.2.0.1.0 and later
Information in this document applies to any platform.

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms