My Oracle Support Banner

Java.sql.SQLException: No More Data To Read From Socket Until Database Shared Pool is Flushed (Doc ID 2348386.1)

Last updated on FEBRUARY 03, 2019

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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