Missing controls in transactions

Overview

When attempting to save multiple records as part of the same operation, one should always assure that the database isn't left in an inconsistent state in case of error. Using transaction control (savepoints and rollback) allows rolling back partial changes in case of error and preserves data integrity.

Business Impact

Decreased operational efficiency, increased potential for human error, delayed time-to-market, and decreased employee satisfaction.

Resources

Very Frequent

Incidence

How common is this issue?
61%27%
arrow down34%
lower

Exposure

How long do organizations remain exposed before fixing the problem?
2 years9 months
arrow down67%
shorter
BenchmarkWith Clayton

Frameworks

EasyiconAutomatediconData IntegrityiconError Handlingicon