Execution of Stored Procedure from JDBC Application Fails with No more data to read from socket Exception

(Doc ID 2389891.1)

Last updated on APRIL 25, 2018

Applies to:

JDBC - Version 12.1.0.2.0 and later
Information in this document applies to any platform.

Symptoms


After the database was patched (with <Patch:27010872> and <Patch:27010941>), the next error is reported in a WebMethods application using JDBC 12.1.0.2 and calling a stored procedure.
The application has not been changes in any way, and after the database was patched the error started happening.
 
ERROR
-----------------------
...
2018-04-06 00:30:02 EDT [...] Adapter Runtime: Error Logged. See Error log for details. Error: [...] Cannot execute the SQL statement "call stores.GET_IS_VALID( ?, ?, ?, ?, ?)". " (08000/17410) No more data to read from socket" No more data to read from socket
2018-04-06 00:30:02 EDT [...] Adapter Runtime: Error Logged. See Error log for details. Error: [...] Adapter Runtime (Adapter Service): Unable to invoke adapter service ...:....
2018-04-06 00:30:02 EDT [...] Adapter Runtime: Error Logged. See Error log for details. Error: [...] Failed to commit local transaction. "java.sql.SQLRecoverableException: No more data to read from socket" No more data to read from socket
2018-04-06 00:30:02 EDT [...] commit failed: [...] Failed to commit local transaction. "java.sql.SQLRecoverableException: No more data to read from socket" No more data to read from socket javax.transaction.xa.XAException xid = ... (1) resource = ....JDBC:...
2018-04-06 00:30:02 EDT [...] Adapter Runtime: Error Logged. See Error log for details. Error: [...] Cannot disconnect from the database. " (08000/17410) No more data to read from socket" No more data to read from socket
...


 The listener log reports the following errors at the time:

TNS-12537: TNS:connection closed
TNS-12560: TNS:protocol adapter error
 TNS-00507: Connection closed
  Linux Error: 115: Operation now in progress

Changes

 

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