"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 OCTOBER 25, 2016

Applies to:

JDBC - Version 10.2.0.4 and later
Information in this document applies to any platform.
***Checked for relevance on05-Mar-2013***

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

	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