@CollectionOfElements and @OnDelete

rletness · **Joined:** Tue Nov 28, 2006 2:37 pm **Posts:** 7

Is there any way to configure a @CollectionOfElements association so that SchemaExport will generate "on delete cascade" for the FK constraint on the associated table?

For example:

@CollectionOfElements
@JoinTable(
name="multistring_values",
joinColumns = @JoinColumn(name="attributeid")
)
@Column(name="stringvalue", length=2048)
@OnDelete(action=OnDeleteAction.CASCADE)
public Set<String> getValue() {
return this.value;
}

This results in "only inverse one-to-many associations may use on-delete="cascade"" error message. Ideally I want the associated rows in "multistring_values" table to be removed when the entity containing the collection assocation is removed (without having hibernate issue a separate sql delete).

-Randy

QStorm · **Joined:** Thu Jun 08, 2006 5:32 pm **Posts:** 52

I have the same problem.
Is it possible to define cascade for a @CollectionOfElements via annotations?

I have the following situation (only an example):

Code:

@Entity
public class Person {
   // ...
   @CollectionOfElements(fetch = FetchType.LAZY)
   private Map<Pet, Integer> pets; // Key: Pet, Value: amount
   // ...

All Pets should be removed when the Person will be removed.
Thanks :)

Best regards
QStorm