How do you create a Distinct query in HQL

by

Here’s a snippet of hql that we use. (Names have been changed to protect identities)

String queryString = "select distinct f from Foo f inner join foo.bars as b" +
                " where f.creationDate >= ? and f.creationDate < ? and b.bar = ?";
        return getHibernateTemplate().find(queryString, new Object[] {startDate, endDate, bar});

More Related Contents:

  1. Criteria.DISTINCT_ROOT_ENTITY vs Projections.distinct
  2. Performing Date/Time Math In HQL?
  3. how to return Map with HQL
  4. Date operations in HQL
  5. New object with HQL
  6. How to simulate NVL in HQL
  7. How do you do a limit query in JPQL or HQL?
  8. Hibernate: Difference between session.get and session.load
  9. Hibernate: one-to-one lazy loading, optional = false
  10. JPA and Hibernate – Criteria vs. JPQL or HQL
  11. How to use Spring managed Hibernate interceptors in Spring Boot?
  12. @OrderColumn annotation in Hibernate 3.5
  13. How to query data for Primefaces dataTable using lazy loading and pagination
  14. Spring Boot & Spring Data: how are Hibernate Sessions managed?
  15. Hibernate – why use many-to-one to represent a one-to-one?
  16. Hibernate Named Query Order By parameter
  17. Hibernate: How specify custom sequence generator class name using annotations?
  18. Spring Data JPA – Pass column name and value as parameters
  19. Invalidating JPA EntityManager session
  20. How to generate a ddl creation script with a modern Spring Boot + Data JPA and Hibernate setup?
  21. HQL left join of un-related entities
  22. How is Hibernate deciding order of update/insert/delete
  23. Hibernate inserts duplicates into a @OneToMany collection
  24. HQL – row identifier for pagination
  25. Hibernate validator: @Email accepts ask@stackoverflow as valid?
  26. Hibernate hbm2ddl.auto, possible values, and what they do
  27. In Spring with jpa/hibernate, how do I keep a session open to avoid lazy initialization exceptions?
  28. Should Hibernate be able to handle overlapping foreign keys?
  29. Inserting data in one table using HQL in Hibernate
  30. Hibernate IN Clause with multiple columns

Leave a Comment