Hello All,

Currently, I encounter a few issues between MySQL 5.1 and Hibernate 3.
I will mention 2 first. They are:

• During hbm2ddl auto creation, all the cascade value in the Foreign Keys for On Delete and On Update is Restrict even when I put "all" and other values (E.g. delete-orphan) for the cascade attribute.
  In another words, I need to manually set the On Delete and On Update to Cascade.
• I have simple 2 tables design. When hibernate delete a row from the parent table, not all rows in the child table related to the parent row are deleted. And for these not deleted child rows, the foreign keys are set to null by hibernate. I used the getHibernateTemplate().delete(...) method. Currenly, the only way to resolve this is to create child data objects(bean) with the childs primary key and set them into the data object of the parent row.
  However, when I use MySQL Query Browser, I only need to delete a row from the parent table to delete all the child rows.

Please advise.

Thanks.

Did you get any luck with this? I created my own Dialect as suggested on another post as so:



In my case it still doesn't work but if it can get if to work for you, great. Otherwise if you found the solution please let me know

Francois