File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Move to Connection Pooling Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Move to Connection Pooling" Watch "Move to Connection Pooling" New topic

Move to Connection Pooling

Frank Daly
Ranch Hand

Joined: Mar 31, 2000
Posts: 141
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?
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

Joined: Dec 03, 2000
Posts: 2
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
[This message has been edited by saradhi pantra (edited December 03, 2000).]
satishind Reddy
Ranch Hand

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

maha anna
Ranch Hand

Joined: Jan 31, 2000
Posts: 1467 has a very good ConnectionPool class with source. The author is Marty Hall. Please check it out.
maha anna
I agree. Here's the link:
subject: Move to Connection Pooling
It's not a secret anymore!