Hi
I have a Hiberanate query

return getSession().find(select s.brCode, sa.id, sc.status sa.valid from BranchPOJO s join s.XYZs sa join sa.ABCs sab join sab.EFGs where
+ someclause);
(someclause is the where clause --- generated from the fields selected from the screen)

My issue is the result has duplicates in it

each row is fetched 6 times
can anyone point me to the solution?


My data model
|----- - - -SIN--------------------------------------------------------------|
| |
|----<-LOC- - ---<-EFG->--- - -ABC>--- - -XYZ >--- - -Branch->----|

Your data model doesn't come out well in your question.
In any case, when you have joins, all tables involved except the lowest-level one are bound to have repeated values.
Play adding more or less conditions to your "where" condition. Also play with the joins, doing more or less joins to check at what point you start getting duplicate values.

Dump the find() method; it's useful for simple stuff, but lacks any power. Upgrade to IQuery: much more powerful. When you do, you can use this:

query.SetResultTransformer(NHibernate.CriteriaUtil.DistinctRootEntity);


Same thing for Hibernate, but I'm sure you get the idea. It works when returning whole objects; not sure what happens when you grab properties alone.