I am using the 1.2.1 and 1.2 versions of the commons-dbcp* or commons-pool* jar files. I'll set my pool.initialSize = 1, just to check a connection at startup. torque.defaults.pool.maxIdle = 40 torque.defaults.pool.maxActive = 60
The testOnBorrow = true is a good idea, looks like that is the default. Thank guys!! --- Greg Monroe <[EMAIL PROTECTED]> wrote: > Hmm, everything looks fine. Did some splunking > looking for the > error message (thanks Eclipse for source jar > association!) and > found it in: > > org.apache.commond.dbcp.datasources.SharedPoolDataSource > > There should be a root cause exception associated > with this. > Probably coming from GenericKeyedObjectPool. > Knowing this would > help pinpoint the error location in the commons > code. > > FWIW, the testOnBorrow option does add a little > overhead but > it also help protect against connections that where > closed > due to network or DB server problems (server > restarted or > server connection timeout reached). > > Some other "standard" debugging stuff that you've > probably done: > > Do you have any other commons-dbcp* or commons-pool* > jar files > in the path beside the 1.2* versions in distro? > Could be a bug > in an older version. > > Does your app do anything that would not release > connections? E.g., > getting connections from the pool directly and not > releasing them > or do you use transactions and don't finish with a > commit or > rollback? Turning on Torque/commons debugging might > help identify > such problems. > > > -----Original Message----- > > From: Jim Caserta [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, December 14, 2005 12:23 PM > > To: Apache Torque Users List > > Subject: RE: Could not retrieve connection info > from pool - DB2 > > > > > > 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.S > > haredPoolDataSourceFactory > > 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 > > > > > > 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]
