Java.sql.SQLException: No More Data To Read From Socket Until Database Shared Pool is Flushed

(Doc ID 2348386.1)

Last updated on JANUARY 12, 2018

Applies to:

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


On : version, Thin JDBC driver

No more data to read from socket exception is received only once a month from an application using JDBC against a database.
When the shared pool is flushed, the application works fine without this error for some time..

The exception occurs on the same package call every time.

 [2017-11-06 20:02:00,304] [pool-6-thread-6] ERROR TargetMoveManager: TARGET VALIDATE FAILED: {call PKG_MTT_COMMON.INSERT_FUND_IO_10_1(?,?,?)}
[2017-11-06 20:02:04,581] [pool-6-thread-1] ERROR TargetServiceDAOImpl: Error moving to target
java.sql.SQLException: No more data to read from socket


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