Hi,
i have a problem with merging of detached entities. I have a Text-Object that contains Sentence Objects which in turn contain words. Now I don't want to have double entries of certain words but rather e.g. persisting "This car is his car" should not add two times "car" into the DB. I tried using the EntityManager.merge method and have Cascading turned on (CascadeStyle.MERGE) for the relationship and I can see some attempted selects. However I get EntityExists exceptions with that... So I tried the same without the hirarchy by just persisting the same word multiple times (via merge) and that worked. So I conclude there is something wrong with the Cascading settings. I use Hibernate Entity Manager 3.2.0CR1 along with Annotations 3.2.0 CR1.
Any clues on this?
THanks,
Joey

Hi,
so i found the problem but no solution. The problem is that the foreign key of the referenced "Word" is inside the Join-Table marked as unique, which I switched manually to index.
Anyone got any clues on how I can avoid the word_content being unique in the join table? Thanks!!

[code]

@OneToMany
@JoinTable(name="sentence_word",
joinColumns={@JoinColumn(name="sentence_id")},
inverseJoinColumns={@JoinColumn(name="word_content",referencedColumnName="content")})

/**
* @return the words
*/
public Collection<Word> getWords() {
return words;
}
[/code]

@ManyToMany