• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Bear Bibeault
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Liutauras Vilda
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • fred rosenberger
  • salvin francis
Bartenders:
  • Piet Souris
  • Frits Walraven
  • Carey Brown

what is connection pooling?

 
Ranch Hand
Posts: 1880
Firefox Browser Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
what is connection pooling?

Advance Thanx.
 
Ranch Hand
Posts: 219
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Ranch Hand
Posts: 234
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 219
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Ranch Hand
Posts: 8943
Firefox Browser Spring Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Check out for DbConnectionBroker at www.javaexchange.com
 
bart zagers
Ranch Hand
Posts: 234
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for the offer Nagendra,
but currently I'm working with a DB2/400,
Oracle is not really my thing for the moment.
Bart.
 
Ranch Hand
Posts: 116
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
The overall mission is to change the world. When you've done that, then you can read this tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
    Bookmark Topic Watch Topic
  • New Topic