Hi,
have a look to "Java Developer's Journal Volume 5 Issue 10" or go to
http://www.sys-con.com/java/archives/0510/
Regards
Rinaldo Bonazzo
email:[EMAIL PROTECTED]
Tel.:+39-070-673178
Fax :+39-070-684808
Mobile:+39-(0)328-2898778
-----Messaggio originale-----
Da: A mailing list for discussion about Sun Microsystem's JavaServlet
API Technology. [mailto:[EMAIL PROTECTED]]Per conto di
A.R.Karthikeyan
Inviato: gioved� 7 dicembre 2000 14.19
A: [EMAIL PROTECTED]
Oggetto: 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
___________________________________________________________________________
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