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
ED]
Sent: Tuesday, February 08, 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 w
, 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
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 those to the properties
iginal Message-
>From: Thomas Fischer [mailto:[EMAIL PROTECTED]
>Sent: Tuesday, February 08, 2005 9:53 AM
>To: Apache Torque Users List
>Subject: RE: Problems with Mysql timeout
>
>
>
>
>
>Hi,
>
>Yet another solution on the client side: Whether a connection
not supported by DataSource:
org.apache.commons.dbcp.datasources.SharedPoolDataSource
Any suggestions?
Matt
-Original Message-
From: Thomas Fischer [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 08, 2005 9:53 AM
To: Apache Torque Users List
Subject: RE: Problems with Mysql timeout
Hi
-Original Message-
From: Thomas Fischer [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 08, 2005 9:53 AM
To: Apache Torque Users List
Subject: RE: Problems with Mysql timeout
Hi,
Yet another solution on the client side: Whether a connection timeout can be
configured depends on the
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 documenta
e 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
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.
Matt
TED]
Sent: 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.
che 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 a
torque.dsfactory.torque.pool.validationQuery. This setting up will guarantee
every
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
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/T
14 matches
Mail list logo
