"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:JDBC - Version 10.2.0.4 and later
Information in this document applies to any platform.
***Checked for relevance on05-Mar-2013***
After upgrading Oracle database from 126.96.36.199 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.
Upgrade RDBMS to 10.2.0.3.0
Upgrade JDBC driver to 10.2.0.4.0
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