Connection closed error
From: Pap <oracle.developer35_at_gmail.com>
Date: Sun, 24 Oct 2021 15:33:37 +0530
Message-ID: <CAEjw_fg13649eTy86BvoLm0is0a-tpBYh8BeuDu_vn2YArt4rA_at_mail.gmail.com>
Hello Listers, Its oracle database version 11.2.0.4. We have one of the customer java websphere applications pointing to this database encountering connection close error while doing the stored proc execution. Sometimes after a few minutes into the stored procedure call and a few times after ~2 hours into execution. In a normal scenario, this job succeeds, within <10 seconds . So during failure time, it may have been waiting for some resource or other bottleneck that resulted in long execution time. So want to understand if anybody encountered such an error and what is the cause and fix of this?
Below is the application log.
Date: Sun, 24 Oct 2021 15:33:37 +0530
Message-ID: <CAEjw_fg13649eTy86BvoLm0is0a-tpBYh8BeuDu_vn2YArt4rA_at_mail.gmail.com>
Hello Listers, Its oracle database version 11.2.0.4. We have one of the customer java websphere applications pointing to this database encountering connection close error while doing the stored proc execution. Sometimes after a few minutes into the stored procedure call and a few times after ~2 hours into execution. In a normal scenario, this job succeeds, within <10 seconds . So during failure time, it may have been waiting for some resource or other bottleneck that resulted in long execution time. So want to understand if anybody encountered such an error and what is the cause and fix of this?
Below is the application log.
com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Connection is closed.
at
com.ibm.ws.rsadapter.jdbc.WSJdbcWrapper.createClosedException(WSJdbcWrapper.java:122)
at
com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.activate(WSJdbcConnection.java:2936)
at
com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.setAutoCommit(WSJdbcConnection.java:3512)
We found below doc matching the error but it seems if it would have been this bug then rerun also would have been failed. So our case might be different.
*Protocol Violation and Connection is Closed exceptions When Using JDBC
12.1.0.2 with WebSphere (Doc ID 2359390.1)*-- http://www.freelists.org/webpage/oracle-lReceived on Sun Oct 24 2021 - 12:03:37 CEST