Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

ConnectionClosedException - subclass of StaleConnectionException?

32 views
Skip to first unread message

seem...@rediffmail.com

unread,
Mar 17, 2009, 12:47:07 PM3/17/09
to
hi,

We are randomly getting this error in production. Our WAS version is 6.1 and Oracle version is 9i. Is ConnectionClosedException a subclass of StaleConnectionException? Do we need to retry the transaction if this occurs or can it be rectified by tuning any settings?

com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Connection is closed.
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.runtimeXIfNotClosed(WSJdbcConnection.java:2657)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java:2151)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java:2038)

Thanks,
Seema

seem...@rediffmail.com

unread,
Mar 17, 2009, 12:52:37 PM3/17/09
to
Just wanted to add that "Pretest existing pooled connections' and 'Pretest new connections' check boxes are already checked in our data source properties. We are using a clustered deployment (ND) of WAS.

Please share your thoughts.

Thanks,
Seema

Brian S Paskin

unread,
Mar 17, 2009, 1:02:39 PM3/17/09
to
Hi, I believe those messages will be in the log even during the prefetch when a connection is not available. You probably want to set the aged timeout or unused timeout to less than DB connection timeout. This will not resolve the issue totally, but you should see much less of the stale connection in the logs.

Regards,
Brian

0 new messages