Hibernate Group by Criteria Object

by

Please refer to this for the example .The main point is to use the groupProperty() , and the related aggregate functions provided by the Projections class.

For example :

SELECT column_name, max(column_name) , min (column_name) , count(column_name)
FROM table_name
WHERE column_name > xxxxx
GROUP BY column_name

Its equivalent criteria object is : 

List result = session.createCriteria(SomeTable.class)       
                    .add(Restrictions.ge("someColumn", xxxxx))      
                    .setProjection(Projections.projectionList()
                            .add(Projections.groupProperty("someColumn"))
                            .add(Projections.max("someColumn"))
                            .add(Projections.min("someColumn"))
                            .add(Projections.count("someColumn"))           
                    ).list();

More Related Contents:

  1. Hibernate show real SQL [duplicate]
  2. How to print a query string with parameter values when using Hibernate
  3. How to get SQL from Hibernate Criteria API (*not* for logging)
  4. JPA and Hibernate – Criteria vs. JPQL or HQL
  5. Hibernate Union alternatives
  6. what is the use of annotations @Id and @GeneratedValue(strategy = GenerationType.IDENTITY)? Why the generationtype is identity?
  7. How can you call custom database functions with Hibernate?
  8. How to transform a flat result set using Hibernate
  9. Hibernate Criteria Query to get specific columns
  10. How to prevent SQL Injection with JPA and Hibernate?
  11. Hibernate Criteria API: get n random rows
  12. Get column name of property mapped with Hibernate
  13. How to escape colon `:` within a native SQL query in Hibernate?
  14. Hibernate Issue : Foreign key must have same number of columns as referenced primary key
  15. Multiple queries executed in java in single statement
  16. How to fix org.hibernate.LazyInitializationException – could not initialize proxy – no Session
  17. How to execute IN() SQL queries with Spring’s JDBCTemplate effectively?
  18. What is lazy loading in Hibernate?
  19. Error creating bean with name ‘entityManagerFactory’ defined in class path resource : Invocation of init method failed
  20. What are the pros and cons of performing calculations in sql vs. in your application
  21. JPA how to make composite Foreign Key part of composite Primary Key
  22. java.lang.NoClassDefFoundError: org/hibernate/cfg/Configuration
  23. Hibernate Named Query Order By parameter
  24. Can’t parse hibernate.cfg.xml while offline
  25. How to fill up a TableView with database data
  26. How to do in-query in jDBI?
  27. Filtering out log4j messages from third-party frameworks?
  28. Hibernate saving User model to Postgres
  29. hibernate unique key validation
  30. Hibernate: Data Object with a dynamic table name by Annotations

Leave a Comment