java - DataSource for standalone application - no application server

Question

I want to connect to a MySQL database from a standalone application. There is no application/web server.

This page suggests that I should use DriverManager to create the connection. However this page suggests that connections created from DriverManager cannot be pooled.

However connection pooling is a must for me because the application uses various threads to write to the database concurrently, so closing/recreating connections is not optimal.

Which DataSource implementation should I use for this purpose? I looked at MysqlConnectionPoolDataSource but I am not sure if it actually implements a connection pool. I also looked at the Tomcat DataSource which I am sure implements a connection pool but I am not sure if it can be used outside Tomcat.
When I close the standalone application what should I do to release the connections/pool properly?

EDIT: It looks like the Tomcat DataSource is usable from standalone application, so I am going to use it. It also has a close method which I assume will release the connections.

Look into C3P0 or BoneCP for 3rd party connection pools, regardless of the database you are using. — Sotirios Delimanolis, Mar 23 '13 at 15:23
thanks for the suggestions. i will keep these in mind for future — arahant, Mar 23 '13 at 17:06
A `ConnectionPoolDataSource` is not a connection pool, it can be **used** by a 'normal' `DataSource` that provides pooling. — Mark Rotteveel, Mar 24 '13 at 07:41

score 1 · Answer 1 · answered Mar 23 '13 at 15:32

1

I would advise to use a library like DBPool. It'll take a lot of headaches away from you because the developer already took care of them.
To ensure proper cleanup of your connection pool, read the documentation about a JVM Shutdown hook.

answered Mar 23 '13 at 15:32

mthmulders

9,483
4
37
54

thanks for the suggestion. i will keep these in mind for future – arahant Mar 23 '13 at 17:05

score 1 · Answer 2 · edited Sep 18 '13 at 08:17

1

Take a look at Apache DBCP and DBUtils

DBCP will give you features for connection pool etc.

DBUtils will make jdbc easier for you.

As mentioned DBPool is also one, there is BoneCP and plenty pooling tools out there.

Take a look at some samples:

edited Sep 18 '13 at 08:17

Tom Anderson

46,189
17
92
133

answered Mar 23 '13 at 17:15

MrSimpleMind

7,890
3
40
45

score 1 · Answer 3 · answered Mar 23 '13 at 17:34

1

Take a look at Apache Cayenne, in doc read about DataSource and faq about connection pools

EDIT:

As a bonus you get modeler (graphical tool for database) and easy integration with Eclipse.

answered Mar 23 '13 at 17:34

1ac0

2,875
3
33
47

java - DataSource for standalone application - no application server

3 Answers3

Linked

Related