51 messages in org.apache.tomcat.usersRE: DBCP Woes!| From | Sent On | Attachments |
|---|---|---|
| Peng Annie | Oct 28, 2002 3:57 am | |
| Shapira, Yoav | Oct 28, 2002 6:02 am | |
| Robert L Sowders | Oct 28, 2002 12:58 pm | |
| Shapira, Yoav | Oct 28, 2002 1:07 pm | |
| Ricky Leung | Oct 28, 2002 3:22 pm | |
| Craig R. McClanahan | Oct 28, 2002 3:48 pm | |
| Craig R. McClanahan | Oct 28, 2002 4:15 pm | |
| neal | Oct 28, 2002 4:24 pm | |
| neal | Oct 28, 2002 4:55 pm | |
| Mike Jackson | Oct 28, 2002 4:55 pm | |
| neal | Oct 28, 2002 4:58 pm | |
| Robert L Sowders | Oct 28, 2002 5:42 pm | |
| Robert L Sowders | Oct 28, 2002 5:50 pm | |
| Bill Barker | Oct 28, 2002 11:13 pm | |
| Peng Annie | Oct 29, 2002 12:27 am | |
| David Tildesley | Oct 29, 2002 12:39 am | |
| Robert L Sowders | Oct 29, 2002 12:57 am | |
| Robert L Sowders | Oct 29, 2002 1:04 am | |
| Peng Annie | Oct 29, 2002 1:08 am | |
| Robert L Sowders | Oct 29, 2002 2:01 am | |
| Mike Jackson | Oct 29, 2002 3:24 pm | |
| neal | Oct 29, 2002 3:39 pm | |
| Mike Jackson | Oct 29, 2002 3:43 pm | |
| Mike Jackson | Oct 29, 2002 4:02 pm | |
| micael | Oct 29, 2002 4:05 pm | |
| neal | Oct 29, 2002 4:21 pm | |
| neal | Oct 29, 2002 4:31 pm | |
| neal | Oct 29, 2002 4:52 pm | |
| Iain Sanderson | Oct 29, 2002 4:57 pm | |
| micael | Oct 29, 2002 5:08 pm | |
| neal | Oct 29, 2002 5:15 pm | |
| Brandon Cruz | Oct 29, 2002 5:17 pm | |
| neal | Oct 29, 2002 5:35 pm | |
| V. Cekvenich | Oct 29, 2002 5:37 pm | |
| neal | Oct 29, 2002 5:43 pm | |
| neal | Oct 29, 2002 6:20 pm | |
| neal | Oct 29, 2002 6:47 pm | |
| Jacob Kjome | Oct 29, 2002 9:00 pm | |
| Craig R. McClanahan | Oct 29, 2002 10:15 pm | |
| neal | Oct 30, 2002 1:34 am | |
| Reynir Hübner | Oct 30, 2002 2:17 am | |
| Luc Santeramo | Oct 30, 2002 2:21 am | |
| neal | Oct 30, 2002 2:21 am | |
| neal | Oct 30, 2002 3:14 am | |
| omar...@telebahiacelular.com.br | Oct 30, 2002 3:50 am | |
| Tim Funk | Oct 30, 2002 3:54 am | |
| neal | Oct 30, 2002 4:40 am | |
| Mike Jackson | Oct 30, 2002 8:55 am | |
| Mike Jackson | Oct 30, 2002 8:58 am | |
| Craig R. McClanahan | Oct 30, 2002 9:50 am | |
| neal | Oct 30, 2002 1:10 pm |
| Subject: | RE: DBCP Woes! | |
|---|---|---|
| From: | Craig R. McClanahan (crai...@apache.org) | |
| Date: | Oct 28, 2002 4:15:26 pm | |
| List: | org.apache.tomcat.users | |
On Mon, 28 Oct 2002, neal wrote:
Date: Mon, 28 Oct 2002 16:58:53 -0800 From: neal <neal...@yahoo.com> Reply-To: Tomcat Users List <tomc...@jakarta.apache.org> To: Tomcat <tomc...@jakarta.apache.org> Subject: RE: DBCP Woes!
I was releasing them in the Try, not the finally - just after requesting a connection and using a connection.
In other words, if any sort of exception occurred *after* the connection was retrieved and *before* the connection was closed, the close would get skipped, right?
I see your point that this isn't ideal and I should change definitely change this.
It's far worse than "not ideal" -- it's basically broken. A fundamental principle of borrowing resources from a pool (be they connections or whatever) is that you must *always* return them, no matter what happens.
Still though, unless enough errors occured (after the conneciton requerst and before the conneciton release) to deplete my pool (in this case 100), this shouldn't have exhausted my pool shoult it have?
Sounds like you might want to put some counters and/or debug logging into your code and do some tests to demonstrate what's really happening. Don't forget to check 100% of the places that you use connections from the pool, from the moment that Tomcat is started.
Thanks. Neal
Craig
-----Original Message----- From: Dan Lipofsky [mailto:dan...@nuserve.com] Sent: Monday, October 28, 2002 3:55 PM To: neal...@yahoo.com Subject: Re: DBCP Woes!
Are you releasing connections in the "finally" block of a try/catch/finally statement? - Dan
DBCP works fine initially but seems the conn pool is exhausted quickly, as if the connections aren't being released. But I made sure last night that every Sonnection and Statement object is closed and nullified so I am suprised Im still having this error.
On thing of interested. Prior to receiving the connection pool exhausted error, I recieve this error:
javax.naming.NameNotFoundException: Name jdbc is not bound in this Context
Might this mean there is something else, other than simple release of Connections happening here? Any ideas what this might mean?