Hello, I read TRQ278 for InnoDB related Issue. It is about create tables and fk relations issue. In my case, when I create tables using generated sql from xml. I set SET FOREIGN_KEY_CHECKS=0; before execute the sql. Than there is no complain.
My problem is I would like to use transaction but the warn report said torque doesn't use transaction. I use connector/j-3.1.7 driver. Do I have to ask it to mysql driver mailling list ? How you use torque with InnoDB ? Thanks. Youngho ----- Original Message ----- From: "Thomas Fischer" <[EMAIL PROTECTED]> To: "Apache Torque Users List" <[email protected]> Sent: Wednesday, June 22, 2005 3:51 PM Subject: RE: MySql InnoDB question > > > > > Hi, > > this message is usually the sign that something else is wrong. Most > probably, Torque will not work correctly if you see this message. > There is at least one unresolved issue with InnoDB tables, it should be in > scarab (the issue tracker) with a ticket id between TRQS250 and TRQS300. > Please have a look. > > Thomas > > "Youngho Cho" <[EMAIL PROTECTED]> schrieb am 22.06.2005 02:23:27: > > > Hello, > > > > I am tring to use MySQL 4.1 InnoDB table type. > > I install MySQL 4.1.12 (using InnoDB engine mode ) in Window XP and > Torque 3.1 > > After create db with torque and changed the all table type to innoDB > > type with mysql admin client > > > > But when I start the torque, > > I got the following warn message > > > > 2005-06-21 18:38:48,936 [Torque - ID Broker thread] DEBUG org. > > apache.torque.oid.IDBroker - IDBroker thread was started. > > 2005-06-21 18:38:48,941 [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. > > > > I notice that when this message show, torque doesn't use transaction. > > How do I set the torque use transaction with MySQL InnoDB type ?? > > > > Thanks. > > > > Youngho > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED]
