commons-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "EShin Yen" <eshin_...@hotmail.com>
Subject RE: [pool] - maintain the some idle projects "forever" without shrinking :
Date Sun, 11 Aug 2002 07:41:58 GMT
Dear Rodney :
I just check the commons-pool build. Looks like the latest build is 
08/10/2002. I will download it and try it on Monday (08/12/2002). I will 
also take a look into DBCP (I guess it is called Database Connection 
Pooling).

Thank you for all your help.

                                                          David.


>From: "Waldhoff, Rodney" <rwaldhof@us.britannica.com>
>Reply-To: "Jakarta Commons Users List" <commons-user@jakarta.apache.org>
>To: "'commons-user@jakarta.apache.org '" <commons-user@jakarta.apache.org>
>CC: "'commons-dev@jakarta.apache.org '" <commons-dev@jakarta.apache.org>
>Subject: RE: [pool] - maintain the some idle projects "forever" without 
>shrinking :
>Date: Sat, 10 Aug 2002 16:20:31 -0500
>
> > As the inspiration given from you, I think I shall set
> > the evictor to run every 5-10 minutes. Because the
> > evictor will call the validate, if I make
> > the validate to do some simple query all the time, I
> > will be able to keep the connection alive. Am I correct?
>
>Yes, precisely.
>
>Based on your previous description (low concurrency, intermittent use) I'd
>suggest you keep the maxIdle property pretty low, since by this
>configuration, idle connections will stay in the pool forever.
>
> > According to the bug in evictor, I do experience all
> > object will be evicted even if they are not invalidate.
> > That is, for my current code, if I run evictor every
> > 5 minutes, then all the connections will be raided no
> > matter what. Even the ingres has not disconnected
> > the connections, the evictor still kick them out.
> > How can I get a patch for the commons-pool?
> > I just downloaded the latest version about 1 week ago.
> > Is the fix in the daily build? Please let me know.
>
>I just committed the fix (rev. 1.6 of both GenericObjectPool and
>GenericKeyedObjectPool), so it should be in the next daily build (8/10?
>8/11? Not sure what time it runs.)
>
>FYI, if you're up to it, you may want to take a peek at DBCP. It uses Pool
>in a manner very similiar to what you describe to provide a pool of JDBC
>connections.  The notion of a "validation" or "keep-alive" query is built
>right in.




_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com


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


Mime
View raw message