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]
