Paul Klingelhuber

Latest posts by Paul Klingelhuber

A rusty chain and brass padlock secure a green metal gate, which is part of a wire fence—much like how proper Spring transaction handling ensures security in a system. The background is blurred, showing a building.

Data & Platforms

DB-Lock-Issues with Transactional REQUIRES_NEW — More Spring/Java transaction handling pitfalls

If you haven’t read it yet, it’s probably a good idea to read part 1 of this post-series first. From now on we’ll assume that we remember roughly what part 1 was about. As a refresher, here’s one of the main points again: What is Propagation.REQUIRES_NEW? One may think that it “magically tells the database […]

May 18, 2022

Hand-drawn diagram showing a database, a connection pool with several connections, and code snippets using @Transactional and @Transactional(REQUIRES_NEW) interacting with the connections to illustrate Java transaction and Spring transaction management concepts.

Data & Platforms

Transactional REQUIRES_NEW considered harmful — Spring/Java transaction handling pitfalls

Databases and Transactions are great, Spring is great, Kotlin/Java are great (ofc. Kotlin is better 😉), simplifying transaction-handling is great. But as we all know, simplifying things almost always creates some new pitfalls if the things that were simplified aren’t fully understood. The Issue The Spring @Transactional Annotation is a powerful tool to make transaction-management […]

March 7, 2022

All articles