wood burning stoves 2.0
The moose likes Websphere and the fly likes Stale connection exception Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Websphere
Bookmark "Stale connection exception" Watch "Stale connection exception" New topic

Stale connection exception

Ganesan Ramakrishnan
Ranch Hand

Joined: Mar 18, 2008
Posts: 90
Hi all,

I had an following issue on some of web pages while accessing it,

com.ibm.websphere.ce.cm.StaleConnectionException: Protocol violationDSRA0010E: SQL State = null, Error Code = 17,401
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

can anyone help on this issue?
Carles Gasques
Ranch Hand

Joined: Apr 19, 2013
Posts: 199
Hi Ganesan,

Seems that this is a known issue with websphere datasources & DB2.
According to this resource Pretesting pooled connections to ensure validity you could configure websphere datasources to remove staled connections from the pool.

Best reggards,

I agree. Here's the link: http://aspose.com/file-tools
subject: Stale connection exception
It's not a secret anymore!