Hi,

I would like to insert/update a column using a formula, which is similar to retrieving a column based on formula.

Below is the sample code,
---------------------------------
<property column="emp_id" generated="never" lazy="false"
name="emp_id" />
<property name="department" column="department_id" lazy="false"
formula="(select e.department_id from EMPLOYEE e where e.emp_id = emp_id)" />
--------------------------------------

The idea, is to track department_id of an employee which will/can change frequently

Check out if a "column transformer" is something that may work for you: http://docs.jboss.org/hibernate/core/3. ... -and-write

I discovered this just a few days ago so I think it is a fairly new feature (eg. Hibernate 3.6) and I haven't tried it myself.

Hi,

Thanks a lot for the quick response.

Since I had restriction to upgrade to 3.5 in our project. I did a workaround.
I am resetting the fields in Java and saving it.

May be in future, I would like to sue the column transformer feature.