Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Tomcat Users List" <users@tomcat.apache.org>
Received-SPF: neutral (nike.apache.org: local policy)
Message-ID: <380-2200943114252503@M2W021.mail2web.com>
Reply-To: allen.irwin@smartintegration.com.au
From: "allen.irwin@smartintegration.com.au"
 <allen.irwin@smartintegration.com.au>
To: users@tomcat.apache.org
Date: Tue, 31 Mar 2009 21:42:52 -0400
MIME-Version: 1.0
Content-type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Subject: Connection Pooling questions

Hello,

I searched on the mailing list back to 2007 and didn't see the answers I
needed for these DataSource related questions (though I did see similar,
not quite what I needed though)=2E

I'm using Tomcat 5=2E5, Java 1=2E5 on Windows XP and have used the excelle=
nt
guide: http://tomcat=2Eapache=2Eorg/tomcat-5=2E5-doc/jndi-resources-howto=2E=
html
for configuring the default data source within Tomcat

I configure it using the suggested /META-INF/context=2Exml with:
maxActive=3D"30" maxIdle=3D"10"

I assumed that maxActive would limit the total amount of DB
connections that could ever be open at one time (in this case 30)=2E  Yet
from what I see it seems like I am limited to maxActive + maxIdle
connections open (in this case 40)=2E  Is that true=3F

Also, the default behavior seems to be that the connections never close
within the pool when they are not being used=2E  I had my Tomcat server si=
t
there for about an hour idle with no client requests incoming and when I
ran netstat -a I still saw 39 connections open, they only closed when I
killed Tomcat=2E  Do I have to turn on some kind of cleanup explicitly=3F

I do close the connections within my program using conn=2Eclose(); as the
howto suggests=2E I thought that when the connections were not used that
they would over time be "really" closed and I would end up with the maxIdl=
e
value
of 10 open connections within my Pool=2E

thanks!=20

--------------------------------------------------------------------
mail2web=2Ecom =96 Enhanced email for the mobile individual based on Micro=
soft=AE
Exchange - http://link=2Email2web=2Ecom/Personal/EnhancedEmail


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