When deleting an object (an Order containing OrderLines), I get the following exception from a constraint in the OrderLines table:

#23000Cannot delete or update a parent row: a foreign key constraint fails (`testapp/tblOrderLines`, CONSTRAINT `FK10FBF332C4A97B1D` FOREIGN KEY (`OrderId`) REFERENCES `tblOrders (`OrderId`))

In my mapping below, besides the "normal" bag parent/child relation, I also have an opposite relation from the OrderLine to the Order, so I can access the Order from the OrderLine, which causes the constraint to be created.

I use the SchemaExport tool to generate the MySQL tables, but I can see in the MySQL table that it has generated foreign keys with "On Delete" constraint set to "Restrict", so a Delete operation on the Order object will always fail. How can I change this constraint to "No action" or "Cascade"?

Do I miss something in my mapping for this? I tried to set all kinds of cascade-options in the mapping with no difference.

I use NHibernate 1.02

you said you tried all sorts of cascade options, did you do all-delete-orphan?



same error?

hmm.. yes, I also tried that with same result.

Actually I don't think it is related to the bag in the Order object, but rather the many-to-one relation in the OrderLines object, because if I remove this relation completely, it doesn't make any Foreign key in the table at all.

So I would believe that the many-to-one relation should have an option that controls/disable the constraints, but it doesn't allow me to set any cascade-options on this type of relation.

any ideas? Are there any new/upcoming mapping tools available which could help on clarifying this?

would it help if I posted a fully working test-application? (the code I posted was just a very simplified version of my actual case)

Hi I have experienced the same problem however I have a recursive relationship but still parent/child.

Did you solve this?

Thanks
Glenn