Mailing-List: contact commons-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Jakarta Commons Users List" <commons-user@jakarta.apache.org>
Received-SPF: neutral (herse.apache.org: local policy)
Message-Id: <465474DF0200007400005B74@kent.pnn.police.uk>
Date: Wed, 23 May 2007 17:07:43 +0100
From: "Conrad CRAMPTON PSE 52704" <conrad.crampton@kent.pnn.police.uk>
To: <commons-user@jakarta.apache.org>
Subject: Re: Reusing connection pool
References: <46545E76.2050403@nyc.yamaha.com>
  <46546D960200007400005B6D@kent.pnn.police.uk>
 <46546133.3090305@nyc.yamaha.com>
In-Reply-To: <46546133.3090305@nyc.yamaha.com>
Mime-Version: 1.0
Content-Type: multipart/alternative; boundary="=__PartC3E4DCDF.0__="

--=__PartC3E4DCDF.0__=
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

I haven't used the DBCP I must admit and was suggesting something not
actually tied to the re-deployment process specifically but something
that stands by itself as a separate part to your application e.g.
servlet or jsp that you has some method of closing all pooled
connections. if you are using struts have an actionmethod that does this
would be appropriate when called on submission of an (protected) admin
page - 
 
eg.
http://yourdomain/context/admin.do?action=closeAllConnections
 
then you could call the close() method on the ObjectPool interface.
 
Sorry a bit abstract in my explanation, but just an idea. I think to
get the application to know when it is being redeployed is a bit
ambitious and prone to failure. If you know when you are going to
redeploy it then you also know that you need to close the connections
and therefore it is in your control.
 
Conrad

>>> rbaisak@nyc.yamaha.com 23/05/07 16:43:47 >>>

Do you mean to use any listener to servlet or could you please
elaborate 
bit more ?
I am using struts ActionServlet and I too tried to implement destroy 
method of RequestProcessor and close all connections on every 
redeployment. However it is somehow not working and may be I am doing 
something wrong.

- R

Conrad CRAMPTON PSE 52704 wrote:
> can't you create a utility servlet that you can call
pre-redeployment
> that closes all of your connections first?
> Conrad
>
>   
>>>> rbaisak@nyc.yamaha.com 23/05/07 16:32:06 >>>
>>>>         
>
> Hi Group,
> I am using DBCP provided connection pool in my web applications. For

> each re-deployment of my web application, connection pools are not 
> reused so connections are just increased. This forces me to restart
my
>
> live application in every month. Is there any way, I can reuse 
> connections in redeploy.
> Your help would be appreciated.
>
> regards,
> RBAISAK
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail:
commons-user-help@jakarta.apache.org
>
>
>
>   


--=__PartC3E4DCDF.0__=--