List versus Set with @ManyToMany

nickcodefresh · **Joined:** Mon Feb 12, 2007 6:57 am **Posts:** 9

Hi all,

I have the following mapping in my persistant class:

Code:

@ManyToMany(fetch = FetchType.EAGER)
@JoinTable(name = "V_INT_HIERARCHY_INVESTMENT", joinColumns = @JoinColumn(name = "INVESTMENT_ID", referencedColumnName = "ID"), inverseJoinColumns = @JoinColumn(name = "INTERMEDIARY_ID", referencedColumnName = "ID"))
private List<IntermediaryOrganisation> hierarchyIntermediaryOrganisations;

When I save an instance of this persistant object, Hibernate attempts to delete all of the data from the V_INT_HIERARCHY_INVESTMENT mapping view, which of course, fails. If I change the type from List to Set, it all works fine (i.e. no delete is issued).

Any ideas why this is so?

Thanks

Nick

Madan_Prabhu · **Posted:** Thu Jan 08, 2009 10:04 am

becaz set is configured default for mapping.

**) specify the on delete restriction in tables ...