Hello,

I am using a left join fetch in my HQL for improved performace.
It returns duplicate records because of the left join fetch since hibernate generates a left outer join (i am using distinct).Is there a way to avoid the duplicate records other than using Hibernate.initialize(obj) call.
I want to avoid Hibernate.initialize(obj) because it fires a query each time Hibernate.initialize(obj) is called.

String hql = "select distint a from A left join fetch a.B b where ....";
This generates a query as :
select distinct a.*, b.* from A a left outer join B b on ....
where ....

How can make hibernate generate
select distinct a.* from A a left outer join B b on ....
where ....

Thanks,
Gayatri

For better understanding you need to post your mapping files and relation of the objects.
For distinct you can use uniqueResults on the query object.

Take a look at the following Hibernate FAQ link. It answers your question.

http://web.archive.org/web/200702021455 ... 7.html#A12


-BJ

Thanks for the replies.

Query.uniqueResultSet() works if there is only 1 object in the resultset, but in my scenario I have multiple objects returned. With a left join fetch it was returning duplicates i.e if I expect my resultset to be [1, 2, 3], it would return [1, 1, 2, 3, 3].
I resolved this issue by using
query.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);

Thanks,
Gayatri