Here are my settings. I'm not using JNDI.. (I'm nit using testOnBorrow) torque.defaults.pool.maxWait = 50000 torque.defaults.pool.maxIdle = 40 torque.defaults.pool.maxActive = 60 torque.defaults.pool.timeBetweenEvictionRunsMillis= 300000 torque.defaults.pool.minEvictableIdleTimeMillis = 3600000 torque.defaults.connection.driver = COM.ibm.db2.jdbc.app.DB2Driver torque.defaults.connection.url = jdbc:db2:DB2B torque.database.eMarine.adapter=db2app torque.dsfactory.eMarine.factory=org.apache.torque.dsfactory.SharedPoolDataSourceFactory torque.dsfactory.eMarine.connection.driver = COM.ibm.db2.jdbc.app.DB2Driver torque.dsfactory.eMarine.connection.url = jdbc:db2:DB2B torque.idbroker.clever.quantity=true torque.manager.useCache = true
Jim --- Greg Monroe <[EMAIL PROTECTED]> wrote: > 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] > > === message truncated === __________________________________________________ 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]
