• 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

How to create a connection pool

 
Ranch Hand
Posts: 91
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,
I am very curious to know as to how do i create
connection pool,i have referred some examples but not being
able to understand it.can someone tell me the advantage of
connection pooling along with a very nice examples.
Thanks
Anand
 
Ranch Hand
Posts: 341
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi anand !
Visit
www.javaexchange.com

When u create a connection pool a number of connections are created when the connection pool class is instantiated.Your servlets or other programs borrow a connection from the pool, use it and then return them to the pool. Now this happens really fast.So it efficent.
If u do not create a pool then u have to establsh connection in every servlet etc which wastes a lot of time coz response time is critical in web applications.

Regards
Danish Shaukat
 
Danish Shaukat
Ranch Hand
Posts: 341
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi!
Also visit the following. I was facing same problem some time back.
http://www.javaranch.com/ubb/Forum7/HTML/002888.html
Regards
Danish Shaukat
reply
    Bookmark Topic Watch Topic
  • New Topic