Connection Pooling in Java SE?

Question

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?

JDBC drivers all use sockets to do the low level reading/writing of data to the DB. Only a nut would do it this way if a JDBC driver is available. — mP., Mar 08 '10 at 00:48

score 5 · Accepted Answer · edited May 23 '17 at 12:19

5

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

edited May 23 '17 at 12:19

Community

1
1

answered Mar 07 '10 at 14:45

ewernli

38,045
5
92
123

score 3 · Answer 2 · edited Sep 04 '12 at 20:20

3

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

edited Sep 04 '12 at 20:20

Arjan Tijms

37,782
12
108
140

answered Mar 07 '10 at 14:48

Yanamon

630
3
11

1

In DBCP everything is synchronized to a single thread. If your app is multiuser/multithreaded, C3P0 is a better choice. – BalusC Mar 07 '10 at 15:03

score 3 · Answer 3 · answered Apr 22 '10 at 13:31

3

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

answered Apr 22 '10 at 13:31

wwadge

3,506
1
19
28

1

It looks like [over here](http://stackoverflow.com/a/1662916/311525) you now feel that there is another connection pool which is faster. – Scott Dec 30 '13 at 16:56

score 2 · Answer 4 · answered Mar 08 '10 at 00:26

2

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

answered Mar 08 '10 at 00:26

user207421

305,947
44
307
483

score 1 · Answer 5 · edited May 23 '17 at 12:03

1

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

edited May 23 '17 at 12:03

Community

1
1

answered Dec 30 '13 at 16:54

Scott

16,711
14
75
120

score 1 · Answer 6 · answered Mar 07 '10 at 14:45

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 ;-)

Connection Pooling in Java SE?

6 Answers6