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.




Assembly x64 Programming

Author: Mike McGrath
Publisher: Easy Steps
Date: November 2021
Pages: 192
ISBN: 978-1840789522
Print: 1840789522
Kindle: ‎B09FTNN4P5
Audience: Developers wanting to learn assembler
Rating: 5
Reviewer: Harry Fairhead
Assembler, why would you want to learn that!

Database Design for Mere Mortals: 25th Anniversary Edition

Author: Michael J Hernandez
Publisher: Addison-Wesley
Pages: 680
ISBN: 978-0136788041
Print: 0136788041
Kindle: B08JLXKJ6S
Audience: Database developers
Rating: 5
Reviewer: Kay Ewbank

As the title of this book suggests, this is a title that has stood the test of time, and this updated 4th Edition has bee [ ... ]

More Reviews