Auto-configure jOOQ with R2DBC

[hantsy]

Jooq added official R2dbc support since 3.15 , see: https://blog.jooq.org/reactive-sql-with-jooq-3-15-and-r2dbc/

Add JooqAutoConfiguration for R2dbc support, including compatibility with the existing transaction, data types, converters etc.

[wilkinsona]

Recent jOOQ 3.x releases require Java 11 which makes upgraded problematic in 2.x where we have a Java 8 baseline. We may be able to look at this in 3.x.

[rajadilipkolli]

Since Springboot 3 has java 17 as base maybe it's time to relook

[hantsy]

jOOQ 3.18.0 is aligned with R2dbc 1.0 spec which is compatible with Spring Boot 3.x now, it is time to add R2dbc/Jooq Autoconfiguration.

[giger85]

Is there any update this issue?

[wilkinsona]

@giger85 No, I'm afraid not. We work in the open so updates will appear in this issue when we have them. Right now, the issue is in the 3.x milestone. This means that we hope to work on it for a 3.x release but do not know when that will be. We have other, higher priority, items to focus on at the moment.

[hantsy]

I have used jOOQ and R2dbc in a project for over one year, it is easy to integrate them in projects yourself.

Just need to create a DslContext bean that based on the R2dbc ConnectionFactory.

https://github.com/hantsy/spring-r2dbc-sample/blob/master/jooq-kotlin-co-gradle/src/main/kotlin/com/example/demo/domain/JooqConfig.kt

But unfortunately, the Spring tx, R2dbc context mapping, etc are not applied to jOOQ SQL execution.

Our strategy is only using jOOQ for complex query(across multiple tables, Db built-in functions, etc.), all create/update/delete and simple query operations use the existing Spring Data R2dbc.

[rajadilipkolli]

@giger85 No, I'm afraid not. We work in the open so updates will appear in this issue when we have them. Right now, the issue is in the 3.x milestone. This means that we hope to work on it for a 3.x release but do not know when that will be. We have other, higher priority, items to focus on at the moment.

Hi @wilkinsona , I guess it is time to check in 3.3 as we are starting new journey from today

[zhuangzibin]

@giger85不，恐怕不行。我们公开工作，因此一旦有更新，就会出现在这个问题中。目前，这个问题处于 3.x 里程碑中。这意味着我们希望为 3.x 版本进行改进，但不知道什么时候。我们目前还有其他优先级更高的项目需要关注。

你好@wilkinsona我想是时候入住 3.3 了，因为我们从今天开始新的旅程

hello!spring-boot-starter-jooq and spring-data-r2dbc can be configured automatically? In which version?