Deleting child entries in a one-to-many relationship

davout Apr 18, 2004 10:30 AM

In situation where a parent entity has a one-to-many CMP/CMR relationship to a child entity, is there a quick way to delete all child entity data instances without deleting the parent entity?

I thought I read somewhere that you could use the parent entity field representing the child entity container method and call its 'clear' method but this doesn't seem to work.

1. Re: Deleting child entries in a one-to-many relationship

triathlon98 Apr 18, 2004 11:58 AM (in response to davout)

You just have to remove the items from the collection. This will remove the link at the DB level. However, this will probably generate one SQL statement for each link which is being cut.

Joachim
Actions
2. Re: Deleting child entries in a one-to-many relationship

davout Apr 18, 2004 12:05 PM (in response to davout)

You mean like...

aParent.getChildren().clear();

... or what?

I've tried that and the child DB entries are not deleted.

"triathlon98" wrote:
You just have to remove the items from the collection. This will remove the link at the DB level. However, this will probably generate one SQL statement for each link which is being cut.

Joachim
Actions

Go to original post