Nic Ferrier wrote:
> >>> A Suresh <[EMAIL PROTECTED]> 10/12/99 10:32:24 AM >>>
>
> >I have implemented a connection broker to be used in a servlet
> >application. The problem is that even if a single user is accessing
> >the application, i can see extra connections appearing in the SQL
> >database client. But i have put some debug statements in my
> connection
> >pool and saw that it was NOT creating any extra connections. It's
> >mysterious from where these connections are originating.
>
> Many JDBC clients (ie: the JDBC code running in your application
> which connects to the SQL server - the internal code, not your code)
> use more than one SQL Connection for their operations.
>
> Many SQL servers will also use more than one SQL connection
> internally during operation.
>
> This might be what you are seeing.
>
> Check with the manufacturer of your JDBC implementation what sort of
> Connection usage profile it has.
>
> Nic Ferrier
Besides what Nic described, there is at least one other possible explanation
for what you are seeing -- "single user" does not necessarily imply "single
request at a time".
For example, if you have a framed page with three frames in it, your browser
will typically try to load all three of them at the same time (the maximum
simultaneous requests is usually a config option -- Netscape defaults to 4).
If each of those requests requires a database lookup, you can easily have more
than one connection required at that moment, even if there's only one user on
the system.
Craig McClanahan
___________________________________________________________________________
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
