Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
Received-SPF: pass (asf.osuosl.org: domain of Greg.Monroe@dukece.com
 designates 65.112.55.73 as permitted sender)
Content-class: urn:content-classes:message
Subject: RE: Could not retrieve connection info from pool - DB2
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Date: Wed, 14 Dec 2005 12:11:12 -0500
Message-ID: <8F5843B903F59D4C8C6806BB49A39119062917@dukece-mail3.dukece.com>
Thread-Topic: Could not retrieve connection info from pool - DB2
Thread-Index: AcYAzF6hsxlW6/q4RiGytJb1TLxaTQAAyuvA
From: "Greg Monroe" <Greg.Monroe@DukeCE.com>
To: "Apache Torque Users List" <torque-user@db.apache.org>

First, a quick correction... typing too slow for the thoughts.
My initial note should have said: done load testing... and have
*NOT* seen this message.

Also, I just checked and saw those settings in the distro.  For
some reason, the Torque.properties I was referring to had them=20
stripped out.  FWIW, I use the following pool properties format:

torque.database.default=3Ddefault

torque.dsfactory.default.factory=3Dorg.apache.torque.dsfactory.SharedPool=
D
ataSourceFactory
torque.dsfactory.default.pool.maxIdle=3D8
torque.dsfactory.default.pool.maxActive=3D10
torque.dsfactory.default.pool.testOnBorrow=3Dtrue
torque.dsfactory.default.pool.validationQuery=3DSELECT 1

What factory are you using for pooling?  All of the Torque=20
settings don't apply if you're using JNDI.  The pool settings=20
for a JNDI factory need to be set in the container that defines=20
the JNDI connection.


> -----Original Message-----
> From: Jim Caserta
>=20
> I'm using 3.2 rc2.. I am using the new properties file
> and I will try using the following:
>=20
> torque.defaults.pool.maxIdle =3D 40
> torque.defaults.pool.maxActive =3D 60
> torque.defaults.pool.maxWait =3D 50000
>=20
> I just found out it could have 40 people at one time,
> rarely but it's possible..
>=20
> Thanks!
>=20
>=20
> --- Greg Monroe <Greg.Monroe@DukeCE.com> wrote:
>=20
> > Did you upgrade from an earlier version of Torque?=20
> > One gotcha I have=20
> > seen is that some of the Torque properties have
> > changed.  I say this
> > because I don't thing the properties below are the
> > current syntax. Look
> > at the default Torque.properties file that comes
> > with the distro and=20
> > compare it to yours.
> >=20
> > Also, what JDBC driver and DB are you using?  I seem
> > to remember this=20
> > problem and some relationship to a DB connection in
> > the pool timing=20
> > out and not automatically reconnecting when
> > retrieved.  I know that
> > MySQL has an auto reconnect parameter that should be
> > on the URL but=20
> > can't remember the syntax right now.
> >=20
> > FWIW, I've done load testing of a Torque based
> > webapp with up to 400=20
> > concurrent users with the pool size set at various
> > levels (from 10 on
> > up) and did get this message.  So it's not a matter
> > of a having to have
> > one connection for each user (but it does help
> > performance a little). =20
> > And I don't have any special limits set in the
> > Torque properties.
> >=20
> > Good luck.
> >=20
> > Greg
> >=20
> > > -----Original Message-----
> > > From: Jim Caserta
> > >=20
> > > Hi,
> > >=20
> > > I'm now using version 3.2 RC2 and I'm receiving
> > the
> > > following:
> > > Could not retrieve connection info from pool.
> > >=20
> > > My property file has the following:
> > > torque.defaults.pool.maxIdle =3D 8
> > > torque.defaults.pool.maxActive =3D 10
> > > torque.defaults.pool.maxWait =3D 10000
> > >
> > torque.defaults.pool.timeBetweenEvictionRunsMillis=3D
> > > 300000
> > >=20
> > >=20
> > > Since I wil have approx 20 users hitting my app at
> > the
> > > same time, I'm not sure what to set these to, or
> > is
> > > there a default I'm not setting??
> > >=20
> > > Thank you for any help!
> > > Jim
> > >=20
> > >=20
> > > __________________________________________________
> > > Do You Yahoo!?
> > > Tired of spam?  Yahoo! Mail has the best spam
> > protection around=20
> > > http://mail.yahoo.com=20
> > >=20
> > >
> >
> ---------------------------------------------------------------------
> > > To unsubscribe, e-mail:
> > torque-user-unsubscribe@db.apache.org
> > > For additional commands, e-mail:
> > torque-user-help@db.apache.org
> > >=20
> > >=20
> >=20
> > Duke CE Privacy Statement
> > Please be advised that this e-mail and any files
> > transmitted with it are confidential communication
> > or may otherwise be privileged or confidential and
> > are intended solely for the individual or entity to
> > whom they are addressed.  If you are not the
> > intended recipient you may not rely on the contents
> > of this email or any attachments, and we ask that
> > you  please not read, copy or retransmit this
> > communication, but reply to the sender and destroy
> > the email, its contents, and all copies thereof
> > immediately.  Any unauthorized dissemination,
> > distribution or copying of this communication is
> > strictly prohibited.
> >=20
> >=20
> >=20
> >
> ---------------------------------------------------------------------
> > To unsubscribe, e-mail:
> > torque-user-unsubscribe@db.apache.org
> > For additional commands, e-mail:
> > torque-user-help@db.apache.org
> >=20
> >=20
>=20
>=20
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around=20
> http://mail.yahoo.com=20
>=20
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>=20
>=20

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org