jQuery in Action, 3rd edition
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

Win a copy of Make it so: Java DB Connections & Transactions this week in the JDBC forum!
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: 32844

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: 20202

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). http://commons.apache.org/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: http://aspose.com/file-tools
subject: need help on Connection Pooling
It's not a secret anymore!