• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

select new constructor in JPA/Hibernate with DISTINCT NOT WORK!

 
nimo frey
Ranch Hand
Posts: 580
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have something like:



this works only, if I delete the distinct-keyword from my Constructor. But I need that!

How can I do that, with using the "select new".
 
Jose Ayerdis
Ranch Hand
Posts: 30
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
why don you try it like this:

select distinct age from myObjects.User user


http://www.hibernate.org/hib_docs/reference/en/html/queryhql-aggregation.html

PD: what does d mean there
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic