My Oracle Support Banner

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 SEPTEMBER 20, 2019

Applies to:

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


Java application running in Tomcat and using JDBC with Universal Connection Pool (UCP) 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(
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4C8Oall.processError(
at oracle.jdbc.driver.T4CTTIfun.receive(
at oracle.jdbc.driver.T4CTTIfun.doRPC(
at oracle.jdbc.driver.T4C8Oall.doOALL(
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(


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

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