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

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) -------------------------------- ayo Koleoso is the Founder and CEO of LettuceWork, the world's first 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. He absolutely sucks at everything else. 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. Table of Contents 4 About the Author 7 About the Technical Reviewer 8 Chapter 1: Welcome to jOOQ 9 Database Operations in Java: The Good Parts 10 Database Operations in Java: The...Not So Good Parts 12 You Have Got to Be jOOQing 17 jOOQ Feature Tour 18 Database Aware 19 Code Generation 19 Type Safety 20 Domain-Specific Language 20 Tooling Support 21 JVM Languages 22 Chapter 2: Getting Started with jOOQ 23 Eden Auto Mart 27 Setting Up jOOQ 28 Install Dependencies for Commercial-Licensed jOOQ 30 CRUD with jOOQ 32 Your SQL Dialect and You 33 Tools of CRUD in jOOQ 36 Select Statements 42 The SELECT DSL 45 With the WHERE DSL 49 Conditions 50 Subqueries 54 Conditional Logic in Queries 58 With the... WITH Clause 62 With the GROUP BY DSL 65 With the HAVING DSL 66 With the ORDER BY DSL 66 ORDER BY CASE 67 ORDER BY NULL 69 Paginate Query Results 69 Insert Statements 71 With Multiple Rows 72 With Sequences 73 With Select 73 Update Statements 74 Delete Statements 75 Tuple Syntax 76 Alternative Data Access Modes 77 Streaming Access 78 Lazy Access 80 Transactions 81 With Locking 84 Configuration 86 Connection Management 87 Schema, Catalog, and Multi-tenant Deployment 89 Query Management 92 Query Lifecycle Integration 94 Chapter 3: Working with jOOQ 97 Generating Code 97 Tools of jOOQ Code Generation 98 Configure jOOQ for Code Generation 99 Generate Code with Maven 102 Generate Code from the Command Line 105 Generate Code Programmatically 107 Results of Code Generation 110 Tables 110 Global Artifacts 114 Add Custom Code to Generated Code 115 Working with Generated Code 117 CRUD with Generated Code 117 Enhancements from UpdatableRecord 120 Formatting 123 Optimistic Locking 123 Advanced Database Operations 125 Joins 125 Non-SQL Grouping 129 Batch Operations 136 Explicit Batching 138 Batch Import 142 Advanced Query Syntax 145 Merge and Upsert 145 Window Functions 148 Chapter 4: Integrating with jOOQ 153 Java Persistence API with jOOQ 154 Generate JPA Entities 155 Generate from JPA Entities 159 Generate SQL Queries 161 Spring Boot and jOOQ 170 Configure jOOQ in Spring Boot 171 With Custom SQL 173 jOOQ Spring Boot Starter 175 Quarkus and jOOQ 176 Chapter 5: Packaging and Testing jOOQ 181 Package Code with jOOQ 182 When You Don’t Need Code Generation 183 When You Don’t Have an Active Database Connection 185 When Your Schema Needs to Incrementally Evolve 186 Recipe for a Self-Sufficient Database Project 189 Testing with jOOQ 193 Tools of the (SQL) Testing Trade 195 Unit Testing with jOOQ 199 Using Mockito 200 With SQL Parsing 205 Integration Testing with Docker and TestContainers 206 With Spring Boot 214 Index 218 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.