Returning typesafe objects from sql queries ?

mvalentin · **Joined:** Thu Jan 08, 2004 12:05 pm **Posts:** 14

Hi!

Is it possible ?. With hql it's "select new com.x.AType(...) from .... ". I've tried something like this but didn't work(hibernate it's complaining about com.x.AType as not beeing an entity).

Code:

<sql-query name="nquery">
    <return alias="aType" class="com.x.AType">
      <return-property name="aProperty" column="PROPERTY_COLUMN"/>
    </return>
    SELECT aType.PROPERTY_COLUMN AS aProperty
    FROM ATYPE_TABLE aType
</sql-query>

Hibernate version:3

Thanks.[/code]

max · **Posted:** Thu Aug 18, 2005 4:44 am

no - but we are getting more and more request for this .... vote/create jira issues for it...

mvalentin · **Joined:** Thu Jan 08, 2004 12:05 pm **Posts:** 14

done
http://opensource.atlassian.com/projects/hibernate/browse/HHH-877

thanks.