scibel/testing-pessimistic-locking-handling-spring-boot-jpa-mysql

Example of how you can test pessimistic locking handling with Spring Boot and JPA on MySQL

This is a working example for MySQL database accompanying the blog post "Testing Pessimistic Locking Handling with Spring Boot and JPA"

More examples here:

• Example for Oracle
• Example for MySQL (this one)
• Example for PostgreSQL

Intro

This SpringBoot maven project is part of my blog post where you could find not only explanation for it, but also theoretical background for:

• What does pessimistic locking handling mean
• How you could implement it within a Spring Boot Application and JPA on the Oralce, MySQL and PostgreSQL databases
• How you could write integration tests for handling pessimistic locking.

Prerequisites:

• Docker
• JDK8+.

Setup

• Start MySQL database container from docker/db-up.sh
• Check with "docker ps" if the container is up&running.

Run pessimistic locking integration test withing in-memory database Apache Derby

🔔 Ideal for your DevOps pipeline

• Switch profile in InventoryServicePessimisticLockingTest.java to "test" (the default one)
• Run "./mvnw clean verify".

Run pessimistic locking integration test withing Oracle DB

🔔 Ideal for quick local test to try the real database when changing the pessimistic locking handling code

• Switch profile in InventoryServicePessimisticLockingTest.java to "test-oracle"
• Run "./mvnw clean verify".

Have fun and do not hesitate to contact me if you have any questions or suggestions!

About me

My name is Andrey Zahariev Stoev. I am working as Senior Software Architect in Switzerland. I love software craftsmanship and systems thinking. I am passionate about travel, languages and cultural diversity exploration.