----- Original Message -----
From: William Crawford <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, June 25, 2000 8:59 PM
Subject: Re: JDBC Connection Management
> None of which is to say that this isn't a useful technique in some
> situations, as Nic described. The two cases where I would suggest this are
> when authentication runs through the database's native authentication
> system, and when transactions might run across multiple servlet
> invocations. However, there are relatively few situations where this will
> come up: authenticating through the database is a pretty resource
intensive
> operation, and you're probably better served storing this information in
an
> LDAP server (via JNDI) or a database table accessed by the server via a
> generic account. I'd also suggest structuring your application to avoid
the
> necessity of stringing a transaction out across multiple invocations: use
> intermediary tables and hold on to an identifier rather than a whole
> connection.
I'm relatively new at Java, servlets and servers, but I'm trying to learn as
fast as I can. I'm not using connection pooling as yet, but I'm studying the
possibility. They way I work is as followed: I have one Connection-object
that connects to MySQL with it's own login/password-combo. Each instance of
a servlet connects anew (sometimes several times during the process of
processing one "string" of data) to the database.
My question isn't as professional as others, but I would like to know the
answer. Reading the post from William, I would like to know if the server is
bogged down due to the authentication-process.
Another question is, where can I find documentation about connection-pooling
and how to implement this? (I'm using mm.mysql for JDBC.)
Kind regards,
Met vriendelijke groet,
Tim Stoop
___________________________________________________________________________
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
