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 DECEMBER 14, 2018

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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.