MySQL InnoDB Database

jpgr · **Joined:** Wed Sep 10, 2003 7:09 am **Posts:** 63

Hi,

I am using Hibernate 2.1 with MySQL and i am generating my tables with the Schema Export.

I am using transactions and the tables created by the tool do not support transactions. What changes should I make in the map file, for Hibernate create innoDB tables??

Thanks,
Joao Rangel

paan · **Posted:** Tue Oct 14, 2003 4:47 pm

I think you just add TYPE=InnoDB after table declaration.

Code:

CREATE TABLE `...` (
    ......
    ......
) TYPE=InnoDB

Hope this help.

MCWelch · **Joined:** Mon Sep 29, 2003 3:10 pm **Posts:** 36

I believe that he's asking what attribute or tag he needs to add to Hibernate mapping files so that the DDL generated from those mapping files will create transaction aware (i.e. InnoDB) tables in MySQL.

This is a good question and one I'd be curious to know the answer to as well.

-Matt

christian · **Posted:** Tue Oct 14, 2003 5:27 pm

http://forum.hibernate.org/old//809065.html

http://forum.hibernate.org/old//856390.html

You can also easily modify the dialect (or create a new one) or ...

MCWelch · **Joined:** Mon Sep 29, 2003 3:10 pm **Posts:** 36

Thanks, Christian!

-Matt