db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christian Bach <christian.b...@polyester.se>
Subject Torque + SharedPoolDataSourceFactory + Mysql problems
Date Fri, 18 Feb 2005 10:49:47 GMT
Hi,

Where running an app on tomcat built with Turbine and Torque and with a 
Mysql database.

Where using the SharedPoolDataSourceFactory to manage the connection 
pool to the database.
And there seems to be a problem on how this is beeing used, after 
uppgrading to Torque 3.1.1
the app would only run for aprox 5 minutes and then it would "stall". 
The problem seemed to be
that the pool was not being reused. This was with the testOnBorrow 
option enabled.

What sorted our problem out was using the minEvictableIdleTimeMillis 
option, now the app
has been up and running for servral days but it seems that some times i 
can take up to 40sec to
access the app if now current connection to the database is open.
Wich is a bit strange when our Mysql database shows that there are 5 
idle connection.
And Torque still wants to open a new one and disgards the old.

Any ides?

Best regards
Christian Bach

Our setup:
Turbine-2.3.1
Torque-3.1.1
Tomcat-5.0.29
J2sdk1.4.2_05
Mysql-4.0.23a

Our libs:
avalon-framework-4.1.4.jar           
commons-beanutils-1.6.1.jar          
commons-codec-1.1.jar                
commons-collections-3.0.jar          
commons-configuration-1.0.jar        
commons-dbcp-1.2.1.jar               
commons-digester-1.5.jar             
commons-email-20030310.165926.jar    
commons-fileupload-1.0.jar           
commons-lang-2.0.jar                 
commons-logging-api.jar              
commons-logging.jar                  
commons-pool-1.2.jar                 
cryptix-3.2.0.jar                    
dom4j-1.4.jar                        
ecs-1.4.2.jar                        
excalibur-component-1.1.jar          
excalibur-instrument-1.0.jar         
excalibur-logger-1.0.1.jar           
excalibur-pool-1.2.jar                                      
hsqldb-1.7.1.jar                     
javamail-1.3.1.jar                   
jcs-20030822.182132.jar              
jdbc-2.0.jar                         
jndi-1.2.1.jar                       
junit-3.8.1.jar                      
jython-2.1.jar                       
log4j-1.2.8.jar                      
logkit-1.0.1.jar                     
mysql-connector-java-3.0.16-ga-bin.jar
oro-2.0.7.jar                        
stratum-1.0-b5.jar                   
torque-3.1.1.jar                     
turbine-2.3.1.jar                    
velocity-1.3.1.jar                   
village-2.0-dev-20030825.jar         
web-app_2_3.dtd                      
xalan-2.5.1.jar                      
xercesImpl-2.4.0.jar                 
xml-apis-1.0.b2.jar                  
xmlrpc-1.2-b1.jar   

Here is our Torqe.properties.

# -------------------------------------------------------------------
# $Id: Torque.properties,v 1.17 2005/01/10 19:25:03 cvs 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.
# -------------------------------------------------------------------
# 2004-03-04: This should be configured from Log4j.properties.

# 2003-12-01:
torque.addIntakeRetrievable = true
torque.retrievableInterface = org.apache.turbine.om.Retrievable

# -------------------------------------------------------------------
#
#  D E F A U L T S
#
# -------------------------------------------------------------------
#
# These values kick in, if you don't explicitly override them in your
# various database settings. At the moment they're only used if you
# configure the TorqueDataSourceFactory of the Jdbc2PoolDataSourceFactory
# as your data source provider. It does not work with JNDI.
#
# The example is shown for TorqueDataSource.
#
# -------------------------------------------------------------------

torque.defaults.connection.driver = com.mysql.jdbc.Driver

#torque.defaults.pool.testOnBorrow=true
#torque.defaults.pool.validationQuery=SELECT 1
torque.defaults.pool.maxActive=15
torque.defaults.pool.timeBetweenEvictionRunsMillis = 60000
torque.defaults.pool.minEvictableIdleTimeMillis = 600000
torque.defaults.pool.maxWait = 500
torque.defaults.pool.maxIdle = 5

# Sets the URL for the datasources
torque.defaults.connection.url = 
jdbc:mysql://localhost:3306/polyshop?autoReconnect=true

# Sets login and password for the data sources.
torque.defaults.connection.user = *********
torque.defaults.connection.password = *********


# -------------------------------------------------------------------
#
#  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 = polyshop

torque.database.polyshop.adapter=mysql

torque.dsfactory.polyshop.factory=org.apache.torque.dsfactory.SharedPoolDataSourceFactory

#torque.dsfactory.polyshop.pool.testOnBorrow = true
#torque.dsfactory.polyshop.pool.validationQuery = SELECT 1
torque.dsfactory.polyshop.pool.maxActive = 15
torque.dsfactory.polyshop.pool.maxWait = 500
torque.dsfactory.polyshop.pool.maxIdle = 5
torque.dsfactory.polyshop.pool.timeBetweenEvictionRunsMillis = 60000
torque.dsfactory.polyshop.pool.minEvictableIdleTimeMillis = 600000

torque.dsfactory.polyshop.connection.driver = com.mysql.jdbc.Driver
torque.dsfactory.polyshop.connection.url = 
jdbc:mysql://localhost:3306/polyshop?autoReconnect=true
torque.dsfactory.polyshop.connection.user = *********
torque.dsfactory.polyshop.connection.password = *********

# Determines if the quantity column of the IDBroker's id_table should
# be increased automatically if requests for ids reaches a high
# 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 = false

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message