Re: dbcp pool freezing

2009-02-04 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Eric, Eric B. wrote: I've been trying to figure out how to create a Wrapper of SqlConnection, but am having trouble getting this to work. Would you mind giving me a couple of pointers where to start? See the thread from last week with the

Re: dbcp pool freezing

2009-02-04 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Eric, Eric B. wrote: I'm happy to test out an validate that theory, but based on what I've seen so far, this isn't the case at all. Try deploying nothing in your application but the following JSP. Browse to it, and intentionally leak a

Re: dbcp pool freezing

2009-02-04 Thread Eric B.
Christopher Schultz ch...@christopherschultz.net wrote in message news:4989df6b.3030...@christopherschultz.net... -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Eric, Eric B. wrote: I'm happy to test out an validate that theory, but based on what I've seen so far, this isn't the case at

RE: dbcp pool freezing

2009-02-04 Thread Caldarale, Charles R
From: news [mailto:n...@ger.gmane.org] On Behalf Of Eric B. Subject: Re: dbcp pool freezing Has there ever been any thought to doing abandoned connection tracking as a background thread, or was the current implementation decided upon to save on resources? Don't know the history of commons

dbcp pool freezing

2009-02-03 Thread Eric B.
Hi, I'm having some trouble with my dbcp pool freezing up when running a load, and am having trouble figuring out why. I have enabled JMX on the server and connected via jConsole, and see that all my threads are in the WAITING state from

Re: dbcp pool freezing

2009-02-03 Thread Philippe Martinou
that counts connection creation/close. Best regards /Philippe Eric B. a écrit : Hi, I'm having some trouble with my dbcp pool freezing up when running a load, and am having trouble figuring out why. I have enabled JMX on the server and connected via jConsole, and see that all my threads

Re: dbcp pool freezing

2009-02-03 Thread Eric B.
Philippe Martinou philippe.marti...@sparkom.com wrote in message news:49887d2f.3000...@sparkom.com... Hi, The first thing to be checked is probably your application. If some method does not properly close an SQL connection, you will have a leak that will ultimately lead to this

Re: dbcp pool freezing

2009-02-03 Thread David Boreham
Check that you don't have garbage collection problems. A heavy GC load will show up with these symptoms you are seeing (because GC stalls threads as they acquire or release locks). - To unsubscribe, e-mail:

RE: dbcp pool freezing

2009-02-03 Thread Caldarale, Charles R
From: news [mailto:n...@ger.gmane.org] On Behalf Of Eric B. Subject: dbcp pool freezing and see that all my threads are in the WAITING state from org.apache.tomcat.dbcp.pool.impl.GenericObjectPool.borrowObject (GenericObjectPool.java:810) I don't believe I have any connection leaks in my

RE: dbcp pool freezing

2009-02-03 Thread Caldarale, Charles R
From: news [mailto:n...@ger.gmane.org] On Behalf Of Eric B. Subject: Re: dbcp pool freezing Then the question becomes why aren't they being returned at all? My timeout is 20secs; I would expect, if the Abandon tracking was working properly for me, that the connections would be returned

Re: dbcp pool freezing

2009-02-03 Thread Eric B.
Philippe Martinou philippe.marti...@sparkom.com wrote in message news:49887d2f.3000...@sparkom.com... Hi, The first thing to be checked is probably your application. If some method does not properly close an SQL connection, you will have a leak that will ultimately lead to this resource

Re: dbcp pool freezing

2009-02-03 Thread Eric B.
Caldarale, Charles R chuck.caldar...@unisys.com wrote in message news:0aae5ab84b013e45a7b61cb66943c17215b600c...@usea-exch7.na.uis.unisys.com... From: news [mailto:n...@ger.gmane.org] On Behalf Of Eric B. Subject: dbcp pool freezing and see that all my threads are in the WAITING state

RE: Re: dbcp pool freezing

2009-02-03 Thread Propes, Barry L
still left open, and that can get ugly after a while, believe me. -Original Message- From: news [mailto:n...@ger.gmane.org] On Behalf Of Eric B. Sent: Tuesday, February 03, 2009 2:05 PM To: users@tomcat.apache.org Subject: Re: dbcp pool freezing Caldarale, Charles R chuck.caldar

Re: dbcp pool freezing

2009-02-03 Thread Kees Jan Koster
Dear Eric, and see that all my threads are in the WAITING state from org.apache.tomcat.dbcp.pool.impl.GenericObjectPool.borrowObject (GenericObjectPool.java:810) I don't believe I have any connection leaks in my code Belief is not a substitute for evidence... Your webapp is clearly not

Re: dbcp pool freezing

2009-02-03 Thread Eric B.
Caldarale, Charles R chuck.caldar...@unisys.com wrote in message news:0aae5ab84b013e45a7b61cb66943c17215b604a...@usea-exch7.na.uis.unisys.com... From: news [mailto:n...@ger.gmane.org] On Behalf Of Eric B. Subject: Re: dbcp pool freezing Then the question becomes why aren't they being