How to return List<Map<String, Object>> using Hibernate

Question

I want to return a List of maps from my createNativeQuery().getResultList(), where each map is a pair key - value representing column name - value. I already tried to use direct in the method like this:

public List<Map<String, Object>> execQuery(String nativeQuery) {
    return entityManager().query(nativeQuery).getResultList();
}

but it always return List. Someone knows if what I want is even possible?
The JPA implementation that I'm using is Hibernate. I'm currently using Java 8 (don't know if this information is relevant for my case).
Any help is welcome. Thanks in advance.

does sth like this work for you? Query q1 = entityManager().query(nativeQuery); org.hibernate.Query hibernateQuery =((org.hibernate.jpa.HibernateQuery)q1) .getHibernateQuery(); hibernateQuery.setResultTransformer(AliasToEntityMapResultTransformer.INSTANCE); — Apostolos
– Apostolos, Commented Jul 22, 2016 at 19:08
You can't with a query alone in JPQL. Convert the results yourself into what you need — user3973283
– user3973283, Commented Jul 22, 2016 at 19:09
@Apostolos Thank you very much, this solved my problem :D. This will tie my application to Hibernate but it's not a problem right now :). — Kim Aragon Escobar
– Kim Aragon Escobar, Commented Jul 22, 2016 at 19:16
sometimes i also try not to do jpa-implementation-library-specific stuff but what are the chances of changing library? so instead of struggling to find a JPA-generic solution, in some parts of code i prefer using hibernate-specific parts too. — Apostolos
– Apostolos, Commented Jul 22, 2016 at 19:20

tiagoribeirof · Accepted Answer · 2016-07-22 19:34:48Z

2

You can to use the ResultTransformer to transform your results in a map form. Following the oficial documentation

Like this:

List<Map<String,Object>> mapaEntity = session
    .createQuery( "select e  from Entity" )
    .setResultTransformer(new AliasToEntityMapResultTransformer())
    .list();

answered Jul 22, 2016 at 19:34

tiagoribeirof

193 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Kim Aragon Escobar Over a year ago

This seems to be a cleaner solution, but in my current application I don't have access to the org.hibernate.Session :(, but thanks for you answer :)

Apostolos · Accepted Answer · 2016-07-22 19:18:36Z

1

Please try with

Query q1 = entityManager().query(nativeQuery); 
org.hibernate.Query hibernateQuery =((org.hibernate.jpa.HibernateQuery)q1) .getHibernateQuery(); 
hibernateQuery.setResultTransformer(AliasToEntityMapResultTransformer.INSTANCE);‌

answered Jul 22, 2016 at 19:18

Apostolos

10.5k5 gold badges32 silver badges44 bronze badges

Collectives™ on Stack Overflow

How to return List<Map<String, Object>> using Hibernate

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related