How to add Distinct in Hibernate Criteria

by

Use Projections.distinct.

Criteria crit = session.createCriteria(Test.class).setProjection(
    Projections.distinct(Projections.projectionList()
    .add(Projections.property("type"), "type") )
.setResultTransformer(Transformers.aliasToBean(YourBean.class)); 

List lst = crit.list();

where YourBean.class has a property “type”. The returned list will be List<YourBean>.

More Related Contents:

  1. having an exception when saving oracle type object in some entity
  2. org.hibernate.HibernateException: Access to DialectResolutionInfo cannot be null when ‘hibernate.dialect’ not set
  3. How to print a query string with parameter values when using Hibernate
  4. When and why JPA entities should implement the Serializable interface?
  5. Hibernate openSession() vs getCurrentSession()
  6. JPA and Hibernate – Criteria vs. JPQL or HQL
  7. Getting Database connection in pure JPA setup
  8. How to solve circular reference in json serializer caused by hibernate bidirectional mapping?
  9. annotation to filter results of a @OneToMany association
  10. Hibernate/JPA – annotating bean methods vs fields [duplicate]
  11. Postgresql UUID supported by Hibernate?
  12. Hibernate, iBatis, Java EE or other Java ORM tool
  13. How can I use hibernate with MS Access?
  14. How to transform a flat result set using Hibernate
  15. Can’t parse hibernate.cfg.xml while offline
  16. Spring 3.1 Hibernate 4 exception for Inheritance [cannot be cast to org.hibernate.mapping.RootClass]
  17. Java SE + Spring Data + Hibernate
  18. Does Hibernate Fully Support SQLite
  19. How to use Hibernate @Any-related annotations?
  20. Hibernate: How to fix “identifier of an instance altered from X to Y”?
  21. Create the perfect JPA entity [closed]
  22. Delete Not Working with JpaRepository
  23. Disabling contextual LOB creation as createClob() method threw error
  24. Deprecated createCriteria method in Hibernate 5
  25. How to turn off hbm2ddl?
  26. HQL left join of un-related entities
  27. What properties does @Column columnDefinition make redundant?
  28. org.hibernate.loader.MultipleBagFetchException: cannot simultaneously fetch multiple bags
  29. JPA Updating Bidirectional Association
  30. Autowired Repository is Null in Custom Constraint Validator

Leave a Comment