New object with HQL

by

I think that the section 15.6. The select clause covers what you’re trying to achieve:

15.6. The select clause

…

Queries can return multiple objects
and/or properties as an array of type
Object[]:

select mother, offspr, mate.name
from DomesticCat as mother
    inner join mother.mate as mate
    left outer join mother.kittens as offspr

Or as a List:

select new list(mother, offspr, mate.name)
from DomesticCat as mother
    inner join mother.mate as mate
    left outer join mother.kittens as offspr

Or – assuming that the class Family
has an appropriate constructor – as an
actual typesafe Java object:

select new Family(mother, mate, offspr)
from DomesticCat as mother
    join mother.mate as mate
    left join mother.kittens as offspr

In your case, you probably want:

SELECT new MyCustomList(product.code, SUM(product.price), COUNT(product.code))
from Product AS product
GROUP BY product.code

Where MyCustomList is not necessarily a mapped entity.

More Related Contents:

  1. How do you create a Distinct query in HQL
  2. How to use @Where in Hibernate
  3. Performing Date/Time Math In HQL?
  4. how to return Map with HQL
  5. Date operations in HQL
  6. How to simulate NVL in HQL
  7. How does JPA orphanRemoval=true differ from the ON DELETE CASCADE DML clause
  8. Hibernate Criteria Join with 3 Tables
  9. Another Repeated column in mapping for entity error
  10. Does the JPA specification allow references to non-primary key columns?
  11. Hibernate: comparing current & previous record
  12. Struggling to understand EntityManager proper use
  13. java.lang.ClassNotFoundException: org.hibernate.HibernateException
  14. Hibernate problem – “Use of @OneToMany or @ManyToMany targeting an unmapped class”
  15. How to use the Java 8 LocalDateTime with JPA and Hibernate
  16. Hibernate throws org.hibernate.AnnotationException: No identifier specified for entity: com..domain.idea.MAE_MFEView
  17. Using JPA entities in JSF. Which is the best strategy to prevent LazyInitializationException?
  18. Hibernate field naming issue with Spring Boot (naming strategy)
  19. How to configure Spring to make JPA (Hibernate) and JDBC (JdbcTemplate or MyBatis) share the same transaction
  20. what is the right path to refer a jar file in jpa persistence.xml in a web app?
  21. JPA CriteriaBuilder – How to use “IN” comparison operator
  22. HQL Hibernate INNER JOIN
  23. Setting properties programmatically in Hibernate
  24. Hibernate, alter identifier/primary key
  25. Hibernate: More than one row with the given identifier was found error
  26. Hibernate unidirectional one to many association – why is a join table better?
  27. What is the right way to use spring MVC with Hibernate in DAO, service layer architecture
  28. How to use JPA2’s @Cacheable instead of Hibernate’s @Cache
  29. Hibernate 3.6 – session.get() vs session.load()
  30. UnsupportedOperationException: The application must supply JDBC connections

Leave a Comment