All, I use WAS 5.X and use connection pooling for obtaining database connections. However i get "connection closed" exception, and i traced it back to the stale connections in the pool. How do i identify from java code or any other means that a connection has become stale and obtain a new connection?
Any help is appreciated,
-------------<br />There are wheels within wheels...<br />P.G Wodehouse
posted 10 years ago
a common solution for this pooling problem is to run a pinger thread to send keep alive query (e.g: select 1 from anytable)to all connections in the pool with a constant frequency. By the way, connections wouldn't be stale anymore.
A guy from Turkey<br /><a href="http://blogspot.serkandemir.com" target="_blank" rel="nofollow">http://blogspot.serkandemir.com</a>