I have a problem in maintaining the open database connection objects in servlets. How to do this? Once, i connect to the database from one servlet or page. It should be opened for all the servlets which uses sql statements. Every servlet or page should not make a new connection.
Vijaya.
hi there,
you can create a connection in one servlet..
then put in into ServletContext.
e.g. In "AServlet.class" :
Connection con = .....
ServletContext sc = getServletConfig().getServletContext();
sc.setAttribute("con", con);
and in "BServlet.class", you can retrieve this connection
by doing:
Connection con = null;
ServletContext sc = getServletConfig().getServletContext();
con = (Connection)sc.getAttribute("con");
and do whatever you want in "BServlet.class".
try it... it'd better to create a ConnectionPool class
to give out connection... therefore each servlet
will get their own connection and return it back to
the ConnectionPool once they finish.