Stale Database Connections

Greenhorn

Posts: 29

posted 17 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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,

Thanks
Kash

-------------<br />There are wheels within wheels...<br />P.G Wodehouse

Serkan Demir

Ranch Hand

Posts: 61

posted 17 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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>;

That which doesn't kill us makes us stronger. I think a piece of pie wouldn't kill me. Tiny ad:

a bit of art, as a gift, the permaculture playing cards

https://gardener-gift.com