Michael Bila <[EMAIL PROTECTED]> - Fri, Nov 07, 2003:
> torque.dsfactory.default.factory=org.apache.torque.dsfactory.TorqueDataSourc
> eFactory
That one is deprecated, sorry I can't recall where I read that, use
SharedPool instead.
I attached my template Torque.properties.
--
Loïc Minier <[EMAIL PROTECTED]>
# runtime properties for the Torque subproject
torque.applicationRoot = .
######
# LOG4J's logging settings for Torque
# We use Log4J for all Torque logging and we embed the log4j
# properties within our application configuration.
# This first category is required and the category
# must be named 'default'. This is used for all logging
# where an explicit category is not specified.
log4j.category.org.apache.torque = ALL, org.apache.torque
log4j.appender.org.apache.torque = org.apache.log4j.FileAppender
log4j.appender.org.apache.torque.file = ${torque.applicationRoot}/logs/torque.log
log4j.appender.org.apache.torque.layout = org.apache.log4j.PatternLayout
log4j.appender.org.apache.torque.layout.conversionPattern = %d [%t] %-5p %c - %m%n
log4j.appender.org.apache.torque.append = false
######
# Torque default settings (common for all databases accessed by Torque)
# 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.
# If > 0, then a monitoring thread is started for every pool to
# display the number of created, available and checked out connections
# The interval is in seconds.
#torque.defaults.pool.logInterval = 0
# Time to wait for a connection to the databas in Seconds.
#torque.defaults.pool.connectionWaitTimeout = 10
# Maximum number of connections cached in a database definition. Note
# that, if you have multiple database definitions which access the
# same database URL, they don't share the connections but you have
# multiple pools and each has this maximum number. So if you have a
# connection licensed database engine, you must multiply this number by
# the number of times you use a specific database URL.
#torque.defaults.pool.defaultMaxConnections = 80
# Lifetime of a connection in the pool. Defaults to one hour
#torque.defaults.pool.maxExpiryTime = 3600
# Sets the driver for the data sources.
#torque.defaults.connection.driver = org.gjt.mm.mysql.Driver
# Sets the URL for the datasources
#torque.defaults.connection.url = jdbc:mysql://localhost:3306/torque
# Sets login and password for the data sources.
#torque.defaults.connection.user = user
#torque.defaults.connection.password = password
######
# JDBC's database connection settings for Torque
# 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 = databaseName
torque.database.databaseName.adapter = postgresql
torque.database.databaseName.driver = org.postgresql.Driver
torque.database.databaseName.url = jdbc:postgresql://127.0.0.1/databaseName
torque.database.databaseName.username = userName
torque.database.databaseName.password = pass
torque.dsfactory.databaseName.factory =
org.apache.torque.dsfactory.SharedPoolDataSourceFactory
torque.dsfactory.databaseName.pool.defaultMaxActive = 10
torque.dsfactory.databaseName.pool.testOnBorrow = true
torque.dsfactory.databaseName.pool.validationQuery = SELECT 1
torque.dsfactory.databaseName.connection.driver = org.postgresql.Driver
torque.dsfactory.databaseName.connection.url = jdbc:postgresql://127.0.0.1/databaseName
torque.dsfactory.databaseName.connection.user = userName
torque.dsfactory.databaseName.connection.password = pass
## Using torque's old pool
## this implementation is deprecated and has some known bugs!!!!
## you should use commons-dbcp
#torque.dsfactory.bookstore.factory=org.apache.torque.dsfactory.TorqueDataSourceFactory
#torque.dsfactory.bookstore.pool.defaultMaxConnections=10
#torque.dsfactory.bookstore.pool.maxExpiryTime=3600
#torque.dsfactory.bookstore.pool.connectionWaitTimeout=10
#torque.dsfactory.bookstore.connection.driver = org.gjt.mm.mysql.Driver
#torque.dsfactory.bookstore.connection.url = jdbc:mysql://localhost:3306/torque
#torque.dsfactory.bookstore.connection.user = user
#torque.dsfactory.bookstore.connection.password = password
## Using commons-dbcp
#torque.dsfactory.bookstore.factory=org.apache.torque.dsfactory.SharedPoolDataSourceFactory
##torque.dsfactory.bookstore.factory=org.apache.torque.dsfactory.PerUserPoolDataSourceFactory
#torque.dsfactory.bookstore.pool.defaultMaxActive=10
#torque.dsfactory.bookstore.pool.testOnBorrow=true
#torque.dsfactory.bookstore.pool.validationQuery=SELECT 1
#torque.dsfactory.bookstore.connection.driver = org.gjt.mm.mysql.Driver
#torque.dsfactory.bookstore.connection.url = jdbc:mysql://localhost:3306/torque
#torque.dsfactory.bookstore.connection.user = user
#torque.dsfactory.bookstore.connection.password = password
## Using jndi
#torque.dsfactory.bookstore.factory=org.apache.torque.dsfactory.JndiDataSourceFactory
#torque.dsfactory.bookstore.jndi.path=jdbc/bookstore
#torque.dsfactory.bookstore.jndi.java.naming.factory.initial =
org.apache.naming.java.javaURLContextFactory
#torque.dsfactory.bookstore.jndi.java.naming.factory.url.pkgs = org.apache.naming
#torque.dsfactory.bookstore.datasource.classname=org.apache.torque.pool.TorqueClassicDataSource
#torque.dsfactory.bookstore.datasource.dataSourceName=jdbc/DBbookstore
#torque.dsfactory.bookstore.datasource.jndiEnvironment.java.naming.factory.initial =
org.apache.naming.java.javaURLContextFactory
#torque.dsfactory.bookstore.datasource.jndiEnvironment.java.naming.factory.url.pkgs =
org.apache.naming
#torque.dsfactory.bookstore.datasource.defaultMaxConnections=10
## ConnectionPoolDataSource
#torque.dsfactory.bookstore.factory=org.apache.torque.dsfactory.JndiDataSourceFactory
#torque.dsfactory.bookstore.jndi.path=jdbc/DBbookstore
#torque.dsfactory.bookstore.jndi.java.naming.factory.initial =
org.apache.naming.java.javaURLContextFactory
#torque.dsfactory.bookstore.jndi.java.naming.factory.url.pkgs = org.apache.naming
#torque.dsfactory.bookstore.datasource.classname=org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS
#torque.dsfactory.bookstore.datasource.driver = org.gjt.mm.mysql.Driver
#torque.dsfactory.bookstore.datasource.url = jdbc:mysql://localhost:3306/torque
#torque.dsfactory.bookstore.datasource.user = user
#torque.dsfactory.bookstore.datasource.password = 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 = true
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
