Jaman;
First off, you may want to consider using a connection
pool so your users do not experience the wait time
associated with making a connection every request. You
can get one at http://www.javaexchange.com.
However, if you want to continue doing this:
Registering a driver is basically java.sql's way of
loading the JDBC driver itself into the JVM. So, for
each JVM, you need only do it once. Consequently, you
may consider doing it in the init method of your
servlet.
//Nicholas
--- Jaman Burton <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I have a question about a servlet
> application that I am
> developing. In a multi-threaded application is it
> necessary to
> register the JDBC drivers before each connection is
> made to the
> database? Or is registering the JDBC driver once
> adequate enough?
>
> Currently, each time a user attempts to log
> into our database, the
> application registers a JDBC driver, then calls
> getConnection using
> said driver. I was wondering if I could just
> register 1 driver then
> just call getConnection using the same driver for
> each login attempt.
>
> I've looked but haven't really found much
> documentation about
> either point and my JDBC knowledge isn't very
> strong.
>
> Thanks,
>
> Jaman Burton
> [EMAIL PROTECTED]
> Excel Corporation
>
>
___________________________________________________________________________
> 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
>
=====
"Suzie, Suzie, Suzie, Suzie
Suzie, Suzie Greenberg"
Suzie Greenberg, Phish
--
Nicholas Whitehead
__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com
___________________________________________________________________________
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
