It's not a secret anymore!
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

Win a copy of REST with Spring (video course) this week in the Spring forum!
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!