Re: Connection closed error

Thank you.

Can this be anyway related to the database or Is this error purely related to Java side connection pooling (and may be some setup issue over there) but not anyway related to database?

On Wed, Oct 27, 2021 at 12:52 AM Lok P <loknath.73_at_gmail.com> wrote:

> Don't have much idea about connection pool setup and management , but it
> seems to be related to how that is configured.
>
>
> https://www.ibm.com/docs/en/was-nd/9.0.5?topic=applications-connection-pool-settings
>
> On Sun, Oct 24, 2021 at 3:34 PM Pap <oracle.developer35_at_gmail.com> wrote:
>
>> 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-l