File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
Author

Connection leak monitoring in GlassFish

Harshana Dias
Ranch Hand

Joined: Jun 11, 2007
Posts: 327
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.
 
Consider Paul's rocket mass heater.
 
subject: Connection leak monitoring in GlassFish