Two Laptop Bag*
The moose likes Servlets and the fly likes How to create a connection pool Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Servlets
Bookmark "How to create a connection pool" Watch "How to create a connection pool" New topic
Author

How to create a connection pool

anand chawla
Ranch Hand

Joined: Oct 19, 2000
Posts: 91
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
Danish Shaukat
Ranch Hand

Joined: Nov 16, 1999
Posts: 340
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

Joined: Nov 16, 1999
Posts: 340
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to create a connection pool