Here’s a set of nice tutorials and insights into how to use jOOQ or jOOλ in your code:
jOOQ
- The jOOQ Parser Ignore Comment Syntax
- Using Testcontainers to Generate jOOQ Code
- Using jOOQ to write vendor agnostic SQL with JPA’s native query or @Formula
- Vendor Agnostic, Dynamic Procedural Logic with jOOQ
- MySQL’s allowMultiQueries flag with JDBC and jOOQ
- 10 Things You Didn’t Know About jOOQ
- Formatting ASCII Charts With jOOQ
- Ad-hoc Data Type Conversion with jOOQ 3.15
- Reactive SQL with jOOQ 3.15 and R2DBC
- jOOQ 3.15’s New Multiset Operator Will Change How You Think About SQL
- Quickly Trying out jOOQ with Jbang!
- Use ResultQuery.collect() to Implement Powerful Mappings
- Never Again Forget to Call .execute() in jOOQ
- Simulating Latency with SQL / JDBC
- Translating Stored Procedures Between Dialects
- jOOQ Internals: Pushing up SQL fragments
- Automatically Transform Oracle Style Implicit Joins to ANSI JOIN using jOOQ
- Using jOOQ 3.14 Synthetic Foreign Keys to Write Implicit Joins on Views
- Nesting Collections With jOOQ 3.14’s SQL/XML or SQL/JSON support
- Using SQL Server FOR XML and FOR JSON Syntax on Other RDBMS With jOOQ
- What’s a “String” in the jOOQ API?
- Using Java 13+ Text Blocks for Plain SQL with jOOQ
- Never Concatenate Strings With jOOQ
- Use the jOOQ-Refaster Module for Automatic Migration off of Deprecated jOOQ API
- How to Simulate a Liquibase Migration using H2
- How to Map MySQL’s TINYINT(1) to Boolean in jOOQ
- Quantified LIKE ANY predicates in jOOQ 3.12
- How to Use jOOQ’s Commercial Distributions with Spring Boot
- How to Statically Override the Default Settings in jOOQ
- How to Use jOOQ’s UpdatableRecord for CRUD to Apply a Delta
- A Frequent Question: Does jOOQ Have a First Level Cache?
- jOOQ 3.11 Released With 4 New Databases, Implicit Joins, Diagnostics, and Much More
- Mocking JDBC Using a Set of SQL String / Result Pairs
- Top 10 SQL Dialect Emulations Implemented in jOOQ
- Map Reducing a Set of Values Into a Dynamic SQL UNION Query
- Type Safe Implicit JOIN Through Path Navigation in jOOQ 3.11
- Top 5 Hidden jOOQ Features
- Using JDK 10’s Local Variable Type Inference with jOOQ
- jOOQ 3.10 Supports JPA AttributeConverter
- 5 Things You May Not Have Known About jOOQ
- jOOQ 3.10 Supports Exciting MySQL 8.0 Features
- How to Fetch Oracle 12c Implicit Cursors with JDBC and jOOQ
- How to Execute SQL Batches With JDBC and jOOQ
- A Functional Programming Approach to Dynamic SQL with jOOQ
- jOOQ 3.10 will Support SQL Server’s Table Valued Parameters
- How to Write a Quick and Dirty Converter in jOOQ
- How to Prevent JDBC Resource Leaks with JDBC and with jOOQ
- Prevent SQL Injection with SQL Builders Like jOOQ
- Use jOOQ to Read / Write Oracle PL/SQL RECORD Types
- A Hidden jOOQ Gem: Foreach Loop Over ResultQuery
- Using Stored Procedures With JPA, JDBC… Meh, Just Use jOOQ
- JSR-308 and the Checker Framework Add Even More Typesafety to jOOQ 3.9
- Using jOOQ’s ExecuteListener to Prevent Write Operations on a Connection
- Using Oracle AQ via Java 8 Streams
- How to Detect Slow Queries with jOOQ
- Use JUnit’s expected exceptions sparingly
- Oracle LONG and LONG RAW Causing “Stream has already been closed” Exception
- A Beginner’s Guide to Using Java EE with jOOQ
- Implementing Client-Side Row-Level Security with jOOQ
- Type Safe Queries for JPA’s Native Query API
- PostgreSQL’s Best-Kept Secret, and how to Use it with jOOQ
- Let’s Review How to Insert Clob or Blob via JDBC
- How to FlatMap a JDBC ResultSet with Java 8?
- Hack up a Simple JDBC ResultSet Cache Using jOOQ’s MockDataProvider
- Integrating jOOQ with Grails Featuring the UWS-jOOQ Plugin
- jOOQ vs. Hibernate: When to Choose Which
- jOOQ vs. Slick – Pros and Cons of Each Approach
- Infinite Loops. Or: Anything that Can Possibly Go Wrong, Does.
- Transform Your SQL Data into Charts Using jOOQ and JavaFX
- Painless Access from Java to PL/SQL Procedures with jOOQ
- jOOQ Tip of the Day: Discover all Primary Keys
- Asynchronous SQL Execution with jOOQ and Java 8’s CompletableFuture
- Stop Manually Importing Your ERD Export into jOOQ
- Integrating jOOQ with PostgreSQL: Partitioning
- Using Oracle AQ in Java Won’t Get Any Easier Than This
- jOOQ Tip of the Day: Reuse Bind Values
- Java 8 Friday: More Functional Relational Transformation
- Flyway and jOOQ for Unbeatable SQL Development Productivity
- Stop Trying to Emulate SQL OFFSET Pagination with Your In-House DB Framework!
- JavaScript goes SQL with Nashorn and jOOQ
- Most Internal DSLs are Outdated
- Better Exceptions
- We’re Hacking JDBC, so You Don’t Have To
- How to Integrate jOOQ with Hibernate
- Using jOOQ with JAX-RS to Build a Simple License Server
- Using jOOQ With Groovy
- Use ModelMapper and jOOQ to Regain Control of your Domain Model
- jOOQ as a PL/Java language
- Easy Mocking of Your Database
- jOOQ’s Reason for Being
- Java, if this were a better world
- Java trivia: the double-checked locking pattern
- Advanced SQL: Relational division in jOOQ
- SQL in Scala, where jOOQ could go
- The ultimate SQL-DSL: jOOQ in Scala
- jOOQ-meta. A “hard-core SQL” proof of concept
- Use jOOQ inside your H2 database
- JDBC batch operations with jOOQ
- Use jOOQ to transform java.sql.ResultSet
- Debug logging SQL with jOOQ
- Loading CSV data with jOOQ
jOOλ
- Use jOOλ’s Sneaky Throw to Avoid Checked Exceptions
- Lesser Known jOOλ Features: Useful Collectors
- Using jOOλ to Combine Several Java 8 Collectors into One
- How to Pattern-Match Files and Display Adjacent Lines in Java
- 2016 Will be the Year Remembered as When Java Finally Had Window Functions!
- How to use Java 8 Functional Programming to Generate an Alphabetic Sequence
- How to Use Java 8 Streams to Swiftly Replace Elements in a List
- How to Translate SQL GROUP BY and Aggregations to Java 8
- Using Java 8 to Prevent Excessively Wide Logs
- Let’s Stream a Map in Java 8 with jOOλ
- Don’t Miss out on Writing Java 8 SQL One-Liners with jOOλ or jOOQ
- When the Java 8 Streams API is not Enough
- SQL ResultSet Streams