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 ]
Joined: Jun 29, 2003
If you are using Tomcat, the following link will be of great help, it has a very good explanation on how to get going. HTH
The secret to creativity is knowing how to hide your sources.