wood burning stoves 2.0*
The moose likes JDBC and the fly likes Stale Database Connections Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Stale Database Connections" Watch "Stale Database Connections" New topic
Author

Stale Database Connections

Kash Mhai
Greenhorn

Joined: Apr 01, 2005
Posts: 29
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

Joined: Feb 03, 2005
Posts: 61
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>
 
 
subject: Stale Database Connections