Basically, I have a one-to-many relationship between Parent and Children. The Parent has a map whose values are Child objects. The relationship is bidirectional, inverse=true, cascade=all-delete-orphan in Parent.hbm.xml and not-null=true in Child.hbm.xml.
I am using Spring's HibernateTemplate.

I am trying to re-assign all children from Parent p1 to Parent p2:

[... get all children from p1 ..]

child1.setParent(p2);
child2.setParent(p2);
[ .. etc. ..]
hibernateTemplate.saveOrUpdate(p1);

Also, I clear the map in p1 that contains child1, child2, etc.

Then, I need to delete p1 because it is empty now (no children):

hibernateTemplate.delete(p1);
hibernateTemplate.flush();

At this point, I get an exception:

org.springframework.orm.hibernate3.HibernateObjectRetrievalFailureException: deleted object would be re-saved by cascade (remove deleted object from associations)

I don't understand why it's happening. I would think the child
objects would all be pointing to the new parent at that time.

Any help would be greatly appreciated.

do you also bind children to parent2 i.e.

Yes, I do.

I am confused here - you are moving them from p1 to p2, so wht would you want to delete p2? Secondly I would not saveOrUpdate p1 until you have removed the children from p1 which you don't appear to have done. The process would be as follows:
1) Get all children of p1
2) remove each child (or the collection) from p1
3) remove the parent reference in each child from p1 and change to p2
4) set each child to reference p2
5) save/update/delete (if you want to) p1
6) save/update p2

Or have I missed something here?

Good luck!

S[/list]

It's a typo, I meant to say I need to delete p1, not p2.
I'll try to double-check all steps. Thanks.

I think I got it to work now. Thanks everyone for help.

how did you resolve it? i have the same situation and the same problem

thanks

I think I ended up writing a separate method that goes through all parent objects and deletes those that don't have children any more.