java - Fetch not repeated rows in hibernate -


i fetch list query in hibernate without repeated elements.

currently have like:

select t table t join fetch t.list tl tl.userid=:userid , tl.tableid=t.id 

this works good! problem returns same object many times userid in tl

so lets userid found 3 times in tl getting:

t   tl1   tl2   tl3 t   tl1   tl2   tl3 t   tl1   tl2   tl3 

and want get:

t   tl1 t   tl2 t   tl3 

or one:

t   tl1   tl2   tl3 

i guess possible in hibernate havent manage yet.

thanks in advance

do write

select  distinct t table t join fetch t .......       -----^------ 

hql order clause , distinct clause helpful further.


Popular posts from this blog

Php - Delimiter must not be alphanumeric or backslash -

c# - How to change the "Applies To" field under folder auditing options programatically (.NET) -

c++ - Ambiguity when using boost::assign::list_of to construct a std::vector -