Groups keyboard shortcuts have been updated

Dismiss

See shortcuts

jOOQ User Group

Contact owners and managers

1–30 of 2394

Welcome to the jOOQ User Group

This group is the official support, bug report, and feature request channel for www.jooq.org, as well as for our other products jOOλ, jOOR, jOOU, and jOOX

Further information can be found here:

Website: www.jooq.org
Blog: http://blog.jooq.org/
Download: http://www.jooq.org/download
Sources: https://github.com/jOOQ/jOOQ (Sources for jOOQ Express / Professional / Enterprise Editions available to licensed customers)

New Members: All messages are moderated to prevent Spam. Please be patient after posting, your message may not show up right away. Please join the group if you wish to post frequently, this will reduce moderation effort on Google Groups
Etiquette: Please consider the following useful document before posting here: http://www.apache.org/dev/contrib-email-tips.html

0 selected

Jan 8

[ ANNOUNCEMENT ] jOOQ 3.17.33, 3.18.24, and 3.19.17 patch releases with minor improvements and bug fixes

Version 3.17.33 - January 8, 2025 ===================================================================

unread,

[ ANNOUNCEMENT ] jOOQ 3.17.33, 3.18.24, and 3.19.17 patch releases with minor improvements and bug fixes

Version 3.17.33 - January 8, 2025 ===================================================================

Jan 8

12/10/24

[ ANNOUNCEMENT ] jOOQ 3.17.32, 3.18.23, and 3.19.16 patch releases with minor improvements and bug fixes

Version 3.17.32 - December 10, 2024 =================================================================

unread,

[ ANNOUNCEMENT ] jOOQ 3.17.32, 3.18.23, and 3.19.16 patch releases with minor improvements and bug fixes

Version 3.17.32 - December 10, 2024 =================================================================

12/10/24

Stefan Hoffmeister, Lukas Eder5

11/13/24

"insert or replace" sugar for row "onConflict()" upsert?

https://github.com/jOOQ/jOOQ/issues/16522 has been implemented. New methods, such as

unread,

"insert or replace" sugar for row "onConflict()" upsert?

https://github.com/jOOQ/jOOQ/issues/16522 has been implemented. New methods, such as

11/13/24

Bernd Huber, Lukas Eder4

11/4/24

Can / Should i (still) use jOOλ for Tuples

Thanks Lukas, i think my question is too specific to my concrete project, and it was not the right

unread,

Can / Should i (still) use jOOλ for Tuples

Thanks Lukas, i think my question is too specific to my concrete project, and it was not the right

11/4/24

11/4/24

[ ANNOUNCEMENT ] jOOQ 3.17.31, 3.18.22, and 3.19.15 patch releases with minor improvements and bug fixes

Version 3.17.31 - November 4, 2024 ==================================================================

unread,

[ ANNOUNCEMENT ] jOOQ 3.17.31, 3.18.22, and 3.19.15 patch releases with minor improvements and bug fixes

Version 3.17.31 - November 4, 2024 ==================================================================

11/4/24

k s, Lukas Eder4

10/29/24

How to Add Schema Name to Foreign Key Methods for Non-`main` Schemas in jOOQ's `MatcherStrategy`

Thank you for the response. I understand that this is a bug. For now, I'll try the suggested

unread,

How to Add Schema Name to Foreign Key Methods for Non-`main` Schemas in jOOQ's `MatcherStrategy`

Thank you for the response. I understand that this is a bug. For now, I'll try the suggested

10/29/24

Simon Martinelli, … Alf Lervåg4

10/28/24

CONCAT with single blank

Hi all, Didn't think about val and inline! Thanks for your help I use val: concat(ATHLETE.club().

unread,

CONCAT with single blank

Hi all, Didn't think about val and inline! Thanks for your help I use val: concat(ATHLETE.club().

10/28/24

Simon Martinelli, … Kian Farah10

10/28/24

springDao generates @null instead of @Transactional

Spot on! The DAO/Repository debate highlights the inherent complexity of these patterns. jOOQ's

unread,

springDao generates @null instead of @Transactional

Spot on! The DAO/Repository debate highlights the inherent complexity of these patterns. jOOQ's

10/28/24

Simon Martinelli, … Lukas Eder13

10/24/24

equals/hashCode in Pojos and Records

On Wednesday, October 23, 2024 at 2:09:13 PM UTC+2 simon.ma...@gmail.com wrote: IMO, that's the

unread,

equals/hashCode in Pojos and Records

