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:
JDBC - Version 11.2.0.1.0 and laterUniversal 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
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 |
Cause |
Solution |