SQL is designed to be used directly – clear, powerful, and unadulterated. jOOQ enables a modern and efficient approach to SQL without limiting it to object-oriented constraints or mappings.

This workshop will teach you how to use jOOQ effectively with Spring Boot, Flyway, and Testcontainers. You will learn how to utilize relational databases efficiently and understand why jOOQ is often the better alternative to traditional frameworks like JPA/Hibernate – practical, flexible, and database-centric.

Vaadin1

After a quick start, the workshop will provide an overview of jOOQ’s features and its integration with Spring Boot, as well as how to use it in combination with JPA.

  • Setting up jOOQ, Spring Boot, Flyway, and Testcontainers.
  • Using the jOOQ DSL to create precise SQL queries.
  • Generating a metamodel to build type-safe queries.
  • Executing queries and processing results, including nested Java records and multisets.
  • Calling stored procedures and using functions.
  • Managing transactions with jOOQ.
  • Understanding the automatic configuration of jOOQ in Spring Boot.
  • Combining jOOQ and JPA to leverage the best of both approaches.