>>> 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
