Loading

Concurrency violation in DataAdapter.Update

Pradeep Kellangere

Hi,

I am getting the concurrency violation when I'm updating the data for the second time. First time everything goes smooth and gets updated to oracle database.

I am calling ApplyingChanges also after the first update. Even though the row state is "modified" for the second update and "old row" and "current row" show the right value it is throwing exception.

Regards

Pradeep

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Andrzej Wegierski21y ago
What about spaces in the end of fields? They should cause this error. For instance, You add "xxx" key. It works. But there is "xxx " in database. Update failed.
Next - additional AcceptChanges between updates can modify row status and generate thesame error. For instance row is added. AcceptChanges modifies status to not modified. Modifying the field changes status to modified - but there's no such row in database. Update failed.
Check Your code.