JPA 2.0 native query results as map

by

Which JPA are you using – Hibernate, EclipseLink or something else?

There is no standard way to do this in JPA but your specific implementation may allow it – for example, Eclipselink has a query result type hint.

http://dev.eclipse.org/mhonarc/lists/eclipselink-users/msg03013.html

Query query = entityManager.createNativeQuery(sql);
query.setHint(QueryHints.RESULT_TYPE, ResultType.Map);

For Hibernate, with javax.persistence.Query dbQuery: 

org.hibernate.Query hibernateQuery =((org.hibernate.jpa.HibernateQuery)dbQuery)
.getHibernateQuery();
hibernateQuery.setResultTransformer(AliasToEntityMapResultTransformer.INSTANCE);

More Related Contents:

  1. JPA EntityManager: Why use persist() over merge()?
  2. JPA 2.0, Criteria API, Subqueries, In Expressions
  3. When use getOne and findOne methods Spring Data JPA
  4. Create JPA EntityManager without persistence.xml configuration file
  5. Spring Data JPA And NamedEntityGraphs
  6. How to persist JSR-310 types with Spring Data JPA?
  7. Is it possible to output generated SQL using EclipseLink without having to increase log verbosity?
  8. JPA passing list to IN clause in named native query
  9. Spring batch jpaPagingItemReader why some rows are not read?
  10. kotlin data class + bean validation jsr 303
  11. JPA transient information lost on create
  12. How do I do a “deep” fetch join in JPQL?
  13. Testing an EJB with JUnit
  14. Spring Data JPA and Querydsl to fetch subset of columns using bean/constructor projection
  15. JPA utf-8 characters not persisted
  16. JPA Query to handle NULL parameter value
  17. JPA Criteria API group_concat usage
  18. How do I count the number of rows returned by subquery?
  19. Hibernate Annotations – Which is better, field or property access?
  20. What is this spring.jpa.open-in-view=true property in Spring Boot?
  21. How to use @Where in Hibernate
  22. Hibernate: comparing current & previous record
  23. JAXB Mapping cyclic references to XML
  24. How to clone a JPA entity
  25. Should I write equals() and hashCode() methods in JPA entities?
  26. UNION to JPA Query
  27. @BatchSize a smart or stupid use?
  28. Error creating bean with name ‘entityManagerFactory
  29. Name attribute in @Entity and @Table
  30. JPA: Override Auto generated ID [duplicate]

Leave a Comment