This week's book giveaway is in the OCPJP forum.
We're giving away four copies of OCA/OCP Java SE 7 Programmer I & II Study Guide and have Kathy Sierra & Bert Bates on-line!
See this thread for details.
The moose likes JDBC and the fly likes what is connection pooling? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "what is connection pooling?" Watch "what is connection pooling?" New topic
Author

what is connection pooling?

Krishna Srinivasan
Ranch Hand

Joined: Jul 28, 2003
Posts: 1844

what is connection pooling?

Advance Thanx.


Krishna Srinivasan
Spring Tutorials, OCAJP Mock Questions, 400+ OCPJP Mock Questions
Nagendra Prasad
Ranch Hand

Joined: Jul 11, 2002
Posts: 219
Connection Pooling is a wayof handling connections to the database. The application server would create a set number of connections to the datasource (i,e the database) and would allow the users to use these connections within their code.
Obtaining a connection to a DB is considered to be a costly operation and hence creating a pool at appserver startup is thought to overcome some of the performance problems.


Best Regards,<br />Nagendra Prasad.
bart zagers
Ranch Hand

Joined: Feb 05, 2003
Posts: 234
Are there any good, free implementations around that can be recommended?
The application would be client-side multi-threaded, so the one that comes with an application server is not what I'm looking for.
Bart.
[ September 12, 2003: Message edited by: Bart Sawyer ]
Nagendra Prasad
Ranch Hand

Joined: Jul 11, 2002
Posts: 219
Bart.. I think some where in my code archive I have an implementation of the connection pool for Oracle. Not sure if that is what u are looking for... this was a pre-datasource in application servers think... if u need this I could zip it up.. i know at the time it was based on some freebie that was on the net.. i have lost info on where i got it from.. but I HAVE it...if u need this let me know..i would need an email to send it to
Pradeep bhatt
Ranch Hand

Joined: Feb 27, 2002
Posts: 8919

Check out for DbConnectionBroker at www.javaexchange.com


Groovy
bart zagers
Ranch Hand

Joined: Feb 05, 2003
Posts: 234
Thanks for the offer Nagendra,
but currently I'm working with a DB2/400,
Oracle is not really my thing for the moment.
Bart.
Gayathri Prasad
Ranch Hand

Joined: Jun 25, 2003
Posts: 116
Hi,
Essentially the term means your are creating a pool of connections. Getting connected to Database is an expensive deal from the resource n time consumed point of view. Thus we create typically a specific n - no of connections that would be established when the app. server is up.
Cheers,
Gaya3
 
Don't get me started about those stupid light bulbs.
 
subject: what is connection pooling?