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 ]