My Oracle Support Banner

Batch Cannot Handle Multi Threaded Jobs With Error "java.sql.SQLRecoverableException: IO Error: Connection reset" (Doc ID 2012187.1)

Last updated on APRIL 09, 2024

Applies to:

Oracle Utilities Framework - Version 4.2.0.2.0 and later
Information in this document applies to any platform.

Symptoms

**Disclaimer:** This KM article may include the following abbreviations:

UCP - Universal Connection Pool

 

Submit job using submitjob.sh for several times, in this customer's case, if the job submited less than 6 time, the job runs fine.
If submit for over 6 times, the jobs starting failure with error:

(DEVBCH: submitjob.TD-XAIDN.20150514172243744.26617.log):
-  2015-05-14 17:26:38,648 [main] ERROR (shared.common.UCPConnectionProvider) Unexpected Pool Setup Exception
java.sql.SQLException: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLRecoverableException: IO Error: Connection reset
        at oracle.ucp.util.UCPErrorHandler.newSQLException(UCPErrorHandler.java:488)
        at oracle.ucp.util.UCPErrorHandler.throwSQLException(UCPErrorHandler.java:163)
       
Caused by: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLRecoverableException: IO Error: Connection reset

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!


In this Document
Symptoms
Changes
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.