Learn from experts

Efficient Data Access with jOOQ

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.

SQL

/ess-cue-ell/
  • SQL (Structured Query Language) is a programming language for managing and querying relational databases.

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.

image-1
  • 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
  • Wie funktioniert die automatische Konfiguration von jOOQ in Spring Boot?
  • Nutzen Sie das Beste aus beiden Welten. So integrieren Sie jOOQ mit JPA

How to register for the course?

Please contact us here!