Hi there,

I'm kind of new to Hibernate and want to implement a generic query, like specifying a number of column names, and get the result into a Map, as columnName, value pairs. Of course this Map object would represent a row from the database, and these Maps would be placed into a List.

Can i use the projection feauture of Hibernate to implement this generic query? what else can i use?

Thanks in advance.

Are you looking for something like:

http://www.hibernate.org/hib_docs/v3/re ... hql-select

Remember that Hibernate doesn't deal with "columns" from your applciation's standpoint--it works with properties and associations.

You can also use the Criteria API to perform projections. In general, projections are more for aggregate queries.

http://www.hibernate.org/hib_docs/v3/re ... projection

If you need a list of User objects, for example, simply create a query that returns those objects. The properties will be all populated for you, and associations will be looked up lazily.

I'm looking for something like the following: specify a list of property names mapped to a table's columns, to be the property values needed as result, and a condition, and get the values for the specifyied properties into a Map containing pairs of (propertyName, propertyValue).

Is it possible to do this kind of query? i know JDO can, and would love to be able to do this with Hibernate too.

http://www.theserverside.com/articles/a ... QueryPart2
"Projection into a concrete Map implementation"

Thanks for your interest

Sorry, I don't know of the answer myself. Post the answer here if you find it.