Hello, Thanks. I will check it out.
Youngho ----- Original Message ----- From: "Dan Cooper" <[EMAIL PROTECTED]> To: "Apache Torque Users List" <[email protected]> Sent: Thursday, June 30, 2005 7:38 AM Subject: Re: MySql InnoDB question > 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([EMAIL PROTECTED]) > >2005-06-23 23:31:14,609 [main] DEBUG org.apache.torque.TorqueInstance - > >setConfiguration([EMAIL PROTECTED]) > >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([EMAIL PROTECTED]) > >2005-06-23 23:31:14,625 [main] DEBUG org.apache.torque.TorqueInstance - > >initAdapters([EMAIL PROTECTED]) > >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([EMAIL PROTECTED]) > >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() = [EMAIL PROTECTED] > >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() = [EMAIL PROTECTED] > >2005-06-23 23:31:14,843 [main] DEBUG > >org.apache.torque.dsfactory.AbstractDataSourceFactory - > >applyConfiguration([EMAIL PROTECTED], [EMAIL PROTECTED]) > >2005-06-23 23:31:14,843 [main] DEBUG > >org.apache.torque.dsfactory.AbstractDataSourceFactory - > >applyConfiguration([EMAIL PROTECTED], [EMAIL PROTECTED]) > >2005-06-23 23:31:14,890 [main] DEBUG > >org.apache.torque.dsfactory.AbstractDataSourceFactory - > >setSimpleProperty([EMAIL PROTECTED], driver, org.gjt.mm.mysql.Driver) > >2005-06-23 23:31:14,906 [main] DEBUG > >org.apache.torque.dsfactory.AbstractDataSourceFactory - > >setSimpleProperty([EMAIL PROTECTED], 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([EMAIL PROTECTED], user, root) > >2005-06-23 23:31:14,906 [main] DEBUG > >org.apache.torque.dsfactory.AbstractDataSourceFactory - > >setSimpleProperty([EMAIL PROTECTED], 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() = [EMAIL PROTECTED] > >2005-06-23 23:31:14,937 [main] DEBUG > >org.apache.torque.dsfactory.AbstractDataSourceFactory - > >applyConfiguration([EMAIL PROTECTED], [EMAIL PROTECTED]) > >2005-06-23 23:31:14,937 [main] DEBUG > >org.apache.torque.dsfactory.AbstractDataSourceFactory - > >applyConfiguration([EMAIL PROTECTED], [EMAIL PROTECTED]) > >2005-06-23 23:31:14,984 [main] DEBUG > >org.apache.torque.dsfactory.AbstractDataSourceFactory - > >setSimpleProperty([EMAIL PROTECTED], maxActive, 60) > >2005-06-23 23:31:14,984 [main] DEBUG > >org.apache.torque.dsfactory.AbstractDataSourceFactory - > >setSimpleProperty([EMAIL PROTECTED], maxWait, 30000) > >2005-06-23 23:31:14,984 [main] DEBUG > >org.apache.torque.dsfactory.AbstractDataSourceFactory - > >setSimpleProperty([EMAIL PROTECTED], testOnBorrow, true) > >2005-06-23 23:31:14,984 [main] DEBUG > >org.apache.torque.dsfactory.AbstractDataSourceFactory - > >setSimpleProperty([EMAIL PROTECTED], timeBetweenEvictionRunsMillis, -1) > >2005-06-23 23:31:14,984 [main] DEBUG > >org.apache.torque.dsfactory.AbstractDataSourceFactory - > >setSimpleProperty([EMAIL PROTECTED], 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() = [EMAIL PROTECTED] > >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() = [EMAIL PROTECTED] > >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. > > > >[EMAIL PROTECTED] 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: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED]
