Hello,

is it possible to have different mapping-behavior for reading (formula) and writing (normal)?

I have a many-to-one mapping to another class (entity-mapping) eg.

<many-to-one name="state" entity-name="State" >
<column name="state_id" />
</many-to-one>

What I´d like to do is to have a formula for reading this property, but writing should not be affected, eg:

<many-to-one name="state" entity-name="State" formula="select State from State where id=1">
<column name="state_id" />
</many-to-one>

Is that possible?

Thanks.

Perhaps you could have two properties, "state" and "stateFromFormula".
Then you can handle your specific logic by changing the code in setState(...) and setStateFromFormula(...).