Hello all!
I used this for my implementation of manytomany (bidirectional):
http://tadtech.blogspot.com/2007/09/hib ... in_03.htmlBut now, if I want to delete an address which is connected to a person via the table PersonAddress, I get this error:
Quote:
Cannot delete or update a parent row: a foreign key constraint fails (`mydb`.`PersonAddress`, CONSTRAINT `...` FOREIGN KEY (`addressId`) REFERENCES `ADDRESS` (`id`))
What's wrong here? It seems that it can not delete the address because it is still connected to a person.
How to solve this?
Thanks a lot in advance & Best Regards.