Hello,

Using Hibernate 3.2 and trying to form HQL left joins to load collection fields along with the target object. My queries are working fine using the where clause, ordering, etc, until I start using the "left join" command and then I start getting multple entries of the same object back in my query results list.

Am I doing something wrong?

This HQL query returns one Usrprofile object as I would expect:


as there is only one "johndoe" in my Usrprofile table. However, when I try to also load one of Usrprofiles properties that is an association to another table/class using the left join, I get 6 records back. In this case, I am trying to get the single Usrprofile object for "johndoe" as well as all "Usrmsgs" associated with this user, using the following HQL:



All the six objects from the second HQL line are identical.

Any help or thougths you have on this would be a great help.

Thanks,

-Matt

You are not doing anything wrong however you need to be aware of the following:



This is from http://www.hibernate.org/hib_docs/v3/reference/en/html_single/#objectstate-querying-executing

I hope that helps

Thanks for the pointer simon_t. I did find this text in the reference guide:



How does one do this filtering through a Set? Are we talking about programmatic filtering that compares objects in the returned Set?

Thanks,

-Matt

Hi,

There is method uniquereasult() on Query object. It will filter out unique objects for you.

Or if you are using Criterias

then use


setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);