Skip to main content
SpringerLink
Log in
Apress
Book cover

Beginning jOOQ

Learn to Write Efficient and Effective Java-Based SQL Database Operations

  • Book
  • © 2022

Overview

Authors:
  1. Tayo Koleoso

    1. Silver Spring, USA

    View author publications

    You can also search for this author in PubMed   Google Scholar

  • A unique tutorial on learning jOOQ programming
  • Includes practical examples and case studies
  • Be able to take the knowledge in the book and directly apply them to your work

This is a preview of subscription content, log in via an institution to check access.

Access this book

Log in via an institution
eBook USD 39.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 49.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

Licence this eBook for your library

Institutional subscriptions

Table of contents (5 chapters)

  1. Front Matter

    Pages i-ix
    Download chapter PDF

  2. Welcome to jOOQ

    • Tayo Koleoso
    Pages 1-14

  3. Getting Started with jOOQ

    • Tayo Koleoso
    Pages 15-88

  4. Working with jOOQ

    • Tayo Koleoso
    Pages 89-144

  5. Integrating with jOOQ

    • Tayo Koleoso
    Pages 145-172

  6. Packaging and Testing jOOQ

    • Tayo Koleoso
    Pages 173-209

  7. Back Matter

    Pages 211-214
    Download chapter PDF
Back to top

Keywords

About this book

Learn to use the jOOQ library to manage SQL database operations in Java and JVM applications. This book walks you through what JOOQ is, how to install and get started with it, and then gets you working with it.

Practical examples and case studies demonstrate how jOOQ offers a more efficient and versatile alternative to Object-Relational Mapping frameworks like Hibernate and JPA, while providing a natural, native-SQL feeling for the developer. You'll see how to maximize the full potential of your SQL database with advanced query syntax and functions with this lightweight, SQL-friendly framework. Come see how you can use high performance approaches like reactive, data streaming and cloud-native programming to get data from SQL tables.

Never write another incorrect SQL statement again and protect your application from SQL injection with the strong typing and inbuilt controls in jOOQ. Learn how to add jOOQ to your existing Hibernate, Spring Boot or Quarkus applications.

When you’ve completed this book, you will be able to take the knowledge you’ve gained, along with the freely available source code, and directly apply them to your own work.

What You Will Learn

  • Comparing equivalent features between Hibernate, JPA and jOOQ
  • Unlock the power of your SQL database with high performing, flexible and typesafe SQL queries
  • Seamlessly work with many different SQL database vendors without changing your code
  • Effortlessly generate Java code based on the content of your database
  • Write reactive SQL database access code with R2DBC
  • Integrating jOOQ into popular frameworks and platforms like Hibernate, Spring boot and Quarkus tools like IDEs
  • Testing jOOQ-based code with modern integration testing frameworks like TestContainers and Docker
  • Learn how to safely handle data access code within frameworks like the Java Persistence API (JPA)

 Who This Book Is For

Intermediate Java programmers new to jOOQ. Some prior experience with SQL may be helpful but not required.

Reviews

“Making the right decision about your dependencies isn't easy. The Java ecosystem offers many choices on all layers of your application. Should you use jOOQ for your next project? Could you use it along with JPA? Is it a good choice if you're going reactive? Tayo's book answers these questions and many more and provides a lot of introductory insight into the jOOQ ecosystem in a very refreshing and fun way. It touches on most of jOOQ's functionality, compares it with other options, and puts it in context with important topics for database developers, such as testing.” (Lukas Eder, Creator of jOOQ, Founder of Data Geekery GmbH)

Authors and Affiliations

  • Silver Spring, USA

    Tayo Koleoso

About the author

Tayo Koleoso is the Founder and CEO of LettuceWork.io, the platform dedicated to engineering culture. He created the Better Managed Development method for building and sustaining an effective product engineering culture. He's a lifelong learner, engineer, and engineering leader committed to building people and software in a healthy, sustainable, and effective ecosystem. Outside of tech, comedy is the only thing he consumes in large quantity. King of the Hill, Peep Show and 30 Rock are his comfort telly, I tell you what. 

He got his start in software engineering as a teenage database programmer with Oracle 8i. The jOOQ platform is therefore a natural fit and a return to his roots: his love affair with SQL. 

Bibliographic Information

Publish with us

Policies and ethics

Back to top

Search

Navigation