JOOQ Demo

Spring Boot app with jOOQ

Reactive Fetching

Please refer https://www.jooq.org/doc/3.15/manual/sql-execution/fetching/reactive-fetching/ for details.

If you provide jOOQ with an io.r2dbc.spi.Connection or io.r2dbc.spi.ConnectionFactory, then the publishers will execute queries in a non-blocking fashion on an R2DBC driver.

对于Spring Boot应用来说，你只需要添加以下依赖：

<dependencies>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-r2dbc</artifactId>
    </dependency>
    <dependency>
        <groupId>org.mariadb</groupId>
        <artifactId>r2dbc-mariadb</artifactId>
        <version>1.1.2</version>
    </dependency>
</dependencies>

然后在application.properties中添加对应的R2DBC配置，如下：

# database r2dbc
spring.r2dbc.url=r2dbc:mariadb://127.0.0.1:3306/jooq
spring.r2dbc.username=root
spring.r2dbc.password=
spring.r2dbc.pool.enabled=true
spring.r2dbc.pool.initial-size=1
spring.r2dbc.pool.max-size=4

目前该该功能已经在Spring Boot 2.6.0中实现，关于Spring Boot 2.5.x的解决方法请访问 spring-projects/spring-boot#26439

References

• jOOQ: https://www.jooq.org/
• Beginning jOOQ: Learn to Write Efficient and Effective Java-Based SQL Database Operations https://learning.oreilly.com/library/view/beginning-jooq-learn/9781484274316/
• Spring Boot Starter jOOQ: https://docs.spring.io/spring-boot/docs/current/reference/html/features.html#features.sql.jooq
• Spring Boot Support for jOOQ: https://www.baeldung.com/spring-boot-support-for-jooq
• jOOX: https://github.com/jOOQ/jOOX
• JOOQ Data Abstractions Without Distraction - Devnexus 2022: https://www.youtube.com/watch?v=80xV7OPtsrA
• jOOQ Masterclass: https://learning.oreilly.com/library/view/jooq-masterclass
• A Brief Overview over the Most Common jOOQ Types: https://blog.jooq.org/a-brief-overview-over-the-most-common-jooq-types/
• Spring Boot with jOOQ and PostgreSQL: https://boottechnologies-ci.medium.com/spring-boot-with-jooq-and-postgresql-4a86378a4e5e
• jooq-meta-postgres-flyway: jOOQ PostgreSQL DDL database with Flyway migrations - https://github.com/sabomichal/jooq-meta-postgres-flyway
• jOOQ Transactions with Kotlin Context Receivers: https://www.youtube.com/watch?v=GLYL2bkNPjM
• The Sakila Database: https://www.jooq.org/sakila
• Working with jOOQ and Flyway using Testcontainers: https://testcontainers.com/guides/working-with-jooq-flyway-using-testcontainers/