File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
Author

Stale connection exception

Ganesan Ramakrishnan
Ranch Hand

Joined: Mar 18, 2008
Posts: 88
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
    
    1
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,

 
Don't get me started about those stupid light bulbs.
 
subject: Stale connection exception