This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes Move to Connection Pooling Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Move to Connection Pooling" Watch "Move to Connection Pooling" New topic
Author

Move to Connection Pooling

Frank Daly
Ranch Hand

Joined: Mar 31, 2000
Posts: 139
Hi
I have a servlet which enables access to a mysql database for about 200 users. It's not heavily used. I currently reuse a single database connection which has worked fine. Have i just been lucky and should i implement a connection pool?
frank
Thomas Paul
mister krabs
Ranch Hand

Joined: May 05, 2000
Posts: 13974
Depends on how many concurrent requests you are getting and how long the connection is used per request.


Associate Instructor - Hofstra University
Amazon Top 750 reviewer - Blog - Unresolved References - Book Review Blog
saradhi pantra
Greenhorn

Joined: Dec 03, 2000
Posts: 2
hai,
for ur case if at least 200 users are continuously access ur site at any time u can use connection pooling .otherwise it is not
recommended.
[This message has been edited by saradhi pantra (edited December 03, 2000).]
satishind Reddy
Ranch Hand

Joined: Oct 17, 2000
Posts: 33
Hi,
Can any one explain how to create Connection pool.
Thanks in advance....

Regards
Satish
maha anna
Ranch Hand

Joined: Jan 31, 2000
Posts: 1467
www.coreservlets.com has a very good ConnectionPool class with source. The author is Marty Hall. Please check it out.
regds
maha anna
 
wood burning stoves
 
subject: Move to Connection Pooling
 
Similar Threads
connection not closed
JDBC connection in Java Bean
JDBC connection in Java Bean
Problem adding JComboBox to JFrame
JDBC Connection Pooling Framework