in hibernate-mapping.xml file we have a property tag
That tag haing the formula property. In that we can give a query.
to that property that value will be upated or inserted .

So can anybody give an example for that how to use it

regards
vinny

There are no examples for using property formula="???" for writing to the DB. You can't do that. Formula properties are by definition derived, and have no equivalent column in the DB.

Explain what you hope to achieve, and I'll tell you how to do it with hibernate.

<property
name="propertyName" (1)
column="column_name" (2)
type="typename" (3)
update="true|false" (4)
insert="true|false" (4)
formula="arbitrary SQL expression" (5)
/>

[b] I need the explaination for that formula property

formula="select count(empno) from emp"

it will be worked out.