Re: DBPC - Tomcat 5.5 JDBC Configuration Query

[Vijay Anjur <vi...@gmail.com>]

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, peter.jessup@ba.com <pe...@ba.com> 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: commons-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: commons-user-help@jakarta.apache.org
>
>