On Wednesday, October 23, 2024 at 2:09:13 PM UTC+2 simon.ma...@gmail.com wrote: IMO, that's the

10/24/24

10/21/24

[ ANNOUNCEMENT ] jOOQ 3.17.30, 3.18.21, and 3.19.14 patch releases with minor improvements and bug fixes

Version 3.17.30 - October 21, 2024 ==================================================================

unread,

[ ANNOUNCEMENT ] jOOQ 3.17.30, 3.18.21, and 3.19.14 patch releases with minor improvements and bug fixes

Version 3.17.30 - October 21, 2024 ==================================================================

10/21/24

Kunal Ghosh, Lukas Eder7

10/21/24

Snowflake and Google BigQuery dialects

Hi Lukas, Yes, I haven't configured the SQLDialect with my jOOQ configuration. Thanks for your

unread,

Snowflake and Google BigQuery dialects

Hi Lukas, Yes, I haven't configured the SQLDialect with my jOOQ configuration. Thanks for your

10/21/24

Bernd Huber, … Rob Sargent8

10/18/24

Versioned REST-Api with CQRS - How to best use Jooq in this Scenario

again an update :) lombok somehow works, but its approach crumbles when wanting to support REST-Patch

unread,

Versioned REST-Api with CQRS - How to best use Jooq in this Scenario

again an update :) lombok somehow works, but its approach crumbles when wanting to support REST-Patch

10/18/24

Humaid Kidwai, Lukas Eder3

10/15/24

What is the right way to fetch ambiguous columns when joining multiple tables?

For the record, the question was cross-posted here, I suspect: https://stackoverflow.com/q/79076446/

unread,

What is the right way to fetch ambiguous columns when joining multiple tables?

For the record, the question was cross-posted here, I suspect: https://stackoverflow.com/q/79076446/

10/15/24

Nico van de Kamp, Lukas Eder2

9/30/24

Extend existing Kotlin\JOOQ query with two tables with two fields, one of them I get the error Type Mismatch: required List<DATACLASS> found unit

Hi Nico, Thanks for your message. jOOQ provides type safety up to degree 22, see eg the biggest type

unread,

Extend existing Kotlin\JOOQ query with two tables with two fields, one of them I get the error Type Mismatch: required List<DATACLASS> found unit

Hi Nico, Thanks for your message. jOOQ provides type safety up to degree 22, see eg the biggest type

9/30/24

9/26/24

[ ANNOUNCEMENT ] jOOQ 3.17.29, 3.18.20, and 3.19.13 patch releases with minor improvements and bug fixes

Version 3.17.29 - September 26, 2024 ================================================================

unread,

[ ANNOUNCEMENT ] jOOQ 3.17.29, 3.18.20, and 3.19.13 patch releases with minor improvements and bug fixes

Version 3.17.29 - September 26, 2024 ================================================================

9/26/24

Julian Backes, Lukas Eder4

9/25/24

Oracle problems when using RenderQuotedNames.EXPLICIT_DEFAULT_UNQUOTED

On Tue, Sep 24, 2024 at 6:57 PM julian...@gmail.com <julian...@gmail.com> wrote: When I

unread,

Oracle problems when using RenderQuotedNames.EXPLICIT_DEFAULT_UNQUOTED

On Tue, Sep 24, 2024 at 6:57 PM julian...@gmail.com <julian...@gmail.com> wrote: When I

9/25/24

9/23/24

[ ANNOUNCEMENT ] jOOQ 3.17.28, 3.18.19, and 3.19.12 patch releases with minor improvements and bug fixes

Version 3.17.28 - September 23, 2024 ================================================================

unread,

[ ANNOUNCEMENT ] jOOQ 3.17.28, 3.18.19, and 3.19.12 patch releases with minor improvements and bug fixes

Version 3.17.28 - September 23, 2024 ================================================================

9/23/24

marnix riphagen, Lukas Eder2

9/17/24

Oracle Multiple value insert generates invalid query

Hi Marnix, Thanks for your message. I assume you're using SQLDialect.ORACLE instead of the

unread,

Oracle Multiple value insert generates invalid query

Hi Marnix, Thanks for your message. I assume you're using SQLDialect.ORACLE instead of the

9/17/24

Kevin Jones, Lukas Eder6

9/13/24

SQLite Performance

Kevin, I never give any advice using universal quantifiers, such as "always" or "all

unread,

SQLite Performance

Kevin, I never give any advice using universal quantifiers, such as "always" or "all

9/13/24

Nico van de Kamp, Lukas Eder10

