File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Glassfish and the fly likes Connection leak monitoring in GlassFish Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Glassfish
Bookmark "Connection leak monitoring in GlassFish" Watch "Connection leak monitoring in GlassFish" New topic

Connection leak monitoring in GlassFish

Harshana Dias
Ranch Hand

Joined: Jun 11, 2007
Posts: 331
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.
I agree. Here's the link:
subject: Connection leak monitoring in GlassFish
It's not a secret anymore!