Chapter 9: CRUD, Transactions, and Locking

In this chapter, we'll cover a must-know mix of fundamental notions about CRUD operations, transactions, and locking. These three topics are heavily exploited in almost any database application. In a common scenario, an application has a significant number of CRUD operations that are executed in explicitly demarcated logical transactions and, in certain cases, they also need to explicitly control the concurrent access to data to prevent race conditions, lost updates, and other SQL phenomena (or SQL anomalies).

In this chapter, we will cover the following topics:

  • CRUD
  • Navigating (updatable) records
  • Transactions
  • Locking

Let's get started!

Technical requirements

The code for this chapter can be found ...

Get jOOQ Masterclass now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.