jQuery in Action, 3rd edition
The moose likes Servlets and the fly likes Create ConnectionPool in ServletContextListener Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Servlets
Bookmark "Create ConnectionPool in ServletContextListener" Watch "Create ConnectionPool in ServletContextListener" New topic

Create ConnectionPool in ServletContextListener

JiaPei Jen
Ranch Hand

Joined: Nov 19, 2000
Posts: 1309
The Specification says that we should create the connection pool in the ServletContextListener. I have the code for creating a connection pool (see below). How do I create it in the ServletContextListener?
Vijay Rajaram

Joined: Nov 17, 2003
Posts: 12
The connection object which you have created has to be stored in the servlet context and whenever you need a DB connection get the connection object from the servlet context.
By the way if you want to know the usage of the ServletContextListener, this is what you need to do.
Create a class which impliment the ServletContextListener interface and configure this class in the web.xml.
- VJ
[ February 23, 2004: Message edited by: Vijay Rajaram ]
Faisal Khan
Ranch Hand

Joined: Jun 29, 2003
Posts: 285
If you are using Tomcat, the following link will be of great help, it has a very good explanation on how to get going.

The secret to creativity is knowing how to hide your sources.
I agree. Here's the link: http://aspose.com/file-tools
subject: Create ConnectionPool in ServletContextListener
It's not a secret anymore!