wood burning stoves 2.0*
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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Java » Servlets
Bookmark "Best way of Connection Pooling" Watch "Best way of Connection Pooling" New topic
Author

Best way of Connection Pooling

Dominic Clay
Greenhorn

Joined: Feb 06, 2002
Posts: 2
Hi,
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?
Dominic
Pradeep bhatt
Ranch Hand

Joined: Feb 27, 2002
Posts: 8904

U can an implementation of connection at
http://www.javaexchange.com/


Groovy
David O'Meara
Rancher

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...
Dave
David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

"Dominic",
The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention, described at http://www.javaranch.com/name.jsp .
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.
Thanks.
Dave
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Best way of Connection Pooling
 
Similar Threads
connection pooling
JCA - Connection Pooling
Question about shared DB connection
load DB connection class on tomcat startup
Confirguring Spring with MQ