liveBook · Manning

Repeatable read isolation level

Repeatable read is a database transaction-isolation level that prevents a transaction from observing changes to data it has already read during that transaction.

How 2 Manning books explain it

Java Persistence with Spring Data and Hibernate epub

Repeatable read is a transaction isolation level under which repeated reads of the same data return a consistent value within a transaction, preventing unrepeatable reads while generally allowing phantom reads.

How it is used
Uses repeatable read to control concurrent transaction visibility and explain refresh behavior.
How deep it goes
Compares isolation guarantees and costs, then details pessimistic locking and persistence-context behavior without developing a database isolation implementation.
Examples
Illustrates repeatable read with a changing highest bid and a JPA query that locks items while summing prices.
What you can do after
Evaluate transaction isolation and distinguish database repeatable reads from persistence-context entity reuse.

Read how Java Persistence with Spring Data and Hibernate epub explains repeatable read isolation level →

100 SQL Server Mistakes and How to Avoid Them

Repeatable Read is a transaction isolation level that prevents dirty and nonrepeatable reads but can allow phantom reads.

How it is used
Guides transaction-isolation choices when preventing nonrepeatable reads matters more than permitting maximum concurrency.
How deep it goes
Explains dirty, nonrepeatable, and phantom reads through concurrent transactions, but stops short of implementation internals.
Examples
Demonstrates reporting queries and a data steward's updates or deletes against ImpressionsArchive in two query windows.
What you can do after
Evaluate whether Repeatable Read is necessary, then choose a weaker or stronger isolation level according to consistency and contention requirements.

Read how 100 SQL Server Mistakes and How to Avoid Them explains repeatable read isolation level →

Also covered in

What to know first

Related concepts

Questions about repeatable read isolation level

What is repeatable read isolation level?

Repeatable read is a database transaction-isolation level that prevents a transaction from observing changes to data it has already read during that transaction.

Which Manning books explain repeatable read isolation level?

Java Persistence with Spring Data and Hibernate epub and 100 SQL Server Mistakes and How to Avoid Them.

What should I know before learning repeatable read isolation level?

Manning books that teach repeatable read isolation level usually introduce database transaction and SQL first.

What is the difference between repeatable read isolation level and read committed isolation level?

Repeatable read is a database transaction-isolation level that prevents a transaction from observing changes to data it has already read during that transaction. A database transaction isolation level that prevents reads of uncommitted changes while allowing later reads in a transaction to observe newer committed data.

What is repeatable read isolation level a kind of?

Repeatable read isolation level is a kind of isolation. Isolation is the separation of components, processes, resources, or contexts to limit interaction, interference, or the propagation of effects between them.

These guides are generated from the text of Manning books by Manning's knowledge graph and link to the sections they draw on. The full books are available on liveBook and at manning.com.