db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Edwin Yearwood <Edwin.Yearw...@reuters.com>
Subject RE: IDBroker warning
Date Tue, 03 Feb 2004 11:55:55 GMT
Hi Scott,

I've trawled the archives to no avail, there doesn't seem to be any
specific resolution to this issue, Stephen Haberman's response to a
similar problem "nDataSourceFactory error about Idbroker when Id broker
not set" only suggests that the torque configuration is incorrect. I've
tried changing the config around but nothing works. I also get the
following error message from torque "There was no DataSourceFactory
configured for the connection DATABASE" similar to that in the archive
message highlighted above.

I'm currently using Oracle 8i with following torque config. This config
has worked with the bookstore example @ Torque Home the only difference
is with the database connection properties.

# -------------------------------------------------------------------
# $Id: Torque.properties,v 1.11 2003/08/19 19:09:44 mpoeschl 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.
# -------------------------------------------------------------------

# 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

# -------------------------------------------------------------------
#
#  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.
#
# -------------------------------------------------------------------

# 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

# -------------------------------------------------------------------
#
#  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=bookstore
#torque.database.bookstore.adapter=mysql

## 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.TorqueDa
taSourceFactory
#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.database.database.adapter=oracle
torque.dsfactory.database.factory=org.apache.torque.dsfactory.SharedPool
DataSourceFactory
#torque.dsfactory.database.factory=org.apache.torque.dsfactory.Jdbc2Pool
DataSourceFactory
#torque.dsfactory.bookstore.factory=org.apache.torque.dsfactory.PerUserP
oolDataSourceFactory
torque.dsfactory.database.pool.defaultMaxActive=10
torque.dsfactory.database.pool.testOnBorrow=true
torque.dsfactory.database.pool.validationQuery=SELECT 1
torque.dsfactory.database.connection.driver =
oracle.jdbc.driver.OracleDriver
torque.dsfactory.database.connection.url =
jdbc:oracle:thin:@<host>:<port>:Database
torque.dsfactory.database.connection.user = <username>
torque.dsfactory.database.connection.password = <password>


## Using jndi
#torque.dsfactory.bookstore.factory=org.apache.torque.dsfactory.JndiData
SourceFactory
#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.facto
ry.initial = org.apache.naming.java.javaURLContextFactory
#torque.dsfactory.bookstore.datasource.jndiEnvironment.java.naming.facto
ry.url.pkgs = org.apache.naming
#torque.dsfactory.bookstore.datasource.defaultMaxConnections=10

## ConnectionPoolDataSource
#torque.dsfactory.bookstore.factory=org.apache.torque.dsfactory.JndiData
SourceFactory
#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

# tutorial:
log4j.rootCategory = DEBUG, default
log4j.appender.default = org.apache.log4j.FileAppender
log4j.appender.default.file = ./torque.log
log4j.appender.default.layout = org.apache.log4j.SimpleLayout

torque.database.default=Database
torque.database.database.driver = oracle.jdbc.driver.OracleDriver
torque.database.database.url = jdbc:oracle:thin:<host>:<port>:Database
torque.database.database.username = <username>
torque.database.database.password = <password>

Thanks for any help you can provide.

Edwin Yearwood
Developer
BTG
Reuters

Telephone		+44 (0)208 542 5818
Email			edwin.yearwood@reuters.com
Reuters Messaging 	edwin.yearwood.reuters.com@reuters.net

-----Original Message-----
From: Scott Eade [mailto:seade@backstagetech.com.au] 
Sent: 02 February 2004 21:45
To: Apache Torque Users List
Subject: Re: IDBroker warning


Edwin Yearwood wrote:

>Has any one seen the following message before?, and if you have can you

>help me out with the solution "[WARN] IDBroker - -IDBroker is being 
>used with db 'DATABASE', which does not support transactions...".
>  
>
What RDBMS are you using?  This message will typically appear when the 
RDBMS in use does not support transactions (e.g. MySQL), though if you 
search the archives you may find queries and answers concerning 
occurrences of this message when transactions are in fact supported.

Scott

-- 
Scott Eade
Backstage Technologies Pty. Ltd. http://www.backstagetech.com.au



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



--------------------------------------------------------------- -
        Visit our Internet site at http://www.reuters.com

Get closer to the financial markets with Reuters Messaging - for more
information and to register, visit http://www.reuters.com/messaging

Any views expressed in this message are those of  the  individual
sender,  except  where  the sender specifically states them to be
the views of Reuters Ltd.


---------------------------------------------------------------------
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