In your servlet's destroy() method (I am using Struts and plugins, and use the plugin's destroy() method), add the following code:
((BasicDataSource) ds).close(); That is assuming your data source is named 'ds'. This will close all connections. Dustin --- Lucie Chan <[EMAIL PROTECTED]> wrote: > Hi, > > I'm using Tomcat's connection pooling feature which > is implemented with > Jakarta's DBCP to manage database access, and I just > noticed that each time > when I do a "reload" (either via Ant or Tomcat > manager), a database > connection is added to the database server. Though > this isn't a big problem > in the production environment, but it's a bit > annoying during development > when I'm interactively developing and reloading the > application. Currently, > I will run "reload" till all the database > connections have been exhausted, > and then restart Tomcat server. There must a better > way to do this. How do > I > destroy or reuse the connections in the pool? Any > suggestion? > > --- > Lucie > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: > [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] > > __________________________________ Do you Yahoo!? All your favorites on one personal page – Try My Yahoo! http://my.yahoo.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]