SQL was never meant to be abstracted. To be confined in the narrow boundaries of heavy mappers, hiding the beauty and simplicity of relational data. SQL was never meant to be object-oriented. SQL was never meant to be anything other than… SQL! - Lukas Eder, the creator of jOOQ.

What’s the best way to use SQL with Java? Often JPA/Hibernate is used without rethinking the choice. But there are other frameworks like jOOQ that, in many situations, maybe a better fit.

This workshop will teach you how to use jOOQ with Spring Boot, Flyway, and Testcontainers to access SQL databases efficiently.

AGENDA
After a quick start, the workshop will do a deep-dive into the features of jOOQ and the integration with Spring Boot and how to use it in combination with JPA

Setting up jOOQ, Spring Boot, Flyway, and Testcontainers
How to use the jOOQ DSL for SQL building
Generating the metamodel for writing type-safe queries
Execute queries and process results, including nested Java Records and multisets
Call stored procedures and use functions
Use transactions
How does the jOOQ Spring Boot auto-configuration work
Use the best of both worlds. How to integrate jOOQ with JPA