Execution of Stored Procedure from JDBC Application Fails with No more data to read from socket Exception (Doc ID 2389891.1)

Last updated on MARCH 14, 2023

Applies to:

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 changed in any way. 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 <PACKAGE NAME>.<PROCEDURE NAME>( ?, ?, ?, ?, ?)". " (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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.