Re: JNDI datasource question

2006-03-08 Thread Andre Van Klaveren
The initialSize parameter is specific to DBCP. I believe the interface in Tomcat only has fields that are common among pooling implementations (Commons Pool). You'll have to manually edit the pool configuration. An idle connection is one that is in the pool that is not currently being used by th

RE: JNDI datasource question

2006-03-08 Thread Tim Lucia
7;s just a port / repackaging of Commons DBCP, and that has had initialSize for a long time now. Tim -Original Message- From: John Cherouvim [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 08, 2006 7:52 AM To: Tomcat Users List Subject: Re: JNDI datasource question Thanks for your detailed e

Re: JNDI datasource question

2006-03-08 Thread John Cherouvim
Thanks for your detailed explanation. In tomcat 5.0.28 I cannot find initialSize parameter. Is it something that was added later? And by idle connection, do we mean the connection that was closed in a finally block (returned to the pool)? John Tim Lucia wrote: The number of connections is

RE: JNDI datasource question

2006-03-08 Thread Tim Lucia
The number of connections is affected by three parameters: initialSize="10" maxIdle="20" maxActive="50" also: maxWait="5000" initialSize="10" says make 10 connections at startup. SHOW PROCESSLIST will reveal 10 processes in this case. maxIdle="20" says close any idle connections