That previous mail was send too fast, here is the answer to your last
question:
* Can we find out if we can programmatically know how many
Connections are there in the pool, how many are active, how many are
idle, etc? This is just to print these statistics (may be once an hour)
in the log file to ensure nothing is fishy with DB level.
Yes, if you cast the DataSource to the specific implementation then you
can print out usage statistics:
BasicDataSource bds = (BasicDataSource) ds;
System.out.println("NumActive: " + bds.getNumActive());
System.out.println("NumIdle: " + bds.getNumIdle());
Regards
Dirk
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
