jOOQ User Group

1–30 of 2288

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: New members 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

Yafl Wabei, Lukas Eder4

Sep 29

Error when using Table as SelectField together with "UNION ALL" and "ORDER BY" – am I building a non-correct SQL?

On Thu, Sep 28, 2023 at 4:19 PM Yafl Wabei <yafl....@gmail.com> wrote: On Thursday, 28

unread,

Error when using Table as SelectField together with "UNION ALL" and "ORDER BY" – am I building a non-correct SQL?

On Thu, Sep 28, 2023 at 4:19 PM Yafl Wabei <yafl....@gmail.com> wrote: On Thursday, 28

Sep 29

Yafl Wabei, Lukas Eder10

Sep 28

Confusing mapping behaviour when using Tables as SelectField

On Monday, 18 September 2023 at 14:01:18 UTC+2 Lukas Eder wrote: On Sat, Sep 16, 2023 at 2:10 AM Yafl

unread,

Confusing mapping behaviour when using Tables as SelectField

On Monday, 18 September 2023 at 14:01:18 UTC+2 Lukas Eder wrote: On Sat, Sep 16, 2023 at 2:10 AM Yafl

Sep 28

Stefan Sator, Lukas Eder3

Sep 27

Jooq vs Hibernate

Yes, thanks Lukas! On Monday, 25 September 2023 at 09:03:05 UTC+2 lukas...@gmail.com wrote: Hi Stefan

unread,

Jooq vs Hibernate

Yes, thanks Lukas! On Monday, 25 September 2023 at 09:03:05 UTC+2 lukas...@gmail.com wrote: Hi Stefan

Sep 27

Roger Thomas, Lukas Eder2

Sep 26

For generic questions, which possibly aren't even strictly related to jOOQ, and where the

unread,

For generic questions, which possibly aren't even strictly related to jOOQ, and where the

Sep 26

ry...@monoicon.com, Lukas Eder2

Sep 25

Formatting query result into different types

Hi Ryan, There's this feature request here, which would allow for registering Converter<T,

unread,

Formatting query result into different types

Hi Ryan, There's this feature request here, which would allow for registering Converter<T,

Sep 25

mukul panwar, Lukas Eder4

Sep 25

Jooq fetching always single records but table is having more records

Well, I think you'll have to use a debugger to step through the query execution. The answer is

unread,

Jooq fetching always single records but table is having more records

Well, I think you'll have to use a debugger to step through the query execution. The answer is

Sep 25

Stefan Sator, Lukas Eder5

Sep 21

Join same table twice with PostgreSQL

Yes that works. It was already clear from your answer. Thanks! On Wednesday, 20 September 2023 at 09:

unread,

Join same table twice with PostgreSQL

Yes that works. It was already clear from your answer. Thanks! On Wednesday, 20 September 2023 at 09:

Sep 21

Aravind Koonapureddy, Lukas Eder9

Sep 13

Status for Delete and Update operation.

As I said, I don't recall any change of behaviour in jOOQ with respect to update counts. Perhaps

unread,

Status for Delete and Update operation.

As I said, I don't recall any change of behaviour in jOOQ with respect to update counts. Perhaps

Sep 13

Juan Jose, Lukas Eder2

Sep 4

Id column isn't mapped to POJO

Hi Juan, Thanks for your message. I don't see anything wrong in your example code. You might have

unread,

Id column isn't mapped to POJO

Hi Juan, Thanks for your message. I don't see anything wrong in your example code. You might have

Sep 4

Yafl Wabei, Lukas Eder3

Aug 30

Problems with different column orders in the database

Hey Lukas, you're right. We do use the code generator and there is an Table.asterisk() query that

unread,

Problems with different column orders in the database

Hey Lukas, you're right. We do use the code generator and there is an Table.asterisk() query that

Aug 30

Aug 24

[ ANNOUNCEMENT ] jOOR 0.9.15 released with some minor improvements and fixes

jOOR 0.9.15 has been released and is available from Maven Central Full release notes here: https://

unread,

[ ANNOUNCEMENT ] jOOR 0.9.15 released with some minor improvements and fixes

jOOR 0.9.15 has been released and is available from Maven Central Full release notes here: https://

Aug 24

Ryan Short, … Lukas Eder4

Aug 22

Slow compile time for generated jooq classes

Thanks for the feedback. I've noticed this numerous times. Even on JDK 11 or later, turning that

unread,

Slow compile time for generated jooq classes

Thanks for the feedback. I've noticed this numerous times. Even on JDK 11 or later, turning that

Aug 22

Jarkko Miettinen, Lukas Eder4

Aug 11

Altering queries to contain tenant_id columns in multi-tenancy

On Thu, Aug 10, 2023 at 6:23 PM Jarkko Miettinen <eon...@gmail.com> wrote: Thanks! It seems

unread,

Altering queries to contain tenant_id columns in multi-tenancy

On Thu, Aug 10, 2023 at 6:23 PM Jarkko Miettinen <eon...@gmail.com> wrote: Thanks! It seems

Aug 11

Aug 10

[ ANNOUNCEMENT ] jOOQ 3.16.21, 3.17.15, and 3.18.6 patch releases with minor improvements and bug fixes

Version 3.16.21 - August 10, 2023 ===================================================================

unread,

[ ANNOUNCEMENT ] jOOQ 3.16.21, 3.17.15, and 3.18.6 patch releases with minor improvements and bug fixes

Version 3.16.21 - August 10, 2023 ===================================================================

Aug 10

Kevin Jones, … Per Lundberg8

Aug 7

Code Generation Directory

Aha, I see. This seems really weird. Would be interesting to figure out where the output goes, but I

