File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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:
subject: Create ConnectionPool in ServletContextListener
It's not a secret anymore!