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]
