Return-Path: 
 <users-return-200523-apmail-tomcat-users-archive=tomcat.apache.org@tomcat.apache.org>
Delivered-To: apmail-tomcat-users-archive@www.apache.org
Received: (qmail 43855 invoked from network); 15 Aug 2009 01:58:11 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3)
  by minotaur.apache.org with SMTP; 15 Aug 2009 01:58:11 -0000
Received: (qmail 37875 invoked by uid 500); 15 Aug 2009 01:58:14 -0000
Delivered-To: apmail-tomcat-users-archive@tomcat.apache.org
Received: (qmail 37778 invoked by uid 500); 15 Aug 2009 01:58:13 -0000
Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:users-help@tomcat.apache.org>
List-Unsubscribe: <mailto:users-unsubscribe@tomcat.apache.org>
List-Post: <mailto:users@tomcat.apache.org>
List-Id: <users.tomcat.apache.org>
Reply-To: "Tomcat Users List" <users@tomcat.apache.org>
Delivered-To: mailing list users@tomcat.apache.org
Received: (qmail 37767 invoked by uid 99); 15 Aug 2009 01:58:13 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 15 Aug 2009 01:58:13 +0000
X-ASF-Spam-Status: No, hits=2.2 required=10.0
	tests=HTML_MESSAGE,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: domain of mgainty@hotmail.com designates
 65.55.111.88 as permitted sender)
Received: from [65.55.111.88] (HELO blu0-omc2-s13.blu0.hotmail.com)
 (65.55.111.88)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 15 Aug 2009 01:58:00 +0000
Received: from BLU142-W25 ([65.55.111.73]) by blu0-omc2-s13.blu0.hotmail.com
 with Microsoft SMTPSVC(6.0.3790.3959);
	 Fri, 14 Aug 2009 18:57:39 -0700
Message-ID: <BLU142-W2586FC131D972A9C982852AE030@phx.gbl>
Content-Type: multipart/alternative;
	boundary="_8aecd388-7296-4049-94c7-1c08120ccaf4_"
X-Originating-IP: [71.184.169.190]
From: Martin Gainty <mgainty@hotmail.com>
To: Tomcat Users List <users@tomcat.apache.org>
Subject: RE: Connection Pool Exhausted
Date: Fri, 14 Aug 2009 21:57:39 -0400
Importance: Normal
In-Reply-To: <20090814180433.02gvxauf400ckswk@www3.sbceo.org>
References: <20090814172116.d9btrzwrkg4sw8ks@www3.sbceo.org>
	<4eedb92a0908141751o71ae28darb217bcab5cd65d3b@mail.gmail.com>
 <20090814180433.02gvxauf400ckswk@www3.sbceo.org>
MIME-Version: 1.0
X-OriginalArrivalTime: 15 Aug 2009 01:57:39.0992 (UTC)
 FILETIME=[C5180980:01CA1D4B]
X-Virus-Checked: Checked by ClamAV on apache.org

--_8aecd388-7296-4049-94c7-1c08120ccaf4_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


dbcp parameters are located in a *.jocl file located on your classpath=20
(WEB-INF/classes)
which should look something like
<object class=3D"org.apache.commons.dbcp.PoolableConnectionFactory" xmlns=
=3D"http://apache.org/xml/xmlns/jakarta/commons/jocl">
   <!-- the first argument is the ConnectionFactory -->
   <object class=3D"org.apache.commons.dbcp.DriverManagerConnectionFactory"=
>
      <string value=3D"jdbc:some:connect:string"/>
      <object class=3D"java.util.Properties" null=3D"true"/>
   </object>
   <!-- the next argument is the ObjectPool -->
   <object class=3D"org.apache.commons.pool.impl.GenericObjectPool">
      <object class=3D"org.apache.commons.pool.PoolableObjectFactory" null=
