commons-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "David Graham" <dgraham1...@hotmail.com>
Subject RE: [DBCP] Abandoned connections not being returned to pool upon clos ing
Date Wed, 09 Apr 2003 17:42:04 GMT
As of yesterday it doesn't use AbandonedObjectPool, it uses 
GenericObjectPool.

David



>From: "Timko, Cheryl A." <cheryl_timko@merck.com>
>Reply-To: "Jakarta Commons Developers List" 
><commons-dev@jakarta.apache.org>
>To: "'Jakarta Commons Developers List'" <commons-dev@jakarta.apache.org>
>Subject: RE: [DBCP] Abandoned connections not being returned to pool 
>upon	clos ing
>Date: Wed, 09 Apr 2003 13:28:11 -0400
>
>... actually, it uses the AbandonedObjectPool which inherits from
>GenericObjectPool. Since the AbandonedObjectPool does not override the
>GenericObjectPool close() method, the GenericObjectPool's close() method is
>called when the BasicDataSource is closed.
>
>The GenericObjectPool close() only closes the connections idle in the pool.
>What about the connections which are currently in use and maintained by the
>AbandonedObjectPool?  They never get closed.  Ideally, the
>AbandonedObjectPool should have a close() method which closes the 
>"abandoned
>connections" and then calls its super.close().
>
>It would be great if this could be supported in a future release...
>
>- Cheryl
>
>-----Original Message-----
>From: David Graham [mailto:dgraham1980@hotmail.com]
>Sent: Wednesday, April 09, 2003 1:17 PM
>To: commons-dev@jakarta.apache.org
>Subject: RE: [DBCP] Abandoned connections not being returned to pool upon
>clos ing
>
>
>BasicDataSource.close uses GenericObjectPool.close to release the
>connections.
>
>David
>
>
>
> >From: "Timko, Cheryl A." <cheryl_timko@merck.com>
> >Reply-To: "Jakarta Commons Developers List"
> ><commons-dev@jakarta.apache.org>
> >To: "'Jakarta Commons Developers List'" <commons-dev@jakarta.apache.org>
> >Subject: RE: [DBCP] Abandoned connections not being returned to pool
> >upon	clos ing
> >Date: Wed, 09 Apr 2003 13:03:44 -0400
> >
> >Will the DBCP will support, in a future release, the closing of 
>connections
> >currently in used when the pool is closed? I think it is an important
> >requirement; otherwise, DBAs will have to kill the connection manually 
>(if
> >the java process running the application is never terminated or dies).
> >
> >- Cheryl
> >
> >-----Original Message-----
> >From: David Graham [mailto:dgraham1980@hotmail.com]
> >Sent: Wednesday, April 09, 2003 10:25 AM
> >To: commons-dev@jakarta.apache.org
> >Subject: Re: [DBCP] Abandoned connections not being returned to pool upon
> >clos ing
> >
> >
> >The abandoned functionality has been deprecated and will be removed in a
> >future release.
> >
> >David
> >
> >
> > >From: "Timko, Cheryl A." <cheryl_timko@merck.com>
> > >Reply-To: "Jakarta Commons Developers List"
> > ><commons-dev@jakarta.apache.org>
> > >To: "'commons-dev@jakarta.apache.org'" <commons-dev@jakarta.apache.org>
> > >Subject: [DBCP] Abandoned connections not being returned to pool upon
> > >clos	ing
> > >Date: Wed, 09 Apr 2003 10:10:10 -0400
> > >
> > >	Our project uses the BasicDataSource class to create and maintain
> > >the pool of database connections (internally, the BasicDataSource 
>creates
> > >an
> > >AbandonedObjectPool for the connection pooling).  What I noticed is 
>that
> > >when the close() method is called on the BasicDataSource, the 
>"abandoned
> > >connections" are not being returned to the pool in order for them to be
> > >closed.
> > >
> > >	The check for whether "abandoned connections" are returned to the
> > >pool is only performed in the AbandonedObjectPool's borrowObject().
> >Since
> > >the AbandonedObjectPool does not have a close() method to return all 
>the
> > >abandoned connections to the pool, does anyone know of another way to
> > >accomplish this when the pool is being closed?  If not, is it possible 
>to
> > >add this functionality in a future release?
> > >
> > >	Thank you in advance for your feedback.
> > >
> > >	Cheryl Timko
> > >
> > >
> > >
> > >
> > >
> >
> >---------------------------------------------------------------------------
> >---
> > >Notice:  This e-mail message, together with any attachments, contains
> > >information of Merck & Co., Inc. (Whitehouse Station, New Jersey, USA)
> >that
> >
> > >may be confidential, proprietary copyrighted and/or legally privileged,
> >and
> >
> > >is intended solely for the use of the individual or entity named in 
>this
> > >message.  If you are not the intended recipient, and have received this
> > >message in error, please immediately return this by e-mail and then
> >delete
> > >it.
> > >
> >
> >===========================================================================
> >===
> > >
> > >
> > >---------------------------------------------------------------------
> > >To unsubscribe, e-mail: commons-dev-unsubscribe@jakarta.apache.org
> > >For additional commands, e-mail: commons-dev-help@jakarta.apache.org
> > >
> >
> >
> >_________________________________________________________________
> >Protect your PC - get McAfee.com VirusScan Online
> >http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
> >
> >
> >---------------------------------------------------------------------
> >To unsubscribe, e-mail: commons-dev-unsubscribe@jakarta.apache.org
> >For additional commands, e-mail: commons-dev-help@jakarta.apache.org
> >
> >
> >---------------------------------------------------------------------------
>---
> >Notice: This e-mail message, together with any attachments, contains
> >information of Merck & Co., Inc. (Whitehouse Station, New Jersey, USA) 
>that
>
> >may be confidential, proprietary copyrighted and/or legally privileged, 
>and
>
> >is intended solely for the use of the individual or entity named on this
> >message. If you are not the intended recipient, and have received this
> >message in error, please immediately return this by e-mail and then 
>delete
> >it.
> >
> >===========================================================================
>===
> >
> >
> >---------------------------------------------------------------------
> >To unsubscribe, e-mail: commons-dev-unsubscribe@jakarta.apache.org
> >For additional commands, e-mail: commons-dev-help@jakarta.apache.org
> >
>
>
>_________________________________________________________________
>MSN 8 with e-mail virus protection service: 2 months FREE*
>http://join.msn.com/?page=features/virus
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: commons-dev-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: commons-dev-help@jakarta.apache.org
>
>
>
>------------------------------------------------------------------------------
>Notice:  This e-mail message, together with any attachments, contains 
>information of Merck & Co., Inc. (Whitehouse Station, New Jersey, USA) that 
>may be confidential, proprietary copyrighted and/or legally privileged, and 
>is intended solely for the use of the individual or entity named in this 
>message.  If you are not the intended recipient, and have received this 
>message in error, please immediately return this by e-mail and then delete 
>it.
>
>==============================================================================
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: commons-dev-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: commons-dev-help@jakarta.apache.org
>


_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*.  
http://join.msn.com/?page=features/featuredemail


---------------------------------------------------------------------
To unsubscribe, e-mail: commons-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-dev-help@jakarta.apache.org


Mime
View raw message