Hi, I find that my connections after closing gets returned to the pool but idle connections never gets physically closed. When I check with the database, all the connections are open. None of the physical connections are closed. Why is my evicition thread not working as per minEvicableTimeMillis specified?
On 3/10/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > Hi Vijay, > > thanks for your reply, we are currently using > timeBetweenEvictionRunsMillis=1000*60*2 > numTestsPerEvictionRunsMillis=3 > minEvicableTimeMillis=1000*60*30 > > How do these compare with your settings ? > > Regards > > Pete > > > > > > > "Vijay Anjur" <[EMAIL PROTECTED]> on 10/03/2006 12:18:55 > > Please respond to "Jakarta Commons Users List" > <commons-user@jakarta.apache.org> > > To: "Jakarta Commons Users List" > cc: > bcc: > Subject: Re: DBPC - Tomcat 5.5 JDBC Configuration Query > > I am having similar problems. I am monitoring how the connections grow and > shrink in the database. It looks like the timeBetweenEvictionRunsMillis, > minEvictableIdleTimeMillis parameters govern the idle connections being > closed and growth of the connections. You need to tune these 2 parameters > in > order to optimize the growth of the connections in the pool. I am still > playing with the numbers and it doesn't look straight forward. > > -Vijay > > > On 3/10/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > > > > Hi, > > > > Appologies if this in not the correct list for this query. > > > > I am attempting to configure JDBC connection pooling in tomcat 5.5 and > > have > > some difficulty understanding the various configuration settings from > the > > parameter descriptions on the DBCP pages. > > > > We are currently using > > initialSize=10 > > maxActive=10 > > maxIdle=5 > > minIdle=2 > > > > to access an Oracle 8i database using the Oracle thin driver from a pair > > of > > load balanced servers. > > > > The connection functions correctly but we are having difficulty > > understanding how the various parameters interact so that we can tune > our > > servers correctly. > > > > When we monitor the connections from the database end we cannot > correlate > > what we see with the paramaters used. > > > > Is there an overview somewhere explaining how the connections are set > up, > > reused and destroyed that relates to the parameter descriptions. > > > > for example maxIdle is decrbed as 'The maximum number of active > > connections > > that can remain idle in the pool without extra ones being released" > > what do active and idle mean in this context, how can active connections > > be > > idle and does released mean created or destroyed ? > > > > any guidance much appreciated. > > > > Pete Jessup > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > > > > > > > ------------------------------------------------------------------------------------------------- > > Celebrating 10 years of ba.com.. Flights..Hotels..Car > Hire..Sightseeing..Online Check-in..Manage My Booking and more > http://www.ba.com > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >
