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 laterInformation in this document applies to any platform.
Symptoms
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 |