Sounds like
1) Interservlet communication shared object class
2) Initialisation Servlet that starts up when the container is loaded
3) A database pool connection object
--
Peter Pilgrim
G.O.A.T
"the Greatest Of All Time"
---------------------------------------- Message History
----------------------------------------
From: "A.R.Karthikeyan" <[EMAIL PROTECTED]>@java.sun.com> on 07/12/2000 14:19 CET
Please respond to "A mailing list for discussion about Sun Microsystem's Java Servlet
API Technology." <[EMAIL PROTECTED]>
DELEGATED - Sent by: "A mailing list for discussion about Sun Microsystem's Java
Servlet API Technology."@java.sun.com>
To: [EMAIL PROTECTED]
cc:
Subject: servlets to database connection
Hi everybody,
I've developed a site entirely on servlets and the first page is the login
page generated by a servlet,where a connection to the Access database is
established during the init lifecycle of the servlet,so when there are
several users logging on to this site a database connection is already
achieved and so it leads to faster verification of the login details.I have
not closed this connection anywhere in this servlet.
If the login is successful ,then a session is created for every user so that
he can traverse accross the other pages of the sites where by each and every
page is generated by a separate servlet program.
Some of these pages consist of form fields which need to be saved in the
Access database.
My question is should I establish a connection in the init event of each of
the servlets that generate HTML pages with connectivity to the database or
since a connection to the database has already been achieved by the servlet
which generated the login page (& not yet closed ),so can i use the same
connection object that pertains to the first servlet in my remaining
servlets to make updates to the database.
Looking forward to some help from you.
Thanks in advance
Karthikeyan A.R
--
This e-mail may contain confidential and/or privileged information. If you are not the
intended recipient (or have received this e-mail in error) please notify the sender
immediately and destroy this e-mail. Any unauthorised copying, disclosure or
distribution of the material in this e-mail is strictly forbidden.
___________________________________________________________________________
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
