Hi Everyone,

Recently we changed our tables from MyISAM to InnoDB, we found the foreign keys were not correctly created. I thought this solved the problem. I changed to InnoDB by altering the
<property name="hibernate.dialect">org.hibernate.dialect.MySQLInnoDBDialect</property>

<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>

from the hibernate.cfg.cml.

Now that we need to load the data ASAP the database tables are not accessible. Within the /data directory only one *.frm file exists for each table. Whereas using MyISAM we had *.frm, *.MYD and *.MYI file extensions for each table.

We are using MySQL 5 within eclipse. I am fairly new to Hibernate and Databases please comment if you can help. If there is something I forgot to change to alter the tables to work correctly with InnoDB please let me now.

This is another small question I have whenever i try to open my database through hibernate configurations (of hibernate tools) it says duplicate mapping exception. But if I take out the mapping files from hibernate.cfg.xml my code won't run. If i block out the mapping files i can see the tables etc. Any suggestions?

Regards, Alyssa.

Did you only do that to convert from isam to innodb : change the dialect ? If yes, I'd say it's totally normal... Doing this is not converting your db, you must do this from the mysql admin console. Here, you're just saying to Hibernate that the db is an innodb one, but, if you didn't convert from mysql directly, it's not.

Thanks for your reply!!

Is this an example? [url]http://software.newsforge.com/article.pl?sid=05/07/13/1513211&tid=72
[/url]

I checked the database and the default storage engine is set to InnoDB.

I also noticed within my my.ini there is a line #skip-innodb, could this be causing my problems?

SO in summary I haven't been able to get my foreign keys working when setting the dialect to MySQLMyISAMDialect. When I set the dialect to MySQLInnoDBDialect foreign keys okay but i don't get all the database files for each table ONLY the *.frm files as mentioned previously.

The database type is a multifunctional database.

Please offer suggestions if you can help, this trivial problem is irritating!

Regards, Alyssa.

I recently found out that this is okay, the InnoDB engine only requires a .FRM file for each table and one ibdata file. Another database backup file was created and dumped into the database it and worked.