9/11/24

Try to convert an qouted query back to a more readable query, but I get now an error?

On Wed, Sep 11, 2024 at 2:37 PM Nico van de Kamp <nicova...@gmail.com> wrote: Only what

unread,

Try to convert an qouted query back to a more readable query, but I get now an error?

On Wed, Sep 11, 2024 at 2:37 PM Nico van de Kamp <nicova...@gmail.com> wrote: Only what

9/11/24

Florent Bonamis, Lukas Eder2

9/6/24

DLL code generation from oracle db

Hi Florent, I'll just guess what happened, because you didn't show: - Your code generation

unread,

DLL code generation from oracle db

Hi Florent, I'll just guess what happened, because you didn't show: - Your code generation

9/6/24

Stefan Hoffmeister, Lukas Eder2

9/2/24

varchar[] codegen support for DuckDB?

Thanks for your message. jOOQ 3.19.11 didn't support DuckDB 1.0 yet, and neither did we support

unread,

varchar[] codegen support for DuckDB?

Thanks for your message. jOOQ 3.19.11 didn't support DuckDB 1.0 yet, and neither did we support

9/2/24

Bernd Huber, … Alf Lervåg15

8/31/24

Jooq Codegenerator - Question about Java Records and Schema-Changes

Thank you, that's a good explanation and I see better where you're coming from. I definitely

unread,

Jooq Codegenerator - Question about Java Records and Schema-Changes

Thank you, that's a good explanation and I see better where you're coming from. I definitely

8/31/24

Jens Teglhus Møller, … Gaurang j5

8/29/24

Bad interaction between jooq and hikaricp

I did try to file a bug on the mysql driver (https://bugs.mysql.com/bug.php?id=109681), but they

unread,

Bad interaction between jooq and hikaricp

I did try to file a bug on the mysql driver (https://bugs.mysql.com/bug.php?id=109681), but they

8/29/24

Nico van de Kamp, Lukas Eder5

8/27/24

Convert SQL query to JooQ

I have found an solution... with (ChatGPT) override fun agendaInconsistencyCheck(zaakId: ZaakId):

unread,

Convert SQL query to JooQ

I have found an solution... with (ChatGPT) override fun agendaInconsistencyCheck(zaakId: ZaakId):

8/27/24

Nico van de Kamp, Lukas Eder7

8/26/24

Is working with a "derived" table possible with JooQ?

I mean this: .set(AGENDA_ITEM.BEGINTIJD, choose(agendaItem.itemType.naam.equals("value")) .

unread,

Is working with a "derived" table possible with JooQ?

I mean this: .set(AGENDA_ITEM.BEGINTIJD, choose(agendaItem.itemType.naam.equals("value")) .

8/26/24

Nakshatra Gupta, Lukas Eder2

8/26/24

How to Use Custom POJOs for Table and Column Classes with jOOQ's CLI Tool for Translating SQLite Queries to Java?

Thanks for your message and for your crosspost here: https://stackoverflow.com/q/78909241/521799 I

unread,

How to Use Custom POJOs for Table and Column Classes with jOOQ's CLI Tool for Translating SQLite Queries to Java?

Thanks for your message and for your crosspost here: https://stackoverflow.com/q/78909241/521799 I

8/26/24

8/13/24

[ ANNOUNCEMENT ] jOOQ 3.17.27, 3.18.18, and 3.19.11 patch releases with minor improvements and bug fixes

Version 3.17.27 - August 13, 2024 ===================================================================

unread,

[ ANNOUNCEMENT ] jOOQ 3.17.27, 3.18.18, and 3.19.11 patch releases with minor improvements and bug fixes

Version 3.17.27 - August 13, 2024 ===================================================================

8/13/24

Shyam, Lukas Eder2

8/5/24

Disambiguate table with name `object` in Jooq CodeGen

Thanks for your message. Let's discuss on your cross-posted question here: https://stackoverflow.

unread,

Disambiguate table with name `object` in Jooq CodeGen

Thanks for your message. Let's discuss on your cross-posted question here: https://stackoverflow.

8/5/24

Nico van de Kamp, Lukas Eder2

8/1/24

Does there exist an converter from SQL to JooQ code?

See my answer to your cross-posted question here: https://github.com/jOOQ/jOOQ/discussions/17004 On

unread,

Does there exist an converter from SQL to JooQ code?

See my answer to your cross-posted question here: https://github.com/jOOQ/jOOQ/discussions/17004 On

8/1/24

Search

Clear search

Close search

Google apps

Main menu