Record Locking in APEX and other Connection Pooled Environments

We will cover the following major topics:

The Issue
* Multi-user applications and data corruption
* The LOST UPDATE problem
Potential Solutions
* Pessimistic Locking
* Optimistic Locking
* Pros and Cons of each
Dedicated Connection vs Connection Pooled Environments
* Why Pessimistic Locking will not work in APEX and other Connection Pooled Environments
Optimistic Locking Solutions
* Two techniques that work
* One technique that will not work
Code examples of working techniques are demonstrated

Presenters

Geoff Wiland

Dave Anderson

Tyson Jouglet