> From: Khawaja Shams [mailto:[EMAIL PROTECTED] 
> Subject: database connection pooling
> 
> when using connection pooling, i get a connection from the 
> context. I am curious if I am supposed to close this connection
> when I am done using it.

Please read the doc:
http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-examples-howto.h
tml

It explicitly states:

"There is one problem with connection pooling. A web application has to
explicetely [sic] close ResultSet's, Statement's, and Connection's.
Failure of a web application to close these resources can result in them
never being available again for reuse, a db connection pool 'leak'. This
can eventually result in your web application db connections failing if
there are no more available connections."

 - Chuck


THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY
MATERIAL and is thus for use only by the intended recipient. If you
received this in error, please contact the sender and delete the e-mail
and its attachments from all computers.

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to