db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Youngho Cho" <youn...@nannet.co.kr>
Subject Re: MySql InnoDB question
Date Wed, 22 Jun 2005 23:24:48 GMT
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" <fischer@seitenbau.net>
To: "Apache Torque Users List" <torque-user@db.apache.org>
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" <youngho@nannet.co.kr> 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: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
Mime
View raw message