returned from the pool is a good one.
Andras Balogh wrote:
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
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
.
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
: Problems with Mysql timeout
do you read my last email?
the query string should be something like
SELECT 1 FROM sometable
Matthew P. Reath wrote:
I added those to the properties file but get the following errors in
the log
files:
ERROR http-8080-Processor25
, 2005 10:34 AM
To: Apache Torque Users List
Subject: Re: Problems with Mysql timeout
by reading your stack trace, your query string is
select 1
rather than
select 1 from sometable
Matthew P. Reath wrote:
I did read the last email and I added your line in there, I was
wondering about the error
(torque.dsfactory.torque.pool.testOnBorrow,
true);
config.setProperty(torque.dsfactory.torque.pool.validationQuery,
SELECT COUNT(PKEY) FROM IX_DB_TYPES);
assume the database name is torque.
if it still does not work, you need to read the torque's doc
Matthew P. Reath wrote:
I fixed it after