Batch updating

For example like below SQL, you must specify version number in WHERE clauses and increment version number by 1 in SET not thrown and version property within entity is increment by 1 if updated count is not 0.

However, describing to SQL file for Optimistic concurrency control SQL is application developer’s responsibility.It offers the ability to update multiple records from one screen.In particular, Batch Updates is very useful for tasks such as updating payment records from pending to paid, or changing the status of an application already assigned for review.You can avoid these problems by grouping completed update sets into a batch.The system organizes update set batches into a hierarchy.

Leave a Reply