commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Leber, Dieter" <DIETER.LE...@NDSatcom.com>
Subject [DBCP] Question to database reconnection
Date Wed, 11 Aug 2004 15:00:33 GMT
I'm using DBCP 1.2 without using any validation of the connections 
(testOnBorrow = false, testOnReturn = false, timeBetweenEvictionRunsMillis = -1). 

When shutting down the database during running the application, the 
request using a pooled connection realizes that the database is down. 
Returning the connection to the pool seems to clean the pool (i.e. the 
pool has no active nor idle connections any longer). 

Starting the database again and demanding a connection from the 
pool a new connection is returned which has never been in the pool before.

If this is right no reconnection handling is needed at all because we always
have valid connections every time the database was down and started up again.

Can anyone please throw any light on this behaviour!? Are there 
situations where the pool is not cleaned so that validation is actually 
needed?

Dieter Leber

---------------------------------------------------------------------
To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org


Mime
View raw message