Hi,

I'm facing this quirky issue with hibernate schema update. Our database tables used to be of the MyIASM table type which do not support foreign keys. However after converting them to InnoDB, the foreign keys are not automatically created by schema update. The are no errors in the log file... it just seems to be ignoring them. Yes schema update is turned on... it will successfully create new columns. I can successfully create a foreign key manually with Navicat. If I create a new database and allow hibernate to generate the DDL, the foreign keys are there! It just seems to affect the databases with tables that we converted to InnoDB.

Any ideas on how to fix this would be much appreciated!!

The issue had to do with there being indexes in the tables that were the same name as the foreign keys would be. After removing all those indexes, I was able to create the foreign keys.