jOOQ Masterclass (Packt)
Monday, 05 September 2022

This book, subtitled "A practical guide for Java developers to write SQL queries for complex database interactions" covers jOOQ from beginner to expert level using examples for MySQL, PostgreSQL, SQL Server, and Oracle that show you how jOOQ is a mature and complete solution for implementing the persistence layer. Anghel Leonard shows how to use the jOOQ query builder framework to emulate database-specific SQL statements using a fluent, intuitive, and flexible DSL API.


The book shows how to use jOOQ in Spring Boot apps as a replacement for SpringTemplate and Spring Data JPA, and how to use jOOQ type-safe queries and CRUD operations via jOOQ's records, converters, bindings, types, mappers, multi-tenancy, logging, and testing. Later, the book shows how to use jOOQ to use SQL features such as UDTs, embeddable types and embedded keys.

Author: Anghel Leonard
Publisher: Packt Publishing
Date: August 2022
Pages: 764
ISBN: 978-1800566897
Print: 1800566891
Kindle: B09XHTBDJY
Audience: Java and database developers
Level: Intermediate
Category: Database and Java


  • Enable the jOOQ Code Generator in any combination of Java and Kotlin, Maven and Gradle
  • Generate jOOQ artifacts directly from database schema, or without touching the real database
  • Use jOOQ DSL to write and execute a wide range of queries for different databases
  • Understand jOOQ type-safe queries, CRUD operations, converters, bindings, and mappers
  • Implement advanced SQL concepts such as stored procedures, derived tables, CTEs, window functions, and database views
  • Implement jOOQ multi-tenancy, tuning, jOOQ SPI, logging, and testing



For recommendations of Java books see Java Books For Beginners, Java Books For Going Further and Advanced Java - Books Outside the Core in our Programmer's Bookshelf section.


For more Book Watch just click.

Book Watch is I Programmer's listing of new books and is compiled using publishers' publicity material. It is not to be read as a review where we provide an independent assessment. Some, but by no means all, of the books in Book Watch are eventually reviewed.

To have new titles included in Book Watch contact

Follow @bookwatchiprog on Twitter or subscribe to I Programmer's Books RSS feed for each day's new addition to Book Watch and for new reviews.




Murach's HTML5 and CSS3 (4e)

Author: Zak Ruvalcaba and Anne Boehm
Publisher: Murach
Date: Mar 2018
Pages: 736
ISBN: 978-1943872268
Print: 1943872260
Audience: Web developers
Rating: 4.5
Reviewer: Ian Elliot
HTML5 and CSS is the core of the web - it's time to master both.

SQL Server Query Tuning and Optimization (Packt)

Author: Benjamin Nevarez
Publisher: Packt Publishing Pages: 446
ISBN: 9781803242620
Print: 1803242620
Kindle: B0B42SVBFY
Audience: Intermediate to advanced DBAs and developers
Rating: 4.7
Reviewer: Ian Stirk 

This book aims to give you the tools and knowledge to get peak performance from your que [ ... ]

More Reviews