hibernate returns list , can it return Map

ejaincom · **Joined:** Fri Feb 25, 2011 2:34 am **Posts:** 11

hi friends,
I am developing an application in struts2 and hibernate and i dont like the list returned by hibernate create query function on session,
actually if i tie the list to a variaable and access in jsp then i have to rely on object index rather than name,
It is becoming complicated to remember the index of the list variable,
Is there any other way out
Pl. help,
abhishek

xxtommoxx · **Joined:** Mon Jan 31, 2011 11:22 pm **Posts:** 6

I don't think you can. What would you want the key to be if you were to use a map?

ejaincom · **Joined:** Fri Feb 25, 2011 2:34 am **Posts:** 11

I want the key to be the column name.

abhi

chirag.naikec · **Posted:** Thu Mar 03, 2011 2:05 am

SQLQuery queryResult = session.createSQLQuery("Select * from xyz");

queryResult.setResultTransformer(AliasToEntityMapResultTransformer.INSTANCE);

This will return you a Map.

Try this out

ejaincom · **Joined:** Fri Feb 25, 2011 2:34 am **Posts:** 11

no, i dont think so,
each row will have its own unique pair and so on.
Actually this will allow the jsp coders to work independently of knowing which index the data lies in.

thanks

abhi

chirag.naikec · **Posted:** Thu Mar 03, 2011 2:15 am

ejaincom wrote:

no, i dont think so,
each row will have its own unique pair and so on.
Actually this will allow the jsp coders to work independently of knowing which index the data lies in.

thanks

abhi

SQLQuery queryResult = session.createSQLQuery("Select * from xyz");

queryResult.setResultTransformer(AliasToEntityMapResultTransformer.INSTANCE);

This will return you a Map.

Try this out