unread,

Code Generation Directory

Aha, I see. This seems really weird. Would be interesting to figure out where the output goes, but I

Aug 7

Tomasz Burdka, … Sam S5

Jul 22

How to create custom binding from jOOQ Geometry to JTS Geometry

Hi Thomas, did you manage to get past this problem? I'm having similar issues. Best, S Op maandag

unread,

How to create custom binding from jOOQ Geometry to JTS Geometry

Hi Thomas, did you manage to get past this problem? I'm having similar issues. Best, S Op maandag

Jul 22

chri schneid, Lukas Eder2

Jul 20

Problems using having clause

Hi Christian, I don't see what is conceptually wrong with your query. What particular syntax

unread,

Problems using having clause

Hi Christian, I don't see what is conceptually wrong with your query. What particular syntax

Jul 20

Kevin Jones, … Lukas Eder5

Jul 17

Using a value in a 'like'

Hi Kevin, In addition to Alf's suggestion, you could also just use Field.contains(Field) I hope

unread,

Using a value in a 'like'

Hi Kevin, In addition to Alf's suggestion, you could also just use Field.contains(Field) I hope

Jul 17

minva, Lukas Eder2

Jul 11

Help dealing with postgis geometry column

Thanks for your message. We don't have a feature yet that allows you to transform projections and

unread,

Help dealing with postgis geometry column

Thanks for your message. We don't have a feature yet that allows you to transform projections and

Jul 11

Mark Amery, Lukas Eder4

Jul 3

Different handling of checked vs unchecked exceptions in DSLContext.transaction is unexpected when using jOOQ from Kotlin

You're maybe overlooking the fact that jOOQ is consistent with this behaviour throughout its API.

unread,

Different handling of checked vs unchecked exceptions in DSLContext.transaction is unexpected when using jOOQ from Kotlin

You're maybe overlooking the fact that jOOQ is consistent with this behaviour throughout its API.

Jul 3

ganeshra...@gmail.com, … Lukas Eder11

Jun 29

How to write Enum into a PostGres DB using JOOQ

Thanks for your hint, that'll be useful to some users. Please note that this will no longer be

unread,

How to write Enum into a PostGres DB using JOOQ

Thanks for your hint, that'll be useful to some users. Please note that this will no longer be

Jun 29

Rob Sargent, Lukas Eder3

Jun 23

release notices

On 6/23/23 08:32, Lukas Eder wrote: You can filter by whatever you want here: https://github.com/jOOQ

unread,

release notices

On 6/23/23 08:32, Lukas Eder wrote: You can filter by whatever you want here: https://github.com/jOOQ

Jun 23

Jun 23

[ ANNOUNCEMENT ] jOOQ 3.16.20, 3.17.14, and 3.18.5 patch releases with minor improvements and bug fixes

Version 3.16.20 - June 23, 2023 =====================================================================

unread,

[ ANNOUNCEMENT ] jOOQ 3.16.20, 3.17.14, and 3.18.5 patch releases with minor improvements and bug fixes

Version 3.16.20 - June 23, 2023 =====================================================================

Jun 23

Andrej Škufca, … Lukas Eder10

Jun 21

jooq pro - download from local gitlab package registry problem

Ah yes, I forgot. That's an entirely different namespace :-) In case you're a Stack Overflow

unread,

jooq pro - download from local gitlab package registry problem

Ah yes, I forgot. That's an entirely different namespace :-) In case you're a Stack Overflow

Jun 21

adithya kamath, Lukas Eder7

Jun 20

Qualify function not for jOOQ OSS?

But filtering by ROW_NUMBER() isn't keyset pagination, that's OFFSET pagination. jOOQ has

unread,

Qualify function not for jOOQ OSS?

But filtering by ROW_NUMBER() isn't keyset pagination, that's OFFSET pagination. jOOQ has

Jun 20

adithya kamath, Lukas Eder2

Jun 19

Optimistic lock test not working

Hi Adithya, Thanks for your message. I just spent quite some time trying to reproduce the issue and

unread,

Optimistic lock test not working

Hi Adithya, Thanks for your message. I just spent quite some time trying to reproduce the issue and

Jun 19

Apoorv Naik, … Lukas Eder8

Jun 16

Running queries in CompletableFuture.runAsync

Thanks for your message. I'll be happy to answer specific questions (related to jOOQ) in case you

unread,

Running queries in CompletableFuture.runAsync

Thanks for your message. I'll be happy to answer specific questions (related to jOOQ) in case you

Jun 16

George Wright, Lukas Eder2

Jun 14

Including jOOQ an an MSI generated by jpackage.

Hi George, I'm not sure if this is jOOQ specific? I've never used jpackage, so I can't be

unread,

Including jOOQ an an MSI generated by jpackage.

Hi George, I'm not sure if this is jOOQ specific? I've never used jpackage, so I can't be

Jun 14

Simon Martinelli, Lukas Eder8

May 30

Optimistic Locking and DAOs does not work

https://github.com/jOOQ/jOOQ/issues/15115 (an improved error message and javadoc on the

unread,

Optimistic Locking and DAOs does not work

https://github.com/jOOQ/jOOQ/issues/15115 (an improved error message and javadoc on the

May 30

Fabio Cechinel Veronez, Lukas Eder3

May 12

Question about ExecuteListener's fetchEnd method data

Thanks for the prompt response. I have just created an issue for it, see https://github.com/jOOQ/jOOQ

unread,

Question about ExecuteListener's fetchEnd method data

Thanks for the prompt response. I have just created an issue for it, see https://github.com/jOOQ/jOOQ

May 12

Search

Clear search

Close search

Google apps

Main menu