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]
