Get active/inactive connections info from pool  
Zoran Thu Oct 22 09:15:18 BST 2009
 
I'm using an older version of Primrose 2.7.0 and I wonder if
there is a way that I can list all connections from pool in my java program and see what is the status of those connections (active, inactive, idle for n seconds, ...).

Best regards,
Zoran

 
Zoran Thu Oct 22 10:57:47 BST 2009
 
And I'm using Primorose as standalone pool.
sedj Thu Oct 22 17:21:47 BST 2009
 
I would recommend upgrading to the latest version - its quite easy to get the information you require using this.
You can either configure a WebConsole to display the pools, or use the following code :

Pool pool = PoolLoader.findExistingPool("my-pool-name");
Vector connections = pool.getPoolConnections();
// ConnectionHolder has info about each connection
Zoran Mon Oct 26 08:29:58 GMT 2009
 
Thanks sedj!

I will do as you suggested.

Best regards,
Zoran