aspose file tools*
The moose likes JDBC and the fly likes connection pooling Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "connection pooling" Watch "connection pooling" New topic
Author

connection pooling

Gobinath Manoj
Greenhorn

Joined: Oct 17, 2007
Posts: 11
Hello Any one can tell what is connection pooling and what is use of it?

Please give me one real time example?

Because i lost the last interview for connection pooling concepts ?


Thanks Regards <br />Gobinath.L
Muhammad Saifuddin
Ranch Hand

Joined: Dec 06, 2005
Posts: 1321

Connection pooling: means of reusing connections rather than having a new one created for every connection.

like to refer to this article there you can get the clear picture of connection pooling with example code. http://www.javaranch.com/journal/200601/Journal200601.jsp#a1
another link :
http://java.sun.com/developer/onlineTraining/Programming/JDCBook/conpool.html

hope it helps.


Saifuddin..
[Blog][Linkedin] How To Ask Questions On JavaRanch My OpenSource
Les Hayden
Greenhorn

Joined: Jun 19, 2002
Posts: 28
Connection pooling uses the Java container to maintain the connection to the database. How the connection pooling is implemented is somewhat different from server to server.

You will have to create a data source and register the driver in the container and tell the container how many connections to maintain. Then register the data source through JNDI.

In your application code, you have to look up the resource through JNDI, and obtain a connection from the container as a data source. From that point on, it works just like you registered the database driver and created the connection yourself.


Les Hayden
Stan James
(instanceof Sidekick)
Ranch Hand

Joined: Jan 29, 2003
Posts: 8791
While not recommended, it's also quite possible to write your own. You can make a good generic object pool with a BlockingQueue. For a Connection pool you'd want to override Connection to put itself back in the pool when you call close(). My team uses a home-made pool that does that plus some neat automatic reconnect stuff that wasn't readily available years ago. We've just started replacing it with standard data sources and UDB features.

But back to the whole reason for all this complexity ... It's much faster to get a connection out of a pool than it is to open a new one. It's even faster to put one back instead of closing it. And if you were around for the good old Client-Server days, a company might have thousands of users with VB apps connected to a database, which puts a big load on the database. Now in multi-tier systems an application server can keep a smaller number of connections, just enough to handle concurrent requests that really run at the same time. The reduced number of connections makes life better for the database.


A good question is never answered. It is not a bolt to be tightened into place but a seed to be planted and to bear more seed toward the hope of greening the landscape of the idea. John Ciardi
 
Consider Paul's rocket mass heater.
 
subject: connection pooling