Anoop,
I would not recommend doing what Padhu suggests. It is not thread-safe and
will lead to data errors reading and writing to the database. If multiple
requests come in simultaneously to the same page, several different threads
will be attempting to use the same db connection and this will cause
unpredictable results. Your best bet is to use a connection pool.
Regards,
Richard
At 08:49 AM 10/16/2002 -0400, you wrote:
Override jspInit() in a declaration block, create the connection, and
save it as an attribute in ServletContext.
-- padhu
Anoop Kumar V wrote:
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.
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://archives.java.sun.com/jsp-interest.html
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.jsp
http://www.jguru.com/faq/index.jsp
http://www.jspinsider.com
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://archives.java.sun.com/jsp-interest.html
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.jsp
http://www.jguru.com/faq/index.jsp
http://www.jspinsider.com
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://archives.java.sun.com/jsp-interest.html
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.jsp
http://www.jguru.com/faq/index.jsp
http://www.jspinsider.com
