I'm using Hibernate with MySQL but dbcp and c3p0 seem not stable. sometime, my site down, it throw a "cannot open connection" exception.
What is the best stable connection pool ? Thank you.

I dunno, but we've been using Proxool with some success for about 12 - 18 months now.

I believe the Hibernate team recommend c3p0 over DBCP.

They're all open source projects, you might find it useful to look at the sourcecode for each of them. They're not that big and you don't have to understand it all anyway.

When we were evaluating connection pools, I just wanted a general feel for the quality of the code (quite subjective to me of course) for each of them.

Without saying bad things about anyone's code (apparently, it's bad form to tell people when their code blows) , Proxool came out a long way in front for me. It has debugging, and decent exception handling code sprinkled throughout. It seemed to me that exception handling particularly was a bit of an afterthought for the other two (especially DBCP).


Anyway, like I said, that was a subjective perception and maybe things have changed since then.

go for c3p0 or proxool

also use appserver datasource if you have one