How to fetch hibernate query result as associative array of list or hashmap

by

You have to use the “new map” syntax (Hibernate Reference paragraph 14.6)

select new map(count(i.inspectionId) as tot_inspections, t.year as year, t.quarter as quarter) from ...

The rest of the query is the same. This will return a list of maps, where the key is the alias of the “column”.

More Related Contents:

  1. Getting a ‘No thread-bound request found’ error from spring in my web app
  2. How do you do a limit query in JPQL or HQL?
  3. Hibernate: different object with the same identifier value was already associated with the session [duplicate]
  4. Hibernate Criteria returns children multiple times with FetchType.EAGER
  5. Why does Hibernate require no argument constructor?
  6. How can I log SQL statements in Spring Boot?
  7. How to choose the id generation strategy when using JPA and Hibernate
  8. JPQL Create new Object In Select Statement – avoid or embrace?
  9. Hibernate, @SequenceGenerator and allocationSize
  10. What is the difference between Unidirectional and Bidirectional JPA and Hibernate associations?
  11. What’s the difference between session.persist() and session.save() in Hibernate?
  12. Why do I need Transaction in Hibernate for read-only operations?
  13. What is the easiest way to ignore a JPA field during persistence?
  14. @Transactional method called from another method doesn’t obtain a transaction
  15. Spring 3 MVC: one-to-many within a dynamic form (add/remove on create/update)
  16. Hibernate bidirectional @ManyToOne, updating the not owning side not working
  17. Spring boot JPA insert in TABLE with uppercase name with Hibernate
  18. How to get distinct results in hibernate with joins and row-based limiting (paging)?
  19. When are connections returned to the connection pool with Spring JPA (Hibernate) Entity Manager?
  20. Hibernate, Postgres & Array Type
  21. Light weight alternative to Hibernate? [closed]
  22. Java: Hibernate @OneToOne mapping
  23. Hibernate, spring, JPS & isolation – custom isolation not supported
  24. Hibernate, Java 9 and SystemException
  25. Hibernate vs JPA vs JDO – pros and cons of each? [closed]
  26. Why has javax.persistence-api been replaced by jakarta.persistence-api in spring data jpa starter?
  27. Spring Data JPA: How can Query return Non- Entities Objects or List of Objects?
  28. java.lang.IllegalStateException: No transactional EntityManager available
  29. How to write a like query in HQL
  30. Hibernate Criteria API: get n random rows

Leave a Comment