• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Best way of Connection Pooling

 
Dominic Clay
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 8927
Firefox Browser Java Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
U can an implementation of connection at
http://www.javaexchange.com/
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic