When moving an item around within the list, shouldn’t EVERY item have
its optimisitc locking field updated? Currently, only the item that is
moved has its optimisitc locking field updated, but every item has its
position field changed so surely they too should have their optimistic
locking fields updated?
I’ve created a drag and drop interface on a list of items that allows
for the items to be moved about to change their position. Whilst one
user can do this, another user can insert an item into the queue
causing a concurrency issue. The problem is this can’t be detected
using normal methods because none of the other items in the queue have
had their optimisitc locking field updated.
I can only assume there is reason that no one else has raised this as
an issue in the past, so I’d be very happy to be enlightened as why.
Thoughts and comments much appreciated.