this may be obvious, but also make sure that you are closing all statements
-- stmt.close(), etc --
and thereby releasing resources back to the database.
paul
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
___________________________________________________________________________
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
