When you say the "maximum memory pool", you are refering to the "pool.maxActive" number.. correct?
And leave the "maxidle" where it is? I'm a little fuzzy on how the maxidle affects how many connections are available in the pool.. Thanks! --- Greg Monroe <[EMAIL PROTECTED]> wrote: > I seem to remember getting this error when load > testing an application. I think the solution was > to bump up the JVM initial memory pool and > maximum memory pool (good thing to do by default). > > But then again, my neural net sometimes makes the > wrong connections as I get older. > > > -----Original Message----- > > From: Jim Caserta [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, January 31, 2006 8:25 AM > > To: Apache Torque Users List > > Subject: Pooled Connections Question - V 3.2 RC-2 > -= Java/DB2 > > > > > > Hi all, > > > > Occasionally we receive the following connection > error > > message: Torque Exception Message: . Error > Message > > is: org.apache.commons.dbcp.SQLNestedException: > Could > > not retrieve connection info from pool > > > > Occasionally we also find that a connection does > not > > close after a commit. Our code is basic.. > > > > con = > Torque.getConnection(db2.torque.environment)); > > //do stuff > > con.commit(); > > }finally { > > if (con != null) { //this is prob never null > > if (!con.isClosed()) { > > // send a message the con is NOT closed > > Torque.closeConnection(con); } > > > > Here is a portion of the prop file: > > > torque.dsfactory.eMarine.factory=org.apache.torque.dsfactory.S > > haredPoolDataSourceFactory > > torque.dsfactory.eMarine.connection.driver = > > COM.ibm.db2.jdbc.app.DB2Driver > > > > torque.defaults.pool.initialSize = 1 > > torque.defaults.pool.maxIdle = 40 > torque.defaults.pool.maxActive = 60 > > > > torque.defaults.pool.maxWait = 50000 > > > torque.defaults.pool.timeBetweenEvictionRunsMillis= > > 200000 > > torque.defaults.pool.minEvictableIdleTimeMillis = > > 2000000 > > torque.defaults.connection.driver = > > COM.ibm.db2.jdbc.app.DB2Driver > torque.idbroker.clever.quantity=true > > torque.manager.useCache = true > torque.database.eMarine.adapter=db2app > > torque.defaults.connection.driver = > > COM.ibm.db2.jdbc.app.DB2Driver > torque.defaults.connection.url > > = jdbc:db2:DB2B > > > > > > Does anything jump out that might be set wrong? > > > > 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]
