My Oracle Support Banner

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

To view full details, 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 a vibrant support community of peers and Oracle experts.