Re: Connection closed error

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