Hibernate Version 3.3
I am using hibernate with spring 2.0 with MySQL 5.1
I have a table ContentEntry and then Another Table ContentRating
I have annotated the ContentEntry entity like the following.

@OneToMany(fetch = FetchType.EAGER, mappedBy="entryid",targetEntity=ContentEntryRating .class)
public Set<ContentEntryRating> getContentEntryRatings() {
return contentEntryRatings;
}

The problems i find is once the ratings are persisted any lookup on ContentEntry is returning multiple copies of the same entry.
There is no duplicates in DB

I tried to use a mapping table
I tried a mapping table as well now my mapping looks like this
@OneToMany(fetch = FetchType.EAGER)
@JoinTable(
name = "T_CONTENT_RATING_MAP",
joinColumns = {
@JoinColumn( name = "CONTENT_ENTRY_FK" )
},
inverseJoinColumns = {
@JoinColumn( name = "CONTENT_RATING_FK" )
}

public Set<ContentEntryRating> getContentEntryRatings() {
return contentEntryRatings;
}


A criteria.list on a table of content_entry with a single row will return 10 elements in the list if there are 10 entries in the rating table?


Thanks in Advance for any help.

By the way i read in some docs that hibernate can't return distinct values and i need to paginate so can't use transformer..
Does this limit really exist even now?

praveengeorge, were you able to resolve this problem? I'm having a similar issue.

There's a long dissussion about how/why hibernate creates many duplicate entries in query results if an outer-join is used. This must be getting triggered for EAGER-ly loaded OneToMany and ManyToMany relations.

See: http://www.hibernate.org/117.html

My workaround is to make the mapping lazy. Changing from Bag semantics to set (use a hashset) should also work, but I haven't tried it.