users@glassfish.java.net

Re: JDBC Connection leak... how to spot the place?

From: Jagadish Prasath Ramu <Jagadish.Ramu_at_Sun.COM>
Date: Fri, 16 Apr 2010 23:30:20 +0530

You can use connection leak tracing to figure out the block of
application code that is leaking the connections.
You can refer :
http://blogs.sun.com/kshitiz/entry/connection_leak_tracing

Thanks,
-Jagadish

On Fri, 2010-04-16 at 19:41 +0200, Dominik Dorn wrote:
> Hi!
>
> I've ported a fairly large PHP application to glassfish v3 + quercus.
> Now I have the problem that somewhere JDBC-Connections don't get
> closed and the number open connections continuously grow until
> the max-pool-size is reached and the app stops working .
>
> I'm getting: java.sql.SQLException: Error in allocating a connection.
> Cause: In-use connections equal max-pool-size and expired
> max-wait-time. Cannot allocate more connections.
>
> I have connected myself to the server with JConsole, but now I'm somehow
> lost... I'm able to see some nice graphs, a list of threads and to
> browse MBeans.
>
> I'm also trying VisualVM, but I'm lost here also, as I have never used
> tools like that...
>
>
> Any help would be greatly appreciated.
>
>
> thanks,
> dominik
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
> For additional commands, e-mail: users-help_at_glassfish.dev.java.net
>