Okay didn't send it. I'm including here: # ------------------------------------------------------------------- # $Id: Torque.properties,v 1.4 2005/02/03 14:31:42 mpreath Exp $ # # This is the configuration file for Torque. # # Note that strings containing "," (comma) characters must backslash # escape the comma (i.e. '\,') # # -------------------------------------------------------------------
torque.applicationRoot = . # ------------------------------------------------------------------- # # L O G G I N G # # ------------------------------------------------------------------- # We use Log4J for all Torque logging and we embed the log4j # properties within our application configuration. # ------------------------------------------------------------------- # This first category is required and the category # must be named 'default'. This is used for all logging # where an explicit category is not specified. log4j.category.org.apache.torque = ALL, org.apache.torque log4j.appender.org.apache.torque = org.apache.log4j.FileAppender log4j.appender.org.apache.torque.file = ${torque.applicationRoot}/logs/torque.log log4j.appender.org.apache.torque.layout = org.apache.log4j.PatternLayout log4j.appender.org.apache.torque.layout.conversionPattern = %d [%t] %-5p %c - %m%n log4j.appender.org.apache.torque.append = false # ------------------------------------------------------------------- # # T O R Q U E P R O P E R T I E S # # ------------------------------------------------------------------- # These are your database settings. Look in the # org.apache.torque.pool.* packages for more information. # # The parameters to connect to the default database. You MUST # configure these properly. # ------------------------------------------------------------------- torque.database.default=bmc2 torque.database.bmc2.adapter=mysql ## Using commons-dbcp torque.dsfactory.bmc2.factory=org.apache.torque.dsfactory.SharedPoolDataSour ceFactory #torque.dsfactory.bmc2.factory=org.apache.torque.dsfactory.PerUserPoolDataSo urceFactory torque.dsfactory.bmc2.pool.defaultMaxActive=10 torque.dsfactory.bmc2.pool.testOnBorrow=true torque.dsfactory.bmc2.pool.validationQuery=SELECT 1 torque.dsfactory.bmc2.connection.driver = org.gjt.mm.mysql.Driver torque.dsfactory.bmc2.connection.url = jdbc:mysql://localhost/bmc2?autoReconnect=true torque.dsfactory.bmc2.connection.user = bmc2 torque.dsfactory.bmc2.connection.password = ## Using jndi #torque.dsfactory.bmc2.factory=org.apache.torque.dsfactory.JndiDataSourceFac tory #torque.dsfactory.bmc2.jndi.path=jdbc/bmc2 #torque.dsfactory.bmc2.jndi.java.naming.factory.initial = org.apache.naming.java.javaURLContextFactory #torque.dsfactory.bmc2.jndi.java.naming.factory.url.pkgs = org.apache.naming #torque.dsfactory.bmc2.datasource.classname=org.apache.torque.pool.TorqueCla ssicDataSource #torque.dsfactory.bmc2.datasource.dataSourceName=jdbc/DBbmc2 #torque.dsfactory.bmc2.datasource.jndiEnvironment.java.naming.factory.initia l = org.apache.naming.java.javaURLContextFactory #torque.dsfactory.bmc2.datasource.jndiEnvironment.java.naming.factory.url.pk gs = org.apache.naming #torque.dsfactory.bmc2.datasource.defaultMaxConnections=10 ## ConnectionPoolDataSource #torque.dsfactory.bmc2.factory=org.apache.torque.dsfactory.JndiDataSourceFac tory #torque.dsfactory.bmc2.jndi.path=jdbc/DBbmc2 #torque.dsfactory.bmc2.jndi.java.naming.factory.initial = org.apache.naming.java.javaURLContextFactory #torque.dsfactory.bmc2.jndi.java.naming.factory.url.pkgs = org.apache.naming #torque.dsfactory.bmc2.datasource.classname=org.apache.commons.dbcp.cpdsadap ter.DriverAdapterCPDS #torque.dsfactory.bmc2.datasource.driver = org.gjt.mm.mysql.Driver #torque.dsfactory.bmc2.datasource.url = jdbc:mysql://localhost/bmc2 #torque.dsfactory.bmc2.datasource.user = bmc2 #torque.dsfactory.bmc2.datasource.password = XxUon8sm # Determines if the quantity column of the IDBroker's id_table should # be increased automatically if requests for ids reaches a highs # volume. torque.idbroker.cleverquantity=true # Determines whether the managers cache instances of the business objects. # And also whether the MethodResultCache will really cache results. torque.manager.useCache = true -----Original Message----- From: Matthew P. Reath [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 08, 2005 9:43 AM To: 'Apache Torque Users List' Subject: RE: Problems with Mysql timeout 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]