delete child rows using hibernate. (cascade?)

[Leandro Coutinho]

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?

@ManyToMany(mappedBy="questions")
@JoinTable(name="question_test",
		joinColumns={@JoinColumn(name="questions_id")},
		inverseJoinColumns={@JoinColumn(name="tests_id")})
private List<Test> tests;

[David Coelho]

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.

 
	anyTest.getQuestions().remove(questionX);

[Leandro Coutinho]

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.

loopTeste:
	for(Teste t:questao.getTestes()) {
		for(int i = 0; i < t.getQuestoes().size(); i++) {
			if(questao.equals(t.getQuestoes().get(i))) {
				t.getQuestoes().remove(i);
				daoTeste.saveOrUpdate(t);
				break loopTeste;
			}
		}
	}
daoQuestao.delete(questao);

override equals in question:

public boolean equals(Object o) {
	if(o instanceof Questao && 
			this.getId() == ((Questao)o).getId())
		return true;
	return false;
}