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

Best way of Connection Pooling

Dominic Clay

Joined: Feb 06, 2002
Posts: 2
Could anyone give me some pointers as to the *best* way of connectign to my SQL database so as to enable my connections to be pooled.
I can already make a connection to the DB but I know that every call just creates a connection (Not so good!)
I have thought about moving my DB Code to an Entity EJB, but there is a huge overhead with EJB's in terms of speed of creation.
Any Connection pooling thoughts?
Pradeep bhatt
Ranch Hand

Joined: Feb 27, 2002
Posts: 8927

U can an implementation of connection at

David O'Meara

Joined: Mar 06, 2001
Posts: 13459

yeah, personally the best thing is not to re-invent the wheel.
Pooling is not rocket science but there are still plenty of things to get wrong...
David O'Meara

Joined: Mar 06, 2001
Posts: 13459

The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention, described at .
We require names to have at least two words, separated by a space, and strongly recommend that you use your full real name. Please re-register and select a new name which meets the requirements.
I agree. Here's the link:
subject: Best way of Connection Pooling
It's not a secret anymore!