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
I'll get the testOnBorrow set and try that. I'm new to Torque and am not
quite sure on how to setup the validationQuery. What is the process for
doing that?
Matt
-Original Message-
From: Bill Leng [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 08, 2005 9:28 AM
To: Apache Torque
such as
select 1 from someDbTable
Matthew P. Reath wrote:
I'll get the testOnBorrow set and try that. I'm new to Torque and am not
quite sure on how to setup the validationQuery. What is the process for
doing that?
Matt
-Original Message-
From: Bill Leng [mailto:[EMAIL PROTECTED]
Sent:
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:
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
#
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
Hi,
I tried to run the runtimetest on Derby for Torque 3.2-dev (cvs HEAD) this
morning, and it did not pass. Cloudscape as adapter also did not work. I
would not trust anything which does not pass the runtimetest, i.e. 3.2-dev
does not support derby yet.
Note that this does not necessarily
I did read the last email and I added your line in there, I was wondering
about the error messages I'm getting. Are those normal?
Matt
-Original Message-
From: Bill Leng [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 08, 2005 10:24 AM
To: Apache Torque Users List
Subject: Re:
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 messages I'm getting. Are those normal?
Matt
-Original Message-
From: Bill Leng
I fixed it after getting the log file snapshot. It is now select 1 from
Customer. I still get the list of errors and was wondering if that is normal
or if none of the settings are begin set.
Matt
-Original Message-
From: Bill Leng [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 08,
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));
I updated the commons-dbcp jar file and I no longer receive the errors. I
will know for sure come tomorrow morning whether it is fixed or not.
Matt
-Original Message-
From: Bill Leng [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 08, 2005 10:58 AM
To: Apache Torque Users List
13 matches
Mail list logo
