Connection pooling in Swing based Application

Question

I have one application in Java Swing. In which i have used one connection for the application on single database. But now multiple users are usig that application , so everytime new connection is getting created. DB is coming very slow in performance; Can I use connection pooling in Swing based desktop based application. DB used is SQL server 2000.

Any help appriciated. Thanx in advance.

Of course you can use a connection pooler in a Swing application. — , May 02 '12 at 07:43
Do the Swing application connects to the database directly? Or do they connect to a server-sided application which does the database connection? — Kai, May 02 '12 at 07:46
@a_horse_with_no_name : can u please explain in which way I can move in connection pooling.Please mension the libraries which I can use.. — Sam...., May 02 '12 at 09:06

Timmo · Accepted Answer · 2012-05-02T09:30:40.530

2

Yes you can use C3P0

There are many connection pooling libraries in fact.

edited May 02 '12 at 09:30

answered May 02 '12 at 07:43

Timmo

3,142
4
26
43

..but can I use C3P0 libraries for SQL server 2000. – Sam.... May 02 '12 at 09:04
Yes you can use it with any JDBC compatible RDBMS – Timmo May 02 '12 at 09:30

score 1 · Answer 2 · edited May 23 '17 at 11:52

1

http://commons.apache.org/pool/ might be also helpful. I actually had the same question for CouchDB here: Connection pool for couchdb

edited May 23 '17 at 11:52

Community

1
1

answered May 02 '12 at 07:46

anvarik

6,417
5
39
53

Connection pooling in Swing based Application

2 Answers2

Linked