I've included a copy of my torque properties file. I have autoReconnect set to true already. I get the following errors in my log:
ERROR http-8080-Processor25 org.apache.torque.dsfactory.AbstractDataSourceFactory - Property: defaultMaxActive value: 10 is not supported by DataSource: org.apache.commons.dbcp.datasources.SharedPoolDataSource ERROR http-8080-Processor25 org.apache.torque.dsfactory.AbstractDataSourceFactory - Property: testOnBorrow value: true is not supported by DataSource: org.apache.commons.dbcp.datasources.SharedPoolDataSource ERROR http-8080-Processor25 org.apache.torque.dsfactory.AbstractDataSourceFactory - Property: validationQuery value: SELECT 1 is not supported by DataSource: org.apache.commons.dbcp.datasources.SharedPoolDataSource Matt -----Original Message----- From: Andras Balogh [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 08, 2005 9:13 AM To: Apache Torque Users List Subject: Re: Problems with Mysql timeout Hello, This is a MySQL related prolbem You must specify autoreconnect=true (or something like) that at connection properties. You will find this info on the mysql site, jdbc connection properties. Best regards, Andras. Matthew P. Reath wrote: >I'm developing a web-based application using Tomcat/Torque/MySQL. The >problem I run into is that after 8 hours of inactivity the persistent >connection Torque uses becomes invalid and I get an exception. The next >time I try it works. After another 8 hours of idle time the process repeats. > >I searched the internet for answers but most of them involved good >programming practice to handle this situation in one's own JDBC code, I >however am using Torque. > >Is there a way to configure Torque to handle this timeout period? I'd >rather not depend on the connection always being there in case it was >dropped because of network problems or what not. Ideally I would like >Torque to reconnect anytime it's connection becomes invalid or do some >sort of heartbeat. > >Thanks, >Matt > > >--------------------------------------------------------------------- >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]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]