delete child rows using hibernate. (cascade?)
posted 16 years ago
-
-
Number of slices to send:Optional 'thank-you' note:
-
-
hi all!
Suppose I have many-to-many relationship between question and test. Then I add some questions to a test.
So when I try to delete one of that questions, I get:
Cannot delete or update a parent row: a foreign key constraint fails (`sgc/test_question`, CONSTRAINT `FK75EC6E24266D1387` FOREIGN KEY (`questions_id`) REFERENCES `question` (`id`))
Is there some annotation to do this?
Does someone knows how can I manage do delete the child rows before delete the question?
Suppose I have many-to-many relationship between question and test. Then I add some questions to a test.
So when I try to delete one of that questions, I get:
Cannot delete or update a parent row: a foreign key constraint fails (`sgc/test_question`, CONSTRAINT `FK75EC6E24266D1387` FOREIGN KEY (`questions_id`) REFERENCES `question` (`id`))
Is there some annotation to do this?
Does someone knows how can I manage do delete the child rows before delete the question?
posted 16 years ago
-
- Number of slices to send:Optional 'thank-you' note:
-
-
Hi Leandro,
When you remove the Question, the Hibernate Session doesn't have knowledge of all entities (attached and detached) that has a reference to the removed Question.
You just has to remove the Question of Test manually.
When you remove the Question, the Hibernate Session doesn't have knowledge of all entities (attached and detached) that has a reference to the removed Question.
You just has to remove the Question of Test manually.
Leandro Coutinho
Ranch Hand
Posts: 430
posted 16 years ago
-
- Number of slices to send:Optional 'thank-you' note:
-
-
Thanks David!
well ... I still think that hibernate can do it for me xD. I have to learn how to use cascade annotation.
but meanwhile I did what you recomended and it is working.
override equals in question:
well ... I still think that hibernate can do it for me xD. I have to learn how to use cascade annotation.
but meanwhile I did what you recomended and it is working.
override equals in question:
| It's feeding time! Give me the food you were going to give to this tiny ad: Paul Wheaton's 16th Kickstarter: Gardening playing cards for gardeners and homesteaders https://coderanch.com/t/889615/Paul-Wheaton-Kickstarter-Gardening-playing |