You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Edoardo Panfili <ed...@aspix.it> on 2006/10/06 22:53:17 UTC

use of maxIdle parameter of DataSource

I have this configuration for my roller server application
<Resource name="jdbc/rollerdb" auth="Container" 
type="javax.sql.DataSource"
                 driverClassName="org.postgresql.Driver"
                 url="jdbc:postgresql://127.0.0.1/roller"
                 username="roller"     password="ooooo"
                 maxActive="20"        maxIdle="3"
                 removeAbandoned="true"  maxWait="300"
/>

but if I use "ps ax | grep roller" I can see

   372  ??  S      0:00.37 postgres: roller roller 127.0.0.1(49259) idle 
 

   426  ??  S      0:00.00 postgres: roller roller 127.0.0.1(49281) idle 
 

   427  ??  S      0:00.00 postgres: roller roller 127.0.0.1(49282) idle 
 

   428  ??  S      0:00.01 postgres: roller roller 127.0.0.1(49283) idle 
 

   430  ??  S      0:00.06 postgres: roller roller 127.0.0.1(49284) idle

why 5 idle connections if on my configuration I have maxIdle="3"?

Nobody has used roller during the last 10 minutes.

thank you
Edoardo
-- 
edoardo@aspix.it
AIM: edoardopn
Jabber: edoardopa@talk.google.com
tel:075 9142766

---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org