Title: Connection to database from jsp.
|
Who is this guy moderator take him out of this
LIST
----- Original Message -----
Sent: Wednesday, October 16, 2002 1:34
PM
Subject: Re: Connection to database from
jsp.
NO
MORE GARBIGE MAIL
thanks
We have a system consisting of a group of jsps -
which have links to one another. There is no controller servlet as it is a
simple system. What i want is to access the database from the jsps. The
problem is that I do not want a new connection to be established everytime a
request is made. What is the solution for this?
I had initially thought of having a utility class
and in that I can have a getConnection method which returns the connection
to a static connection reference in the same utility class. This can then be
assigned to the jsps (by making a call from the jsps to some method -
returnConn, in the utilily class). Is it true that a new connection will be
established everytime. This has confused me a bit.
I am infact confused now about the very concept
of static references. How do you think this problem can be solved? Will a
servlet be of any use? Actually in a servlet, if we have a static connection
reference as a class variable, and the initialization is done ( acquiring a
connection) in the init method ( as init is executed only once in the
lifetime of a servlet), the problem may be solved. In a servlet, the init
method is executed only once and the servlet does not go out of memory till
the server comes down. So I presume the connection will also be the same. Is
this correct? Even if it is, I want to avoid the servlet, as it will be a
lot of rework if the servlet has to be fit in. The application would have to
be changed. Suggestions invited.
Anoop Kumar
V.
|
