Hello,
My connection pool works fine, but I have found a problem. When I am
using a servlet, the servlet requests a connection in each service and
returns it to the pool when its task has finished. The problem arises
when it has been an SQLException. Then, when the connection object is
returned to the pool, it keeps memory of this error, so if I only have
one connection in the pool, the following time the servlet is called,
takes the same connection, and when trying to do the sql command, the
exception is there. How exactly does connection object work? Does it
"remember" the error state for a statement? And, if so, how can I know
it when asking for a connection to the pool (in order to create a new
one)?
Thanks
___________________________________________________________________________
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
