I've got an Order object that has a collection of Items and a formula property (Order.TotalPrice) that calculates the total price of the Items in an Order. If I update the price of one of the Items in an Order with session.Update(Item) then do Order.TotalPrice I don't get an updated total. If I do a session.Flush() before the Order.TotalPrice I get the updated total.

Is this a bug? Or am I doing something wrong?

you are doing something wrong unfortunately. :) think about it, the formula is calculated by the database when the object is instantiated. so the SQL can't run when the object is updated. you would have to call session.Flush() or maybe even session.Lock() to allow the SQL formula to be recalculated.

-devon

I would have thought hibernate would take care of the flush and refresh the formula when you access the formula.

unfortunately no. would need to call session.Refresh() after you save the object, or reload the object in a new session to get the formula to run. there is no way for NH to execute a read (formula) when session.Flush() (execpt for getting an id of a transient object that is made persistent).

-devon