I have an application which is performing the following:

1. Insert a record into a transaction table - including a number field x.
2. Update a rolling total in another table - increment by x.

The two tables are not related within the database schema.

I have not been able to determine how to ensure that the rolling total is incremented correctly (there are current access issues).

How do you configure hibernate to issue the update in the form

update table
set col1 = col1+ x
where id = xyz

or do I need to introduce some pessimistic locking to ensure correct running total.

Thanks for any help in advance.