Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Connection leak monitoring in GlassFish

 
Harshana Dias
Ranch Hand
Posts: 333
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic