http://publib.boulder.ibm.com/infocenter/wasinfo/v6r0/index.jsp?topic=/com.ibm.websphere.express.doc/info/exp/ae/udat_conpoolset.html
keep your reap time low keep unused_timeout low keep aged_timeout low keep Connection Timeout low feel free to assign Maximum Connections from default 10.. but not more than 50 HTH Martin ______________________________________________ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission. > From: chuck.caldar...@unisys.com > To: users@tomcat.apache.org > Date: Fri, 13 Mar 2009 17:03:50 -0500 > Subject: RE: tomcat database connection pool > > > From: Carol Cheung [mailto:cache...@consumercontact.com] > > Subject: tomcat database connection pool > > > > In tomcat 5.5, the database connection pool associated with > > my application does not seem to "shutdown" when I undeploy > > the application. > > You don't say if the DBCP is managed by the container (Tomcat) or by your > webapp. If it's the former, the pool will persist for the life of Tomcat > (but see the link below). If the latter, your best bet is to implement a > ServletContextListener that will explicitly shut down the pool when the > contextDestroyed() method is called. The servlet spec even uses this > situation as an example. > > An easier link to follow for the previously reference discussion thread is > this: > http://marc.info/?l=tomcat-user&m=123529838331464&w=2 > > And the critical messages of the thread: > http://marc.info/?l=tomcat-user&m=123532841602124&w=2 > http://marc.info/?l=tomcat-user&m=123532986503723&w=2 > > - 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: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > _________________________________________________________________ Windows Live™ Groups: Create an online spot for your favorite groups to meet. http://windowslive.com/online/groups?ocid=TXT_TAGLM_WL_groups_032009
