Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 11300 invoked from network); 3 Feb 2004 11:56:12 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12) by minotaur-2.apache.org with SMTP; 3 Feb 2004 11:56:12 -0000 Received: (qmail 10486 invoked by uid 500); 3 Feb 2004 11:56:04 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 10461 invoked by uid 500); 3 Feb 2004 11:56:04 -0000 Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Apache Torque Users List" Reply-To: "Apache Torque Users List" Delivered-To: mailing list torque-user@db.apache.org Received: (qmail 10418 invoked from network); 3 Feb 2004 11:56:03 -0000 Received: from unknown (HELO eufig1.rit.reuters.com) (194.205.123.3) by daedalus.apache.org with SMTP; 3 Feb 2004 11:56:03 -0000 Received: from no.name.available by eufig1.rit.reuters.com via smtpd (for daedalus.apache.org [208.185.179.12]) with SMTP; 3 Feb 2004 11:56:03 UT Received: from eupig1 (unverified) by dtcseuvig4.dtc.lon.ime.reuters.com (Content Technologies SMTPRS 4.3.10) with ESMTP id for ; Tue, 3 Feb 2004 11:52:09 +0000 Message-ID: Received: from gsssmsxb01.emea.ime.reuters.com ([10.5.150.32]) by eupig1.dtc.lon.ime.reuters.com (PMDF V6.1-1 #30693) with ESMTP id <0HSI007DWBT934@eupig1.dtc.lon.ime.reuters.com> for torque-user@db.apache.org; Tue, 03 Feb 2004 11:55:57 +0000 (GMT) Received: from LONSMSXM01.emea.ime.reuters.com ([10.5.150.34]) by gsssmsxb01.emea.ime.reuters.com with Microsoft SMTPSVC (5.0.2195.6713); Tue, 03 Feb 2004 11:55:57 +0000 Date: Tue, 03 Feb 2004 11:55:55 +0000 From: Edwin Yearwood Subject: RE: IDBroker warning To: Apache Torque Users List MIME-version: 1.0 X-MIMEOLE: Produced By Microsoft Exchange V6.0.6375.0 Content-type: text/plain; charset="us-ascii" Content-transfer-encoding: quoted-printable Thread-Topic: IDBroker warning Thread-Index: AcPp1xYiUTq9b6VKRNC6seTEbONz5wAdBemA content-class: urn:content-classes:message X-MS-Has-Attach: X-MS-TNEF-Correlator: X-OriginalArrivalTime: 03 Feb 2004 11:55:57.0077 (UTC) FILETIME=[AEFD8450:01C3EA4C] X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N 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 =3D . # ------------------------------------------------------------------- # # 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 =3D ALL, org.apache.torque log4j.appender.org.apache.torque =3D org.apache.log4j.FileAppender log4j.appender.org.apache.torque.file =3D ${torque.applicationRoot}/logs/torque.log log4j.appender.org.apache.torque.layout =3D org.apache.log4j.PatternLayout log4j.appender.org.apache.torque.layout.conversionPattern =3D %d [%t] %-5p %c - %m%n log4j.appender.org.apache.torque.append =3D 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 =3D 0 # Time to wait for a connection to the databas in Seconds. torque.defaults.pool.connectionWaitTimeout =3D 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 =3D 80 # Lifetime of a connection in the pool. Defaults to one hour torque.defaults.pool.maxExpiryTime =3D 3600 # Sets the driver for the data sources. torque.defaults.connection.driver =3D org.gjt.mm.mysql.Driver # Sets the URL for the datasources torque.defaults.connection.url =3D jdbc:mysql://localhost:3306/torque # Sets login and password for the data sources. torque.defaults.connection.user =3D user torque.defaults.connection.password =3D 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=3Dbookstore #torque.database.bookstore.adapter=3Dmysql ## Using torque's old pool ## this implementation is deprecated and has some known bugs!!!! ## you should use commons-dbcp #torque.dsfactory.bookstore.factory=3Dorg.apache.torque.dsfactory.TorqueDa taSourceFactory #torque.dsfactory.bookstore.pool.defaultMaxConnections=3D10 #torque.dsfactory.bookstore.pool.maxExpiryTime=3D3600 #torque.dsfactory.bookstore.pool.connectionWaitTimeout=3D10 #torque.dsfactory.bookstore.connection.driver =3D org.gjt.mm.mysql.Driver #torque.dsfactory.bookstore.connection.url =3D jdbc:mysql://localhost:3306/torque #torque.dsfactory.bookstore.connection.user =3D user #torque.dsfactory.bookstore.connection.password =3D password ## Using commons-dbcp torque.database.database.adapter=3Doracle torque.dsfactory.database.factory=3Dorg.apache.torque.dsfactory.SharedPool DataSourceFactory #torque.dsfactory.database.factory=3Dorg.apache.torque.dsfactory.Jdbc2Pool DataSourceFactory #torque.dsfactory.bookstore.factory=3Dorg.apache.torque.dsfactory.PerUserP oolDataSourceFactory torque.dsfactory.database.pool.defaultMaxActive=3D10 torque.dsfactory.database.pool.testOnBorrow=3Dtrue torque.dsfactory.database.pool.validationQuery=3DSELECT 1 torque.dsfactory.database.connection.driver =3D oracle.jdbc.driver.OracleDriver torque.dsfactory.database.connection.url =3D jdbc:oracle:thin:@::Database torque.dsfactory.database.connection.user =3D torque.dsfactory.database.connection.password =3D ## Using jndi #torque.dsfactory.bookstore.factory=3Dorg.apache.torque.dsfactory.JndiData SourceFactory #torque.dsfactory.bookstore.jndi.path=3Djdbc/bookstore #torque.dsfactory.bookstore.jndi.java.naming.factory.initial =3D org.apache.naming.java.javaURLContextFactory #torque.dsfactory.bookstore.jndi.java.naming.factory.url.pkgs =3D org.apache.naming #torque.dsfactory.bookstore.datasource.classname=3Dorg.apache.torque.pool. TorqueClassicDataSource #torque.dsfactory.bookstore.datasource.dataSourceName=3Djdbc/DBbookstore #torque.dsfactory.bookstore.datasource.jndiEnvironment.java.naming.facto ry.initial =3D org.apache.naming.java.javaURLContextFactory #torque.dsfactory.bookstore.datasource.jndiEnvironment.java.naming.facto ry.url.pkgs =3D org.apache.naming #torque.dsfactory.bookstore.datasource.defaultMaxConnections=3D10 ## ConnectionPoolDataSource #torque.dsfactory.bookstore.factory=3Dorg.apache.torque.dsfactory.JndiData SourceFactory #torque.dsfactory.bookstore.jndi.path=3Djdbc/DBbookstore #torque.dsfactory.bookstore.jndi.java.naming.factory.initial =3D org.apache.naming.java.javaURLContextFactory #torque.dsfactory.bookstore.jndi.java.naming.factory.url.pkgs =3D org.apache.naming #torque.dsfactory.bookstore.datasource.classname=3Dorg.apache.commons.dbcp .cpdsadapter.DriverAdapterCPDS #torque.dsfactory.bookstore.datasource.driver =3D org.gjt.mm.mysql.Driver #torque.dsfactory.bookstore.datasource.url =3D jdbc:mysql://localhost:3306/torque #torque.dsfactory.bookstore.datasource.user =3D user #torque.dsfactory.bookstore.datasource.password =3D 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=3Dtrue # Determines whether the managers cache instances of the business objects. # And also whether the MethodResultCache will really cache results. torque.manager.useCache =3D true # tutorial: log4j.rootCategory =3D DEBUG, default log4j.appender.default =3D org.apache.log4j.FileAppender log4j.appender.default.file =3D ./torque.log log4j.appender.default.layout =3D org.apache.log4j.SimpleLayout torque.database.default=3DDatabase torque.database.database.driver =3D oracle.jdbc.driver.OracleDriver torque.database.database.url =3D jdbc:oracle:thin:::Database torque.database.database.username =3D torque.database.database.password =3D 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]=20 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=20 >used with db 'DATABASE', which does not support transactions...". > =20 > What RDBMS are you using? This message will typically appear when the=20 RDBMS in use does not support transactions (e.g. MySQL), though if you=20 search the archives you may find queries and answers concerning=20 occurrences of this message when transactions are in fact supported. Scott --=20 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