A technical guide demonstrating how to fetch hierarchical DTO projections in Spring Data JPA using jOOQ's MULTISET operator for type-safe queries.
Explains and resolves the 'Cannot resolve symbol VERSION_3_17' compilation error in jOOQ generated code due to version mismatches.
jOOQ 3.17 extends implicit join support to UPDATE and DELETE statements, simplifying DML queries with path expressions.
jOOQ 3.17 now treats SQL Conditions as Boolean Fields, simplifying queries and improving SQL standard compliance across dialects.
Explores various SQL dialects and jOOQ methods for returning data from INSERT, UPDATE, and DELETE statements using the RETURNING clause.
A guide on using jOOQ and Testcontainers to write integration tests for database stored procedures in Java, replacing manual JDBC calls.
Explores using the H2 in-memory database for testing with jOOQ, covering SQL standardisation and H2's compatibility modes.
Explains how to use jOOQ to call stored procedures from Java, highlighting benefits over raw JDBC for type safety and maintainability.
Explores jOOQ 3.17's new client-side computed columns feature, which allows creating dynamic, view-like columns in Java without SQL limitations.
jOOQ 3.17.0 release introduces client-side computed columns, audit columns, pattern matching, reactive transactions, and Kotlin coroutine support.
Explains how to filter a SQL query's nested collection (ARRAY/MULTISET) by a specific value, using PostgreSQL and jOOQ examples.
Discusses why SQL's SELECT..FROM syntax order isn't a flaw to be 'fixed' by FROM..SELECT, comparing it to logical execution order and language design.
Explores various data fetching methods in jOOQ, including iterable, single-record, and resourceful fetching techniques.
A tutorial on using jOOQ's MULTISET operator and type-safe conversion to map nested SQL query results into a nested Java Map structure.
Explains jOOQ's API for managing nested transactions, comparing it to JDBC defaults and Spring's @Transactional behavior.
A technical guide on using the jOOQ library to fetch and generate sequence values from various SQL databases.
A tutorial on building a minimal REST API in Java using Jersey and JOOQ with PostgreSQL, avoiding heavy reflection.
