Search code examples
javasql-serverswingdesktop-applicationconnection-pooling

Connection pooling in Swing based Application

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.

Solution

  • Yes you can use C3P0

    There are many connection pooling libraries in fact.