I am currently developing a web app using WSAD 5.1 and DB2 V7.2.8. I
understand there is a myriad of database errors related to obtaining
valid connections that are mapped directly to
com.ibm.websphere.ce.cm.StaleConnectionException. There are
apparently two solutions to ensure a valid connection is obtained from
a WebSphere dataSource. The first is to catch
StaleConnectionExceptions and attempt to execute the transaction again
a finite number of times. The second is to configure WebSphere to
test each connection as they are obtained. See link
http://publib.boulder.ibm.com/infoce...ion&maxHits=50
for details.
I would like to catch com.ibm.websphere.ce.cm.StaleConnectionException
since it is not likely that our shop will ever move our applications
off WebSphere. Does anyone know what library should be included in
the Java build path? Is this the preferred method of handling invalid
connections? I cannot seem to find any useful documentation on this
subject for WSAD 5.1. Thanks in advance.