Here’s a set of nice tutorials and insights into how to use jOOQ or jOOλ in your code:

jOOQ

• 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λ

• 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