Hi there,

I am using hibernate 2.1 in a webapp running in Tomcat and MySQL 4.0.14 (MyISAM) for persistent storage. My questions is, I used SchemaExport to generate all relational schemas - without any errors. However, the ForeignKey constraints added by hibernate seem to be ignored by the DBMS. No cascade options work for me :(

I would very much like to use Collections of Objects (BusinessObjects) and cascade any save but can't seem to get it to work. Any ideas? Is this something to do with me using the MyISAM storage engine of MySQL?

THX, Jan

MySQL supports proper foreign key constraints only with INNODB tables and some other restrictions also apply:

http://www.mysql.com/doc/en/InnoDB_foreign_key_constraints.html

The "cascade" option in Hibernate is something different. You need it to cascade operations from one entity to other entities. Read the "Parent/Child Relationship" chapter in the documentation and start reading here:

http://www.hibernate.org/ForumMailinglists/HowToAskForHelp