Fetch not repeated rows in hibernate

Question

I would like to fetch a list from a query in Hibernate but without repeated elements.

Currently i have something like:

SELECT t FROM Table t join fetch t.list tl WHERE tl.userid=:userid AND tl.tableid=t.id

This works good! the problem its that it returns the same object as many times as userid its in tl

so lets say userid its found 3 times in tl i am getting:

T
  TL1
  TL2
  TL3
T
  TL1
  TL2
  TL3
T
  TL1
  TL2
  TL3

and i want to get:

T
  TL1
T
  TL2
T
  TL3

or just one:

T
  TL1
  TL2
  TL3

I guess its possible in Hibernate but havent manage it yet.

Thanks in advance

Suresh Atta · Accepted Answer · 2013-04-25 09:00:14Z

1

Do write

SELECT  distinct t FROM Table t join fetch t .......
      -----^------

HQL ORDER BY clause and DISTINCT clause will be helpful further.

answered Apr 25, 2013 at 9:00

Suresh Atta

122k38 gold badges206 silver badges315 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

cri_sys Over a year ago

That was easy, dint know the distinct stament was possible that implicit. Thanks

Suresh Atta Over a year ago

Its not that much until we know it :) happens to every one glad to help you :)

NetStarter · Accepted Answer · 2013-04-25 09:02:28Z

0

Why you don't use then DISTINCT

  SELECT DISTINCT t FROM Table t join fetch t.list tl WHERE tl.userid=:userid 
AND tl.tableid=t.id

It will give you result without the repeated values

answered Apr 25, 2013 at 9:02

NetStarter

3,2357 gold badges40 silver badges50 bronze badges

Comments

rvini · Accepted Answer · 2013-04-25 09:21:24Z

0

you could also try using Criteria.DISTINCT_ROOT_ENTITY

answered Apr 25, 2013 at 9:21

rvini

4512 gold badges4 silver badges12 bronze badges

Collectives™ on Stack Overflow

Fetch not repeated rows in hibernate

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related