Java, SQL and jOOQ.

@java_sql_and_jooq@robot.villas

Java, SQL and jOOQ tutorials, database techniques, programming practices, and jOOQ releases from Lukas Eder and Data Geekery.

Source: https://blog.jooq.org/feed/

Homepage: https://blog.jooq.org

Posts

50

Posts

Simplifying ANTI JOIN with jOOQ Syntax #Java #SQL #Programming
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405630
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405630
Don't have an account? Find a server at joinmastodon.org
May 7, 2026
Why JOIN USING Can Lead to Errors in SQL #SQL #Database #Programming
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405638
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405638
Don't have an account? Find a server at joinmastodon.org
May 4, 2026
Managing Sensitive Data in jOOQ 3.21+ Logs #Java #Security #Logging
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405646
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405646
Don't have an account? Find a server at joinmastodon.org
Mar 27, 2026
Consider using JSON arrays instead of JSON objects for serialisation #Java #Json #Programming
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405657
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405657
Don't have an account? Find a server at joinmastodon.org
Aug 11, 2025
When SQL Meets Lambda Expressions #SQL #Java #Programming
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405666
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405666
Don't have an account? Find a server at joinmastodon.org
Mar 27, 2025
Think About SQL MERGE in Terms of a RIGHT JOIN #SQL #Database #Programming
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405677
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405677
Don't have an account? Find a server at joinmastodon.org
Mar 13, 2025
Resisting the Urge to Document Everything Everywhere #Programming #SoftwareDevelopment #Documentation
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405686
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405686
Don't have an account? Find a server at joinmastodon.org
Feb 28, 2025
jOOQ 3.20 released with ClickHouse, Databricks, and much more DuckDB support, new modules, Oracle type hierarchies, more spatial support, decfloat and synonym support, hidden columns, Scala 3, Kotlin 2, and much more #Java #SQL #Database
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405693
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405693
Don't have an account? Find a server at joinmastodon.org
Feb 20, 2025
Emulating SQL FILTER with Oracle JSON Aggregate Functions #SQL #JSON #Oracle
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405704
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405704
Don't have an account? Find a server at joinmastodon.org
Jun 3, 2024
Getting Top 1 Values Per Group in Oracle #SQL #Oracle #Database
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405712
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405712
Don't have an account? Find a server at joinmastodon.org
Mar 1, 2024
An Efficient Way to Check for Existence of Multiple Values in SQL #SQL #Database #Programming
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405723
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405723
Don't have an account? Find a server at joinmastodon.org
Feb 16, 2024
A Hidden Benefit of Implicit Joins: Join Elimination #Java #SQL #Database
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405731
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405731
Don't have an account? Find a server at joinmastodon.org
Jan 10, 2024
jOOQ 3.19's new Explicit and Implicit to-many path joins #Java #SQL #jOOQ
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405739
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405739
Don't have an account? Find a server at joinmastodon.org
Dec 28, 2023
Workaround for MySQL's "can't specify target table for update in FROM clause" Error #SQL #MySQL #Database
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405749
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405749
Don't have an account? Find a server at joinmastodon.org
Dec 20, 2023
jOOQ 3.19.0 Released with DuckDB, Trino, Oracle 23c support, join path improvements, an official gradle plugin, commercial maven repositories, policies, UDT paths, trigger meta data, hierarchies, and much more #Java #Database #OpenSource
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405760
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405760
Don't have an account? Find a server at joinmastodon.org
Dec 15, 2023
Maven Coordinates of the most popular JDBC Drivers #Java #Maven #SQL
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405769
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405769
Don't have an account? Find a server at joinmastodon.org
Dec 13, 2023
To DAO or not to DAO #Java #Database #SQL
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405776
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405776
Don't have an account? Find a server at joinmastodon.org
Dec 6, 2023
JDBC Connection URLs of the Most Popular RDBMS #Java #SQL #Database
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405787
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405787
Don't have an account? Find a server at joinmastodon.org
Dec 1, 2023
How to Generate Package Private Code with jOOQ's Code Generator #Java #Programming #CodeGenerator
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405798
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405798
Don't have an account? Find a server at joinmastodon.org
Jun 28, 2023
How to Pass a Table Valued Parameter to a T-SQL Function with jOOQ #Java #SQL #Database
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405808
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405808
Don't have an account? Find a server at joinmastodon.org
Apr 25, 2023
How to Turn a List of Flat Elements into a Hierarchy in Java, SQL, or jOOQ #Java #SQL #Programming
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405818
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405818
Don't have an account? Find a server at joinmastodon.org
Mar 24, 2023
3.18.0 Release with Support for more Diagnostics, SQL/JSON, Oracle Associative Arrays, Multi dimensional Arrays, R2DBC 1.0 #Java #SQL #Database
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405826
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405826
Don't have an account? Find a server at joinmastodon.org
Mar 8, 2023
How to use jOOQ's Converters with UNION Operations #Java #SQL #jOOQ
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405833
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405833
Don't have an account? Find a server at joinmastodon.org
Mar 2, 2023
How to Write a Derived Table in jOOQ #Java #SQL #jOOQ
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405842
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405842
Don't have an account? Find a server at joinmastodon.org
Feb 24, 2023
The Performance Impact of SQL's FILTER Clause #SQL #Performance #PostgreSQL
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405852
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405852
Don't have an account? Find a server at joinmastodon.org
Feb 6, 2023
Emulating Window Functions in MySQL 5.7 #SQL #Java #Database
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405860
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405860
Don't have an account? Find a server at joinmastodon.org
Jan 20, 2023
Why You Should Execute jOOQ Queries With jOOQ #Java #SQL #jOOQ
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405871
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405871
Don't have an account? Find a server at joinmastodon.org
Jan 18, 2023
jOOQ's R2DBC LoggingConnection to log all SQL statements #Java #SQL #Database
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405880
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405880
Don't have an account? Find a server at joinmastodon.org
Jan 17, 2023
When to Use jOOQ and When to Use Native SQL #Java #SQL #Programming
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405891
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405891
Don't have an account? Find a server at joinmastodon.org
Dec 8, 2022
LATERAL is Your Friend to Create Local Column Variables in SQL #SQL #Database #Programming
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405900
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405900
Don't have an account? Find a server at joinmastodon.org
Nov 4, 2022
Calling Procedures with Default Parameters using JDBC or jOOQ #Java #SQL #Programming
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405907
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405907
Don't have an account? Find a server at joinmastodon.org
Oct 21, 2022
Using jOOQ's Implicit Join From Within the JOIN .. ON Clause #Java #SQL #Database
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405916
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405916
Don't have an account? Find a server at joinmastodon.org
Sep 13, 2022
A Brief Overview over the Most Common jOOQ Types #Java #SQL #Programming
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405923
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405923
Don't have an account? Find a server at joinmastodon.org
Sep 6, 2022
How to Plot an ASCII Bar Chart with SQL #SQL #Database #Programming
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405932
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405932
Don't have an account? Find a server at joinmastodon.org
Sep 1, 2022
The Second Best Way to Fetch a Spring Data JPA DTO Projection #Java #Spring #SQL
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405941
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405941
Don't have an account? Find a server at joinmastodon.org
Aug 30, 2022
Cannot resolve symbol 'VERSION_3_17' in jOOQ generated code #Java #SQL #CodeGeneration
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405951
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405951
Don't have an account? Find a server at joinmastodon.org
Aug 30, 2022
jOOQ 3.17 Supports Implicit Join also in DML #Java #SQL #Database
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405961
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405961
Don't have an account? Find a server at joinmastodon.org
Aug 25, 2022
A Condition is a Field #Java #SQL #Programming
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405973
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405973
Don't have an account? Find a server at joinmastodon.org
Aug 24, 2022
The Many Ways to Return Data From SQL DML #SQL #Java #Database
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405983
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405983
Don't have an account? Find a server at joinmastodon.org
Aug 23, 2022
How to Integration Test Stored Procedures with jOOQ #Java #Testing #Database
Boost from your server
Enter the server your account is on. The post opens there so you can boost it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405992
Don't have an account? Find a server at joinmastodon.org
Favorite from your server
Enter the server your account is on. The post opens there so you can favorite it.
Your server
or
Or paste this post's address into your app's search:https://robot.villas/users/java_sql_and_jooq/posts/22405992
Don't have an account? Find a server at joinmastodon.org
Aug 22, 2022