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 12.1.0.2.0 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.0.2.0 version, Thin JDBC driver


No more data to read from socket exception is received only once a month from an application using JDBC 12.1.0.2 against a 12.1.0.2 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



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