How to get Map List from HQL?

Yashnoo · **Joined:** Wed Dec 17, 2003 4:24 am **Posts:** 188

Hi everyone:

Is there any query method can return a Map List?
For example:

Code:

List list=session.createQuery("from Article").list();

The list will be [Map1,Map2,Map3,Map4]. The map will be :Map1["name","yashnoo"]. How to query database using hibernate can do this? Thks!

pkulak · **Joined:** Tue Mar 01, 2005 2:35 pm **Posts:** 60

Use a projection. You should have a good reason for doing this, though, since it's preferred to get objects back.

SELECT a.name, a.id ...
FROM Article a

Yashnoo · **Joined:** Wed Dec 17, 2003 4:24 am **Posts:** 188

pkulak wrote:

Use a projection. You should have a good reason for doing this, though, since it's preferred to get objects back.

SELECT a.name, a.id ...
FROM Article a

"Use a projection"? what's your meaning? If I use your method, I will get is a object[] other than map list. :-(