How do we count rows using older versions of Hibernate (~2009)?

by

For older versions of Hibernate (<5.2):

Assuming the class name is Book:

return (Number) session.createCriteria("Book")
                  .setProjection(Projections.rowCount())
                  .uniqueResult();

It is at least a Number, most likely a Long.

More Related Contents:

  1. Hibernate Annotations – Which is better, field or property access?
  2. What are the differences between the different saving methods in Hibernate?
  3. Bypass GeneratedValue in Hibernate (merge data not in db?)
  4. Ignore fields from Java object dynamically while sending as JSON from Spring MVC
  5. How should equals and hashcode be implemented when using JPA and Hibernate
  6. How does the FetchMode work in Spring Data JPA
  7. Hibernate Union alternatives
  8. Difference between @OneToMany and @ElementCollection?
  9. What is the difference between cascade & inverse in hibernate, what are they used for?
  10. Hibernate batch size confusion
  11. Transaction marked as rollback only: How do I find the cause
  12. JPA/Hibernate Static Metamodel Attributes not Populated — NullPointerException
  13. How can I use MySQL assign operator(:=) in hibernate native query?
  14. Hibernate: best practice to pull all lazy collections
  15. Do you need a database transaction for reading data?
  16. How to use multiple JOIN FETCH in one JPQL query
  17. Enum in Hibernate, persisting as an enum
  18. Mapping array with Hibernate
  19. Hibernate Annotation Placement Question
  20. How to create database schema in hibernate first time and further update it in case of schema modification?
  21. Native query with named parameter fails with “Not all named parameters have been set”
  22. @BatchSize a smart or stupid use?
  23. Spring Data JPA and Exists query
  24. HibernateException: Couldn’t obtain transaction-synchronized Session for current thread
  25. Error creating bean with name ‘entityManagerFactory
  26. HQL joined query to eager fetch a large number of relationships
  27. Clarifying terminology – What does “hydrating” a JPA or Hibernate entity mean when fetching the entity from the DB
  28. getting result set into DTO with native SQL Query in Hibernate
  29. Hibernate Issue : Foreign key must have same number of columns as referenced primary key
  30. How to get jdbc connection from hibernate session? [duplicate]

Leave a Comment