An Ounce of Prevention

Small Bug is still a BUG

When such staggering costs result from such a small error, the natural response is to say, “This must never happen again.” But how can it be prevented? Would a code review have caught this bug? Only if one of the reviewers knew the internals of Oracle’s JDBC driver or the review team spent hours on each method.

Stress testing

Would more testing have prevented this bug? Perhaps. Once the problem was identified, the team performed a test in the stress test environment that did demonstrate the same error. The regular test profile didn’t exercise this method enough to show the bug. In other words, once we know where to look, it’s simple to make a test that finds the bug