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 stripped out. FWIW, I use the following pool properties format: torque.database.default=default torque.dsfactory.default.factory=org.apache.torque.dsfactory.SharedPoolD ataSourceFactory torque.dsfactory.default.pool.maxIdle=8 torque.dsfactory.default.pool.maxActive=10 torque.dsfactory.default.pool.testOnBorrow=true torque.dsfactory.default.pool.validationQuery=SELECT 1 What factory are you using for pooling? All of the Torque settings don't apply if you're using JNDI. The pool settings for a JNDI factory need to be set in the container that defines the JNDI connection. > -----Original Message----- > From: Jim Caserta > > 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 <[EMAIL PROTECTED]> 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: > > [EMAIL PROTECTED] > > > For additional commands, e-mail: > > [EMAIL PROTECTED] > > > > > > > > > > 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: > > [EMAIL PROTECTED] > > For additional commands, e-mail: > > [EMAIL PROTECTED] > > > > > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
