0

I want to execute custom query using hibernate in dao.. I've tried following

Query query = sessionFactory
            .getCurrentSession()
            .createQuery("select new map(role,count(role)) from loginDetails group by 1"); 
 List<HashMap<String,Integer> >tuples = (List<HashMap<String,Integer>>) query.list();

I got following result

 [{0=ADMIN, 1=13}, {0=COMPANY, 1=5}, {0=USER, 1=9}]

But I want the result like

[{ADMIN, 13}, {COMPANY, 5}, {USER, 9}]

So I can retrieve data by key .

theoretisch
  • 1,718
  • 5
  • 24
  • 34

0 Answers0