property and formula

rda · **Joined:** Wed Sep 28, 2005 3:29 am **Posts:** 20

Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:
3.1
Hi

I have a mapping file which contains the following property
<property name="bruttobetrag" formula="(1+(mwst/100))*(vk * stk)" type="double"></property>

I would like to round the result of the formula. how could i do this?

thx

max · **Posted:** Tue Oct 04, 2005 1:17 pm

use the round function from your database ?

snpesnpe · **Joined:** Sat Jun 12, 2004 4:49 pm **Posts:** 915

if you dialect support round you can try

Code:

<property name="bruttobetrag" formula="round((1+(mwst/100))*(vk * stk))" type="double"></property> 

or do round in java (in getter)

regards

rda · **Joined:** Wed Sep 28, 2005 3:29 am **Posts:** 20

Thank you for your help

another question:

<property name="bruttobetrag" formula="(1+(mwst/100))*(vk * stk)" type="double"></property>
<property name="test" formula="3+bruttobetrag" type="double"></property>

is it possible to write something like my example.
could i use a "nested" property in my formula? (please see the test-property, where i would like to use the bruttobetrag-property.

thx

snpesnpe · **Joined:** Sat Jun 12, 2004 4:49 pm **Posts:** 915

You can't do it , but you can resolve this in java, easy

create simple getter like

Code:

public float getTest() {
  return 3+bruttobetrag;
}