This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
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.
Have you checked out Aspose?
subject: Best way of Connection Pooling
It's not a secret anymore!