i am writing a cluster of servlets, each of which access a database.  im
curious if people would recommend that each servlet have its own connection
pooling, or that all the servlets use the same connection pooling servlet,
or some other type of configuration?

i have gone with the latter, but i've found that once in a while connections
get orphaned -- they never close, and the connection pooling servlet
therefore creates a new connection for each subsequent request, which, when
repeated enough times, eventually exhausts resources.

putting together a connection pooling servlet for EACH servlet seems a
little redundant, but may be the way to go, for me, anyway, at least in
terms of trouble shooting.  but i'd love to hear some
advice/opinions/suggestions.  are there benefits to this approach?

thanks.

best,
paul

___________________________________________________________________________
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

Reply via email to