• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

what is connection pooling?

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

Advance Thanx.
 
Nagendra Prasad
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.
 
bart zagers
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
 
Pradeep bhatt
Ranch Hand
Posts: 8927
Firefox Browser Java Spring
  • 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.
 
Gayathri Prasad
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic