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
You can configure torque to use the
org.apache.torque.dsfactory.SharedPoolDataSourceFactory. Set
torque.dsfactory.torque.pool.testOnBorrow true. Provide a
torque.dsfactory.torque.pool.validationQuery. This setting up will
guarantee every connection returned from the pool is a good one.
Andras
Users List
Subject: Re: Problems with Mysql timeout
You can configure torque to use the
org.apache.torque.dsfactory.SharedPoolDataSourceFactory. Set
torque.dsfactory.torque.pool.testOnBorrow true. Provide a
torque.dsfactory.torque.pool.validationQuery. This setting up will guarantee
every connection
: Tuesday, February 08, 2005 9:28 AM
To: Apache Torque Users List
Subject: Re: Problems with Mysql timeout
You can configure torque to use the
org.apache.torque.dsfactory.SharedPoolDataSourceFactory. Set
torque.dsfactory.torque.pool.testOnBorrow true. Provide
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
Hi,
Yet another solution on the client side: Whether a connection timeout can
be configured depends on the connection pool you are using. If you are
using SharedPoolDataSource, it should be possible to tell the pool to close
unused connections after a certain period of time. See the
: 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
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 08, 2005 10:24 AM
To: Apache Torque Users List
Subject: Re: 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
, 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
Message-
From: Bill Leng [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 08, 2005 10:24 AM
To: Apache Torque Users List
Subject: Re: 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
Subject: Re: Problems with Mysql timeout
OK, here is my set up
config.setProperty(torque.dsfactory.torque.factory,
org.apache.torque.dsfactory.SharedPoolDataSourceFactory);
config.setProperty(torque.dsfactory.torque.pool.maxActive,
Integer.toString(50));
config.setProperty
12 matches
Mail list logo