You can use the session object to share the database connection between
servlets.
After verifying username and password, in the session object you put the
database connection:
//Get the session
HttpSession mySession = req.getSession(true);
//Set the database connection as a session attribute
mySession.setAttribute("DBConn", con);
'con' is the Connection object
Each servlet that wanted to use that connection must get the connection
object from the session:
// Get the session
HttpSession session = req.getSession(true);
//Get the connection object from the session
Connection con = (Connection)session.getAttribute("DBConn");
>
>Hi there,
>
>Does anyone know how to maintain a database connection between
>servlets:
>
>i.e. Open the connection through a login servlet which gives
>the database
>username and password. What we need, is for all other servlets in the
>application to have access to this connection.
>
>A possible workaround would be passing the username and
>password and opening
>the connection in each individual servlet, but this I presume
>would not be
>very efficient in terms of speed with each servlet opening and
>closing the
>database connection.
>
>Any help or direction would be appreciated,
>Brian.
>
>
>**********************************************************************
>Privileged, confidential and/or copyright information may be contained
>in this e-mail. This e-mail is for the use only of the intended
>addressee. If you are not the intended addressee, or the person
>responsible for delivering it to the intended addressee, you may not
>copy, forward, disclose or otherwise use it or any part of it in any
>way whatsoever. To do so is prohibited and may be unlawful.
>
>If you receive this e-mail by mistake please advise the sender
>immediately by using the reply facility in your e-mail software.
>
>Orygen (Ireland) Limited may monitor the content of e-mails sent and
>received via its network for the purposes of ensuring compliance with
>its policies and procedures.
>
>This message is subject to and does not create or vary any contractual
>relationship between Orygen (Ireland) Limited and you.
>**********************************************************************
>
>_______________________________________________________________
>____________
>To unsubscribe, send email to [EMAIL PROTECTED] and
>include in the body
>of the message "signoff SERVLET-INTEREST".
>
>Archives: http://archives.java.sun.com/archives/servlet-interest.html
>Resources: http://java.sun.com/products/servlet/external-resources.html
>LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
