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 .