Hibernate version:3.2

Hey all

I'm having some difficulties with a HQL statement. I am trying to fetch a collection for a movie with the following query:



The problem is that it will return a list of 56 movies instead of just one unique result. The movie in question has 56 comments so I'm guessing Hibernate returns one Movie for each Comment the movie has. If I leave out the "left join fetch m.comments" I will receive a unique result. The list of the 56 movies all have their comments initialized so it is fetching the collection properly, but why is it returning 56 results?

mapping:



Thanks!

You don't actually need the join to Comments in that statement. Hibernate will magicaly do it for you.

no actually it doesn't. You'll need the fetch statement for Hibernate to initialize the collection, when left out it will return the comments as a separate collection alongside the movie.

With lazy-loading (the clue's in the name), I'm pretty sure your collection of comments will be got when you call a movies .getComments() method.

It is because you are using left outer join. To fix you problem just add the results to a set and make sure that Movie implements equals and hashCode