db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jim Caserta <smoothie...@yahoo.com>
Subject RE: Could not retrieve connection info from pool - DB2
Date Wed, 14 Dec 2005 16:34:55 GMT
I'm using 3.2 rc2.. I am using the new properties file
and I will try using the following:

torque.defaults.pool.maxIdle = 40
torque.defaults.pool.maxActive = 60
torque.defaults.pool.maxWait = 50000

I just found out it could have 40 people at one time,
rarely but it's possible..

Thanks!


--- Greg Monroe <Greg.Monroe@DukeCE.com> wrote:

> Did you upgrade from an earlier version of Torque? 
> One gotcha I have 
> 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 
> compare it to yours.
> 
> Also, what JDBC driver and DB are you using?  I seem
> to remember this 
> problem and some relationship to a DB connection in
> the pool timing 
> out and not automatically reconnecting when
> retrieved.  I know that
> MySQL has an auto reconnect parameter that should be
> on the URL but 
> can't remember the syntax right now.
> 
> FWIW, I've done load testing of a Torque based
> webapp with up to 400 
> 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).  
> And I don't have any special limits set in the
> Torque properties.
> 
> Good luck.
> 
> Greg
> 
> > -----Original Message-----
> > From: Jim Caserta
> > 
> > Hi,
> > 
> > I'm now using version 3.2 RC2 and I'm receiving
> the
> > following:
> > Could not retrieve connection info from pool.
> > 
> > My property file has the following:
> > torque.defaults.pool.maxIdle = 8
> > torque.defaults.pool.maxActive = 10
> > torque.defaults.pool.maxWait = 10000
> >
> torque.defaults.pool.timeBetweenEvictionRunsMillis=
> > 300000
> > 
> > 
> > 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??
> > 
> > Thank you for any help!
> > Jim
> > 
> > 
> > __________________________________________________
> > Do You Yahoo!?
> > Tired of spam?  Yahoo! Mail has the best spam
> protection around 
> > http://mail.yahoo.com 
> > 
> >
>
---------------------------------------------------------------------
> > To unsubscribe, e-mail:
> torque-user-unsubscribe@db.apache.org
> > For additional commands, e-mail:
> torque-user-help@db.apache.org
> > 
> > 
> 
> 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.
> 
> 
> 
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail:
> torque-user-help@db.apache.org
> 
> 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

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


Mime
View raw message