Since as in some time the application throws below exception,
java.sql.SQLException: Error in allocating a connection. Cause: In-use connections equal max-pool-size and expired max-wait-time
I have enable monitoring JDBC Connection Pool on the relevant server instance from glass fish admin web console.
Then i remote debug the application where i hold the debug point at after get connection but before close it. Then i refresh the web administration console and check the value for NumConnFree Resource Statistics which still shows the initial value of 8. Since I am currently using a connection, it should be 7 right?
Any one face this kind of situation. I am not sure its a problem with administration web console.
Also what are other best way to monitor connection leaks?
My goal was to check the value of NumPotentialConnLeak property and check the logs specific to any leaks. But since i faced above problem i am not sure the administration console shows correct data.