File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes need help on Connection Pooling Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "need help on Connection Pooling " Watch "need help on Connection Pooling " New topic

need help on Connection Pooling

Mayilsamy Annamalai
Ranch Hand

Joined: Sep 18, 2010
Posts: 35


I'm developing a simple application. I'll like to implement the connection pooling in my application. When i searched the net i can able to see lot of examples but at end of the session i'm not able to understand even a single method.. Could any please explain me which is best and we can go for it..
Mayilsamy Annamalai
Ranch Hand

Joined: Sep 18, 2010
Posts: 35

Is any body can help out??
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 33102

Which connection pooling library were you looking at? Typically there is only one method - getConnection() if that. Most of the time there is just a connection pool driver. You say how many connections you want and everything happens behind the scenes.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
Rob Spoor

Joined: Oct 27, 2005
Posts: 20271

Mayilsamy Annamalai wrote:Is any body can help out??


How To Ask Questions How To Answer Questions
Brian Enochson

Joined: Apr 12, 2011
Posts: 14

A common free one used in the Java world is Apache Database Connection Pool (DBCP). This is specifically for pooling of data sources and builds on the common pool library which provides generic object pooling functionality.

DBCP has a couple of versions, 1.4 is for Java 6 and 1.3 for Java 5 and earlier. It comes with a good set of examples and there is plenty of reference material on the web.

As to your post, were you looking for a recommendation then I can say I have used this before. If you need examples of how to use it, I would look first in the examples.

I agree. Here's the link:
subject: need help on Connection Pooling
It's not a secret anymore!