hbm only for the result of a query

robsonximenes@gmail.com · **Joined:** Wed Aug 31, 2005 7:51 am **Posts:** 3

Hi,

I have an query for a report and i would like to know if it is possible create an hbm file for represent de result.

If not, how could i do? because de query have same properties that are not present on tables... like sum()...

Thank you

pksiv · **Posted:** Wed Aug 31, 2005 8:48 am

You can create the mapping and leave the table name off

<class name="MyObject" mutable="false">
...
</class>

Create a non-default constructor which takes the values you want to return from the query and execute a query something like this.

Code:

select new xxx.yyy.MyObject(a.xx, a.blah, ...) from...