"No More Data To Read From Socket" After JDBC Upgrade to 10.2.0.4 Against Oracle Server 10.2.0.3
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***
After upgrading Oracle database from 18.104.22.168 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
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