Connection Pooling in Java SE?

It is hard to开发者_高级运维 find a resource on this without finding Java EE, but here is what I am looking for:

All I have is a standard Java SE app, it makes a lot of DB connections. I simply need to make use of a connection pool. Any suggestions?

I would suggest c3p0. There is also this other question which discusses c3p0 vs DBCP and several stand-alone connection pools.

Can I also suggest BoneCP (http://jolbox.com) ? It is currently the fastest connection pool available and offers a good feature set.

Here are two options that don't require any Java EE:

C3P0 - I have used this pool library for a long time in a Java SE app but it does not support the new Java 6 JDBC interfaces. You can still use the pool Java 6 but if you try and call any of the new methods an exception is thrown saying that the method is not implemented.

DBCP - I have never used this connection pool myself but I have seen various posts about it, and it does support the new JDBC features added in Java 6

javax.sql.DataSource provides a connection pool, and most DB vendors provide an implementation of DataSource.

Here is a list of Java connection pool libraries. I have only used c3po out of these, as part of Hibernate, and so far it works fine (as much as I actually see of it... but I guess if I rarely ever notice the connection pooling software I am using, then it is working well ;-)

Take a look at HikariCP. Even BoneCP's author admits it is now the king of the hill.