You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@commons.apache.org by Loïc Fournial <lf...@webmail.altensi.fr> on 2004/10/28 12:01:15 UTC
Commons Pool : problem with maxActive configuration
Hy,
i work on an application which use commons pool.
i configure the propetyies like that :
connection.pool.max.active=50
connection.pool.max.wait=10000
connection.pool.min.idle=10
connection.pool.max.idle=20
connection.pool.time.betweenevictionruns.millis=60000
connection.pool.min.evictable.idle.time.millis=600000
When i trace the evolution of the number fof active connection, i see this number increase / decrease.
But at a moment my number of active connection reach the maxActive number of connection and dont stop to this value.
Its continue to increase until my tomcat fail down.
Can you help me please.
Thanks
Loïc
Re: Commons Pool : problem with maxActive configuration
Posted by Philip DONAGHY <Ph...@thales-is.com>.
Loic,
Also give us the version number of commons-dbcp, and commons-pool.
Phil
Loïc Fournial a écrit :
>
> Hy,
>
> i work on an application which use commons pool.
> i configure the propetyies like that :
>
> connection.pool.max.active=50
> connection.pool.max.wait=10000
> connection.pool.min.idle=10
> connection.pool.max.idle=20
> connection.pool.time.betweenevictionruns.millis=60000
> connection.pool.min.evictable.idle.time.millis=600000
>
> When i trace the evolution of the number fof active connection, i see this number increase / decrease.
> But at a moment my number of active connection reach the maxActive number of connection and dont stop to this value.
> Its continue to increase until my tomcat fail down.
>
> Can you help me please.
>
> Thanks
>
> Loïc
---------------------------------------------------------------------
To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org
Re: Commons Pool : problem with maxActive configuration
Posted by Philip DONAGHY <Ph...@thales-is.com>.
Hi Loic,
I assume that you are using a standard implementation for creating your
connection pool;) Something like this,
GenericObjectPool connectionPool = new GenericObjectPool(null);
ConnectionFactory connectionFactory = new
DriverManagerConnectionFactory("jdbc:some:connect:string", "username",
"password");
PoolableConnectionFactory poolableConnectionFactory = new
PoolableConnectionFactory(connectionFactory,connectionPool,null,null,false,true);
PoolingDataSource dataSource = new PoolingDataSource(connectionPool);
Post it if there is something else that you do. My suggestion is to read
(debug) the code source implementation of dbcp and pool. Pay attention
to any tests that may use a similar configuration. Submit a bug if there
is one.
Loïc Fournial a écrit :
>
> Hy,
>
> i work on an application which use commons pool.
> i configure the propetyies like that :
>
> connection.pool.max.active=50
> connection.pool.max.wait=10000
> connection.pool.min.idle=10
> connection.pool.max.idle=20
> connection.pool.time.betweenevictionruns.millis=60000
> connection.pool.min.evictable.idle.time.millis=600000
Is there a connection.pool.max.evictable.idle.time.millis property which
forces the connection to be closed and removed from the pool. Also check
that you are closing all of your connections.
P.S. It helps if you prepend your Subject with [dbcp]. As you can see
this is a high volume mailing list.
Nice talking to you. Keep in touch,
Phil
>
> When i trace the evolution of the number fof active connection, i see this number increase / decrease.
> But at a moment my number of active connection reach the maxActive number of connection and dont stop to this value.
> Its continue to increase until my tomcat fail down.
>
> Can you help me please.
>
> Thanks
>
> Loïc
---------------------------------------------------------------------
To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org