"No More Data To Read From Socket" After JDBC Upgrade to 10.2.0.4 Against Oracle Server 10.2.0.3 (Doc ID 821147.1)

Last updated on MARCH 12, 2019

Applies to:

Symptoms

After upgrading Oracle database from 9.2.0.6 to 10.2.0.3, and upgrading Oracle JDBC to 10.2.0.4, the following error is obtained every time a query is run and more than one record gets returned in a Websphere application:

com.ibm.websphere.ce.cm.StaleConnectionException: No more data to read from socket
CONTAINER:atg.repository.RepositoryException;
SOURCE:com.ibm.websphere.ce.cm.StaleConnectionException: No more data to read from socket

If the query only finds one record (or none) no error gets thrown; in the case of one record the data is successfully retrieved.

If JDBC 9i is used instead of 10g, the issue does not occur.

If JDBC 10.2.0.4 is used against a 10.2.0.4 database, the issue does not occur.

Changes

Upgrade RDBMS to 10.2.0.3.0
Upgrade JDBC driver to 10.2.0.4.0

Cause

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