It is hard to find a resource on this without finding J2EE, but here is what I am looking for:
All I have is a standard J2SE app, it makes a lot of DB connections. I simply need to make use of a connection pool. Any suggestions?
+1
A:
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 ;-)
Péter Török
2010-03-07 14:45:33
+5
A:
I would suggest c3p0. There is also this other question which discusses c3p0 vs DBCP and several stand-alone connection pools.
ewernli
2010-03-07 14:45:37
+3
A:
Here are two options that don't require any J2EE:
C3P0 - I have used this pool library for a long time in a J2SE 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
Yanamon
2010-03-07 14:48:50
In DBCP everything is synchronized to a single thread. If your app is multiuser/multithreaded, C3P0 is a better choice.
BalusC
2010-03-07 15:03:06
+1
A:
javax.sql.DataSource provides a connection pool, and most DB vendors provide an implementation of DataSource.
EJP
2010-03-08 00:26:37