I noticed that dbcp1.1 is out. has anyone used it with hibernate yet? Will support for it be added to the current dbcp implementation?

thanks

2.1beta6 bundles DBCP 1.1.

I have not yet tested the latest release to see if the quality is any higher than the 1.0 release. I still trust c3p0 a lot better though....

Gavin,

I hate to play devil's advocate, but how do you get around the webapp reload problem with C3P0? Every time my webapp reloads, c3p0 gets orphaned and hangs around while a new C3P0 instance is created.

I posted on this forum how the newer beta C3P0 includes a way to close C3P0 up but I'm wondering what the current solutin is?

I ended up switching to DBCP so I wouldn't have memory problems. My research didn't find anything (unless I stink at web searches) since I'd found the 2.0.3 hibernate C3P0 close function does nothing (no code in the function). :(

Thanks for any suggestions (other than: don't reload, shut fully down and restart Tomcat [4.1.24]),
David

To be honest, I've never used either of them in production - I have always had an appserver connection pool, but I have tested both for scalability.

p.s. I will try really hard to find time to make JBoss connection pool run standalon one of these days.

humble, how are you using DBCP; from within Hibernate or as a JNDI datasource set up in Tomcat?

Either way, would you mind posting the part of your configuration file which handles the DBC setup? I'm having a few problems getting this up and running and my environment appears to be the same as yours.

Thanks!

-Matt

I realize this is a terribly old post, however I thought I'd update it with our experience with DBCP 1.1.

So far everything has been going well. We're using:

Tomcat 4.1.29
MySQL 4.0.15
DBCP 1.1
Hibernate 2.0.3

We have the DBCP pool set up as a datasource in the Server.xml file of Tomcat. We've been running this in production now for a little over a month. I make daily visual checks of the logs (this is our first deployment of our app and I'm being extra cautious) and I've not noticed anything out the ordinary.

Matt

What kind of load are we talking about here? Number of requests per second?