Two Laptop Bag*
The moose likes JDBC and the fly likes Connection pool - check what blocks connections Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Connection pool - check what blocks connections" Watch "Connection pool - check what blocks connections" New topic

Connection pool - check what blocks connections

Michal Glowacki
Ranch Hand

Joined: Mar 14, 2006
Posts: 114
hi all,

I have sometimes a problem with connections being blocked in pool. I use JBoss AS and Postgres, connection pool with standard params: max size 100, blocking timeout 30000ms. Usually I see that 0-5 connections are in use, but there are moments (once per few days, but as I keep getting more and more visitors it's more often now) when I got 60, and even 100 and start getting 'no managed connections available' error. Flushing pool helps.

Probably some parts of the code are blocking connections. How can I find them?

Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3700

I'd guess there are cases where connections aren't properly closed. All places where connections are established should be followed by a finally {} block that closes the connection.

My Blog: Down Home Country Coding with Scott Selikoff
jQuery in Action, 2nd edition
subject: Connection pool - check what blocks connections
Similar Threads
Glassfish error
What is non blocking in nio
running out of ManagedConnections available
Jboss connection pool not releasing the connection from pool
Deadlock with JDBC connection