<property formula="?" />

micho2001 · **Posted:** Wed Dec 03, 2003 6:34 pm

Hi!

I'm trying to use a calculated property (formula) but had only luck with simple things like adding up attributes:

Assuming a class that has the quantity, unit_cost and unit_labor attributes, this will work:

Code:

But I would like to perform an SQL query like the following, which doesnt work.

Code:

select sum (quantity * (unit_cost+ unit_labor)) from table_X

From my understanding the documentation for http://www.hibernate.org/hib_docs/reference/html/or-mapping.html#or-mapping-s1-7 Hibernate 2.1 (the version I'm using) talk about formula beign an SQL expression... but its not really clear on the semantics, variable scope etc...

Any ideas or workarounds?

gavin · **Posted:** Wed Dec 03, 2003 8:58 pm

Why doesn't it work?

You may use any columns of the class' table in the formula.

micho2001 · **Posted:** Fri Dec 05, 2003 1:56 pm

This works great:

Code:

<property
            name="item"
            type="long"
            update="true"
            insert="true"
            column="item"
        />

<!-- totalContractedPerItem is a strored procedure which has a number as input and a single row as output.  -->
  <property name="totalContracted" 
        type ="float"
        update="false"
        insert="false"
        formula="(select * from totalContractedPerItem(6880))" 
        />

BUT I dont want a literal (6880), I would need to pass as an argument the item property. Is that feasible? Any other better way to do it?

Thanks in advance