I'm a little surprised to discover very little material (at least, that I've been able to find) comparing Commons DBCP, Proxool and c3p0. Besides the obvious performance/stress comparisons, I have had trouble even finding much in the way of people expressing a preference.
So if you're using one of these pools, or another non-app-server pool, what are you using, and why?
For myself, I was a little disappointed to discover that DBCP's logging capabilities are pretty poor; I'm trying to tune an application to hold onto connections
a little longer, and short of using something else (P6Spy, Oracle Trace?), I haven't found a way to get DBCP to tell me what it's doing. I don't mind if this is a dev-only setting, but I'd prefer a little visibility so that I could convince myself that I've got the settings the way I want them.