"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 laterInformation 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
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
Symptoms |
Changes |
Cause |
Solution |
References |