=3D"true"/>
      <int value=3D"10"/> <!-- max active -->
      <byte value=3D"1"/> <!-- when exhausted action=2C 0 =3D fail=2C 1 =3D=
 block=2C 2 =3D grow -->
      <long value=3D"2000"/> <!-- max wait -->
      <int value=3D"10"/> <!-- max idle -->
      <boolean value=3D"false"/> <!-- test on borrow -->
      <boolean value=3D"false"/> <!-- test on return -->
      <long value=3D"10000"/> <!-- time between eviction runs -->
      <int value=3D"5"/> <!-- number of connections to test per eviction ru=
n -->
      <long value=3D"5000"/> <!-- min evictable idle time -->
      <boolean value=3D"true"/> <!-- test while idle -->
   </object>
   <!-- the next argument is the KeyedObjectPoolFactory -->
   <object class=3D"org.apache.commons.pool.impl.StackKeyedObjectPoolFactor=
y">
      <int value=3D"5"/> <!-- max idle -->
   </object>
   <string value=3D"SELECT COUNT(*) FROM DUAL"/> <!-- validation query -->
   <boolean value=3D"false"/> <!-- default read only -->
   <boolean value=3D"true"/> <!-- default auto commit -->
</object>herr shroeder suggests is change int value from 10 to 1 like this

      <int value=3D"10"/> <!-- max active -->
to=20
     <int value=3D"1"/> <!-- max active -->

Test_Harness (assuming the file you saved is in WEB-INF/classes/poolingDriv=
erExample.jocl
//  java -Djdbc.drivers=3D com.mysql.jdbc.Driver:org.apache.commons.dbcp.Po=
olingDriver \
//       -classpath commons-pool-1.3.jar:commons-dbcp-1.2.2.jar:oracle-jdbc=
.jar:jaxp.jar:parser.jar:sax2.jar:. \
//       JOCLPoolingDriverExample
//       "jdbc:apache:commons:dbcp:/poolingDriverExample"
//       "SELECT * FROM DUAL"

the above test harness only works for jdbc MySQL driver
you will have to sub in your DAO MySQL driver ..here is a DAO wrapper on My=
SQL jdbc driver
https://wikihub.berkeley.edu/display/istas/Class+10+-+June+4+-+DAO=2C+Conne=
ction+Pool
read this
http://commons.apache.org/dbcp/apidocs/org/apache/commons/dbcp/package-summ=
ary.html

Viel Gluck/Buena Suerte
Martin Gainty=20
______________________________________________=20
Verzicht und Vertraulichkeitanmerkung
=20
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaeng=
er sein=2C so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiter=
leitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient l=
ediglich dem Austausch von Informationen und entfaltet keine rechtliche Bin=
dungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen w=
ir keine Haftung fuer den Inhalt uebernehmen.






> Date: Fri=2C 14 Aug 2009 18:04:33 -0700
> From: kwalker@sbceo.org
> To: users@tomcat.apache.org
> Subject: Re: Connection Pool Exhausted
>=20
> Sorry if this is a stupid question=2C I am pretty new to this=2C but how =
do I set
> the db connection pool size to 1?
>=20
> Thanks=2C
> Kristen
>=20
> Quoting Hassan Schroeder <hassan.schroeder@gmail.com>:
> >
> > On your test/staging server=2C set your db connection pool size to 1
> > and exercise the site=3B if there's a connection leak=2C you'll find it=
 pretty
> > fast. :-)
> >
> > --
> > Hassan Schroeder ------------------------ hassan.schroeder@gmail.com
> > twitter: @hassan
> >
> >
>=20
>=20
>=20
>=20
>=20
> ---------------------------------------------------------------------
> To unsubscribe=2C e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands=2C e-mail: users-help@tomcat.apache.org
>=20

_________________________________________________________________
Get free photo software from Windows Live
http://www.windowslive.com/online/photos?ocid=3DPID23393::T:WLMTAGL:ON:WL:e=
n-US:SI_PH_software:082009=

--_8aecd388-7296-4049-94c7-1c08120ccaf4_--