Once DBCP notices a stale connection it refreshes that connection. I have been using this from a year now. Our DB is restarted every sunday morning and I rarely have problems with the connections.
DBCP seems to refresh the connections for me. But anyway my pool size is fairly low, so my connection pool is refreshed in no time. On 1/18/06, foo java <[EMAIL PROTECTED]> wrote: > > Hi, > > I am using jakarta commons DBCP package to pool the jdbc connections. I am > wondering is there any way with it to refresh the connections between pool > and database? > > Say, in case at the start the connections are established between pool and > database. Client request and return the connection to the pool. In case > because of network down or database down, the connection between pool and > db > gets broken. Is there any way to judge and refresh the connection between > pool and db?? > > Any ideas?? > > regards, > foo > >
