Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 47128 invoked from network); 29 Jun 2005 22:35:36 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 29 Jun 2005 22:35:36 -0000 Received: (qmail 77199 invoked by uid 500); 29 Jun 2005 22:35:34 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 77173 invoked by uid 500); 29 Jun 2005 22:35:33 -0000 Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: 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 77159 invoked by uid 99); 29 Jun 2005 22:35:33 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 29 Jun 2005 15:35:33 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: neutral (asf.osuosl.org: local policy) Received: from [66.163.170.74] (HELO smtp008.bizmail.sc5.yahoo.com) (66.163.170.74) by apache.org (qpsmtpd/0.29) with SMTP; Wed, 29 Jun 2005 15:35:35 -0700 Received: from unknown (HELO ?127.0.0.1?) (dcooper@fvt.com@209.76.35.34 with plain) by smtp008.bizmail.sc5.yahoo.com with SMTP; 29 Jun 2005 22:35:30 -0000 Message-ID: <42C322D4.9070008@fvt.com> Date: Wed, 29 Jun 2005 15:38:12 -0700 From: Dan Cooper User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Apache Torque Users List Subject: Re: MySql InnoDB question References: <004901c5784b$b1745a40$6201a8c0@win98> In-Reply-To: <004901c5784b$b1745a40$6201a8c0@win98> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Did you ever get past this problem? You should log into Mysql and run the command: show table status; on the easydesk database. This will show you what table types have been created in your database. I had this same problem with Torque when I first started and it turned out that Torque was not creating InnoDB tables. In my previous email to this list there are instructions on how to change the table type when using Torque to generate your schema. Regards & Happy Torqueing Dan Cooper Youngho Cho wrote: >Hello, > >Here is my test result. >I added log line into initialize() method. > >It looks like the torque initialize process has a problem for checking Tranasction Support or Not. >During initialize process, the IDBroker call the TorqueInstance for checking the Connection support transaction. >Because the TorqueInstance doesn't initialize yet, it always set false even the connection support transaction. > >2005-06-23 23:31:14,609 [main] DEBUG org.apache.torque.TorqueInstance - init(org.apache.commons.configuration.CompositeConfiguration@1c6a99d) >2005-06-23 23:31:14,609 [main] DEBUG org.apache.torque.TorqueInstance - setConfiguration(org.apache.commons.configuration.CompositeConfiguration@1c6a99d) >2005-06-23 23:31:14,609 [main] DEBUG org.apache.torque.TorqueInstance - initialize() >2005-06-23 23:31:14,625 [main] DEBUG org.apache.torque.TorqueInstance - setConfiguration(org.apache.commons.configuration.SubsetConfiguration@1a9876e) >2005-06-23 23:31:14,625 [main] DEBUG org.apache.torque.TorqueInstance - initAdapters(org.apache.commons.configuration.SubsetConfiguration@1a9876e) >2005-06-23 23:31:14,718 [main] DEBUG org.apache.torque.TorqueInstance - Adding mysql -> easydesk as Adapter >2005-06-23 23:31:14,718 [main] DEBUG org.apache.torque.TorqueInstance - initDataSourceFactories(org.apache.commons.configuration.SubsetConfiguration@1a9876e) >2005-06-23 23:31:14,718 [main] DEBUG org.apache.torque.TorqueInstance - handle: easydesk DataSourceFactory: org.apache.torque.dsfactory.SharedPoolDataSourceFactory >2005-06-23 23:31:14,828 [main] DEBUG org.apache.torque.TorqueInstance - getConfiguration() = org.apache.commons.configuration.SubsetConfiguration@1a9876e >2005-06-23 23:31:14,828 [main] DEBUG org.apache.torque.dsfactory.AbstractDataSourceFactory - Starting initCPDS >2005-06-23 23:31:14,843 [main] DEBUG org.apache.torque.TorqueInstance - getConfiguration() = org.apache.commons.configuration.SubsetConfiguration@1a9876e >2005-06-23 23:31:14,843 [main] DEBUG org.apache.torque.dsfactory.AbstractDataSourceFactory - applyConfiguration(org.apache.commons.configuration.SubsetConfiguration@135da43, org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS@8c7be5) >2005-06-23 23:31:14,843 [main] DEBUG org.apache.torque.dsfactory.AbstractDataSourceFactory - applyConfiguration(org.apache.commons.configuration.SubsetConfiguration@11a0d35, org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS@8c7be5) >2005-06-23 23:31:14,890 [main] DEBUG org.apache.torque.dsfactory.AbstractDataSourceFactory - setSimpleProperty(org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS@8c7be5, driver, org.gjt.mm.mysql.Driver) >2005-06-23 23:31:14,906 [main] DEBUG org.apache.torque.dsfactory.AbstractDataSourceFactory - setSimpleProperty(org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS@8c7be5, url, jdbc:mysql://localhost:3306/easydesk?zeroDateTimeBehavior=round&useNewIO=true) >2005-06-23 23:31:14,906 [main] DEBUG org.apache.torque.dsfactory.AbstractDataSourceFactory - setSimpleProperty(org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS@8c7be5, user, root) >2005-06-23 23:31:14,906 [main] DEBUG org.apache.torque.dsfactory.AbstractDataSourceFactory - setSimpleProperty(org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS@8c7be5, password, (value not logged)) >2005-06-23 23:31:14,906 [main] DEBUG org.apache.torque.dsfactory.SharedPoolDataSourceFactory - Starting initJdbc2Pool >2005-06-23 23:31:14,937 [main] DEBUG org.apache.torque.TorqueInstance - getConfiguration() = org.apache.commons.configuration.SubsetConfiguration@1a9876e >2005-06-23 23:31:14,937 [main] DEBUG org.apache.torque.dsfactory.AbstractDataSourceFactory - applyConfiguration(org.apache.commons.configuration.SubsetConfiguration@1015a9e, org.apache.commons.dbcp.datasources.SharedPoolDataSource@1e45a5c) >2005-06-23 23:31:14,937 [main] DEBUG org.apache.torque.dsfactory.AbstractDataSourceFactory - applyConfiguration(org.apache.commons.configuration.SubsetConfiguration@e8606c, org.apache.commons.dbcp.datasources.SharedPoolDataSource@1e45a5c) >2005-06-23 23:31:14,984 [main] DEBUG org.apache.torque.dsfactory.AbstractDataSourceFactory - setSimpleProperty(org.apache.commons.dbcp.datasources.SharedPoolDataSource@1e45a5c, maxActive, 60) >2005-06-23 23:31:14,984 [main] DEBUG org.apache.torque.dsfactory.AbstractDataSourceFactory - setSimpleProperty(org.apache.commons.dbcp.datasources.SharedPoolDataSource@1e45a5c, maxWait, 30000) >2005-06-23 23:31:14,984 [main] DEBUG org.apache.torque.dsfactory.AbstractDataSourceFactory - setSimpleProperty(org.apache.commons.dbcp.datasources.SharedPoolDataSource@1e45a5c, testOnBorrow, true) >2005-06-23 23:31:14,984 [main] DEBUG org.apache.torque.dsfactory.AbstractDataSourceFactory - setSimpleProperty(org.apache.commons.dbcp.datasources.SharedPoolDataSource@1e45a5c, timeBetweenEvictionRunsMillis, -1) >2005-06-23 23:31:14,984 [main] DEBUG org.apache.torque.dsfactory.AbstractDataSourceFactory - setSimpleProperty(org.apache.commons.dbcp.datasources.SharedPoolDataSource@1e45a5c, validationQuery, SELECT 1) >2005-06-23 23:31:15,000 [main] DEBUG org.apache.torque.TorqueInstance - Adding a dummy entry for default, mapped onto easydesk >2005-06-23 23:31:15,062 [main] DEBUG org.apache.torque.TorqueInstance - getConfiguration() = org.apache.commons.configuration.SubsetConfiguration@1a9876e >2005-06-23 23:31:15,078 [main] ERROR org.apache.torque.oid.IDBroker - org.apache.torque.TorqueException: Torque is not initialized. >2005-06-23 23:31:15,078 [main] WARN org.apache.torque.oid.IDBroker - IDBroker is being used with db 'easydesk', which does not support transactions. IDBroker attempts to use transactions to limit the possibility of duplicate key generation. Without transactions, duplicate key generation is possible if multiple JVMs are used or other means are used to write to the database. >2005-06-23 23:31:15,109 [Torque - ID Broker thread] DEBUG org.apache.torque.oid.IDBroker - IDBroker thread was started. >2005-06-23 23:31:17,703 [main] INFO org.apache.torque.TorqueInstance - Added Manager for Class: com.nannet.jettiger.om.JettigerUser -> com.nannet.jettiger.om.JettigerUserManager >2005-06-23 23:31:17,781 [main] DEBUG org.apache.torque.TorqueInstance - getConfiguration() = org.apache.commons.configuration.SubsetConfiguration@1a9876e >2005-06-23 23:31:17,781 [main] DEBUG org.apache.torque.TorqueInstance - initialize finished > > >I could solved this problem by moving initialize finish flag set true >when after dataSourceFactory initialize not completely finished the TorqueInstance. > >[youngho@dev db-torque]$ cvs diff src/java/org/apache/torque/TorqueInstance.java >Index: src/java/org/apache/torque/TorqueInstance.java >=================================================================== >RCS file: /home/cvspublic/db-torque/src/java/org/apache/torque/TorqueInstance.java,v >retrieving revision 1.11 >diff -r1.11 TorqueInstance.java >149a150,151 > > --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org