What JDBC connector are you using?

C3P0 was the way to go, but also seem to be dead at the moment.
See for example: http://stackoverflow.com/questions/5640 ... ce-in-2011
Tomcat 7 also complaints about C3P0 not cleaning up his threads very well, leaving memory leaks behind.

So what is the "best" choice?
Maybe BoneCP?

- Ed

jdbc connector or do you mean jdbc pool (which is what c3p0 is used to be).
Right now i am using the tomcat jdbc pool, works fine.

http://people.apache.org/~fhanik/jdbc-p ... -pool.html

Is also available as maven artifact and does work standalone (without tomcat or any other container).

Thanks.
> jdbc connector or do you mean jdbc pool (which is what c3p0 is used to be).
Pool.

How do you use the tomcat pool outside of the tomcat container for unit testing against the db?
I read somewhere on the net that you are locked to Tomcat ?
How about BoneCP?

I'm using BoneCP and haven't had any problems so far and it seems to be pretty fast (supposedly much faster than c3p0 and most other poolers).