Background documentation-7067: Update without repeated read not allowed Locate this document in the navigation structure

 

An optimistic lock was set to at least one table row by a previous SQL statement. Afterwards, another database user updated at least one of these rows. The database user who set the optimistic lock can make new changes to this row only after reading it again with an (optimistic) lock.

User Response

The row to be updated must be read again with an (optimistic) lock.

More Information

Concepts of the Database System, Locks