Book

jOOQ Masterclass

jOOQ Masterclass will help you write the coolest SQL statements without working with JDBC or handling ORM complexity and performance issues. This practical guide to jOOQ provides a hands-on approach with a complete and versatile set of solutions for implementing the persistence layer to serve the most stressful environments.

Offered byPackt Logo

Difficulty Level

Intermediate

Completion Time

25h28m

Language

English

About Book

Who Is This Book For?

This book is for Java developers who write applications that interact with databases via SQL. No prior experience with jOOQ is assumed.

Book content

chapters • 25h28m total length

Starting jOOQ and Spring Boot

Customizing the jOOQ Level of Involvement

jOOQ Core Concepts

Building a DAO Layer (Evolving the Generated DAO Layer)

Tackling Different Kinds of SELECT, INSERT, UPDATE, DELETE, and MERGE Statements.

Tackling Different Kinds of JOIN Statements

Types, Converters, and Binding

Fetching and Mapping

CRUD, Transactions, and Locking

Exporting, Batching, Bulking, and Loading

jOOQ Keys

Pagination and Dynamic Queries

Exploiting SQL Functions

Derived Tables, CTEs, and Views

Calling and Creating Stored Functions and Procedures

Tackling Aliases and SQL Templating

Multitenancy in jOOQ

jOOQ SPI (Providers and Listeners)

Logging and Testing

Related Resources

Access Ready-to-Use Books for Free!

Get instant access to a library of pre-built books—free trial, no credit card required. Start training your team in minutes!

No credit card required