Versions Compared

Old Version 1

changes.mady.by.user Adriano Crestani

Saved on

compared with

New Version Current

changes.mady.by.user Adriano Crestani

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3

OptimisticConcurrencyControl

The RDB DAS is intended for use in disconnected scenarios. When the DAS returns a graph of SDO DataObjects as the result of a query, there are no locks held on the underlying database and the data is no longer associated with any database connection or transaction. However, although locks are not held, the DAS does employ a mechanism called Optimistic Concurrency Control (OCC) to manage concurrency.

...

DataObjectPtr customer = root->getDataObject("CUSTOMER\[1\]");
customer->setCString("LASTNAME", "Pavick");

//Some period of time passes in which "CUSTOMER\[1\]" could be modified by another process or application

das->applyChanges(root);

Panel

CommandPtr select = das->createCommand("Select * from CUSTOMER where LASTNAME = 'Williams'");
DataObjectPtr root = select->executeQuery();

Wiki Markup
Wiki Markup

...

If OCC is enabled then as part of "applyChanges" processing the DAS will ensure that the table row representing "CUSTOMER\[1\]" has not been changed since it was read. This is possible because a feature of the original SDO graph is to "remember" its original state along with any changes that have been made. The DAS has access to this original state and uses it to create an "overqualified" update statement. When the DAS executes this update statement against the database, it will fail if the underlying data has been modified (a collision has occurred) and, if so, an exception will be thrown and the transaction rolled back. If there is no collision then the update statement execution succeeds and the change is applied.