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