Example of a connection pool (from JIVE) (2)

// File: Part 2 of dbconnectiondefapool pool. java
/**
* Housekeeping thread. Runs in the background with low CPU overhead.
* Connections are checked for warnings and closure and are periodically
* Restarted.
* This thread is a catchall for each upted
* Connections and prevents the buildup of open cursors. (Open cursors
* Result when the application fails to close a Statement ).
* This method acts as fault tolerance for bad connection/statement programming.
*/
Public void run (){
Boolean forever = true;
Statement stmt = null;
String currCatalog = null;
While (forever ){
// Make sure the log file is the one this instance opened
// If not, clean it up!
Try {
BufferedReader in = new BufferedReader (new