Meaningless Drivel is fun!
The moose likes Servlets and the fly likes Servlet and Connection pooling Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Make it so: Java DB Connections & Transactions this week in the JDBC forum!
JavaRanch » Java Forums » Java » Servlets
Bookmark "Servlet and Connection pooling" Watch "Servlet and Connection pooling" New topic

Servlet and Connection pooling

ashish kulkarni
Ranch Hand

Joined: Aug 15, 2002
Posts: 131
I am using Connection pooling and storing the pool in servlet context and I have question about getting the connection from servlet context in a all servlets,
I want to code a single class where the input paramter will be servlet context and session and this class will return me the connection depending upon some parameter in session.
I want to keep it is one class so i can change my implementation in future and change only one class and my servlets will not be affected
So any suggestions on doing this, one that i think that this class must have a static method which is synchronised so i dont have to create instance of this class in each servlet ,will synchronise slow the performance, what about using singleton pattern(any code of singleton pattern)
Any suggestions...

David Carew

Joined: Jul 08, 2002
Posts: 5
See the Service Locator pattern:
Java BluePrints
I agree. Here's the link:
subject: Servlet and Connection pooling
jQuery in Action, 3rd edition