Can Hibernate Custom query return a Map instead of a List?

Question

Is it possible to return a map instead of a List from a custom JPA Query?

I know if is possible from the Entities themselves. In my case I have a custom query which returns some stats across different tables for a range of dates.

Ideally I would like the returned map to have the date as key and the stat as value.

JB Nizet · Accepted Answer · 2011-07-31 12:18:59Z

5

You'll just have to create and populate the map by yourself:

List<Object[]> rows = query.list();
Map<Date, Integer> statsPerDate = new HashMap<Date, Integer>(rows.size());
for (Object[] row : rows) {
    Date date = (Date) row[0];
    Integer stat = (Integer) row[1];
    statsPerDate.put(date, stat);
}

answered Jul 31, 2011 at 12:18

JB Nizet

694k94 gold badges1.3k silver badges1.3k bronze badges

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

1 Comment

emt14 Over a year ago

That's what I gathered. I was hoping there might be a clever way to avoid the overhead. Tx.

Collectives™ on Stack Overflow

Can Hibernate Custom query return a Map instead of a List?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related