Spring R2dbc Example

The source code is updated to Spring Boot 4/Spring 7/Java 25.

Note

The Spring Boot 3 based version is tagged with a boot-3 tag.

This repository contains the latest changes in the Spring R2dbc(part of Spring Framework 5.3), Spring Data R2dbc 1.2 and Spring Boot 2.4.

I have created several R2dbc examples in the spring-reactive-sample repository since it was born. But Spring Data R2dbc evolved very quickly, thre are plenty of breaking changes introduced since Spring 5.2 and Spring Data R2dbc 1.2.

Compare to the Spring Data R2dbc 1.1, some breaking changes are notable.

• The old DatabaseClient in Spring Data R2dbc 1.1 was split into two parts, a simple new DatabaseClient is part of Spring framework, as an alternative of Jdbc.
• Another part of the old DatabaseClient is reorganized into a new class R2dbcEntityTemplate which acts as the role of JdbcTemplate.

Notes

• Introduction to R2dbc
• Working with Relational Database using R2dbc DatabaseClient
• Update: Accessing RDBMS with Spring Data R2dbc
• Data Auditing with Spring Data R2dbc
• Dealing with Postgres specific Json/Enum type and NOTIFY/LISTEN with R2dbc
• Building Chat Application with R2dbc and Postgres
• Persisting Binary Data into Postgres using Spring Data R2dbc
• Handling File Upload/Download with Spring WebFlux and Spring Data R2dbc
• Perform Complex Queries with jOOQ and R2dbc

Sample Codes

Spring Boot example

The following example projects are standard Spring Boot projects with Spring Boot autoconfiguration.

Example	Description
boot-entitycallbacks	Spring Data R2dbc BeforeConvertEntityCallback, AfterConvertEntityCallback, etc.
boot-testcontainers	Spring Data R2dbc @DataR2dbcTest with varied Testcontainers configuration.
boot	Spring Boot example with R2dbcRepository, R2dbcEntityTemplate and DatabaseClient
boot-oracle	Spring Boot with Oracle Example
boot-pg-json	Spring Boot Example with R2dbc Json and Postgres JSON/JSONB
boot-pg-notifier-listener	Spring Boot Example with Postgres Notifier/Listener
boot-komapper	Spring Boot Example with komapper ORM
boot-r2dbc-proxy	Spring Boot Example with R2dbc Proxy for SQL Logging
boot-filepart	Spring Boot FilePart example, Postgres bytea type mapping to byte[], ByteBuffer, R2dbc Blob
boot-r2dbc-migrate	R2dbc Migrate example
boot-auditing	Spring Data R2dbc Auditing example
boot-kotlin-co	Kotlin Coroutines example with CoroutinesRepository
boot-jooq	R2dbc and JOOQ example
boot-jooq-kotlin-co-gradle	R2dbc/JOOQ/Kotlin Coroutines and Gradle generator config example
bookstore	(WIP) An example to track the associations support of Spring Data R2dbc

Spring Examples

The following example projects use Spring Boot to manage the dependencies, but configure R2dbc/Data R2dbc from scratch.

Example	Description
connection-factories	R2dbc driver's ConnectionFactory examples for MySQL, H2, PostgreSQL, MSSQL, Oracle, etc
database-client	Spring R2dbc DatabaseClient example
data-r2dbc-entitytemplates	Spring Data R2dbc R2dbcEntityTemplate example
data-r2dbc-repositories	Spring Data R2dbc R2dbcRepository interface example

Reference

• pgjdbc/r2dbc-postgresql
• R2dbc spec
• A Practical Guide to MySQL JSON Data Type By Example
• Convert between Java enums and PostgreSQL enums
• Java & Postgres enums - How do I make them work together for update?
• How to delete an enum type value in postgres?
• Create a type if not exist Postgresql
• jOOQ#12218: Reactive transaction with Spring and R2dbc