It's not a secret anymore!
The moose likes Servlets and the fly likes Database Connection Pooling Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Servlets
Bookmark "Database Connection Pooling" Watch "Database Connection Pooling" New topic

Database Connection Pooling

Velika Srbija
Ranch Hand

Joined: Jan 15, 2002
Posts: 172
I'm goin' to make a new web app using servlets and MySQL and I'm not quite sure about managing Connection Pooling.
Do I have to write new classes where I should manage requests about making (=opening) new Database Connections (and closing unused as well) or the MySQL server will do it automatically for me?
I'm not planning to use the SingleThreadModel interface.
William Brogden
Author and all-around good cowpoke

Joined: Mar 22, 2000
Posts: 13037
There are a number of toolkits for connection pooling. A search on Yahool will lead you to them. There are frequent threads here so you might start with a search right here.
Andres Gonzalez
Ranch Hand

Joined: Nov 27, 2001
Posts: 1561
try this one

I'm not going to be a Rock Star. I'm going to be a LEGEND! --Freddie Mercury
I agree. Here's the link:
subject: Database Connection Pooling
It's not a secret anymore!