Stack Overflow
Stack Overflow

Questions tagged [r2dbc]

R2DBC (Reactive Relational Database Connectivity) is an SPI which enables interacting with SQL database servers by executing SQL statements using a non-blocking reactive programming model with the Java programming language.

R2DBC is a Java-based, open source data access technology.

This technology is an SPI (Service Provider Interface) for the Java programming language that defines how a client may access a database using reactive programming. It specifies SPI methods for executing queries using a non-blocking driver. R2DBC is oriented towards relational databases.

Online resources

379 questions
25
votes
5 answers

Log values of query parameters in Spring Data R2DBC?

In Spring Data R2DBC I can log SQL queries by using logging.level.org.springframework.data.r2dbc=DEBUG in the application.properties. However, this doesn't log the actual values that are bound as query parameters. How can I log the actual values…
Harold L. Brown
  • 8,423
  • 11
  • 57
  • 109
20
votes
2 answers

How to implement OneToMany, ManyToOne and ManyToMany with R2DBC in a project which previously used JPA?

I have to re-implement a few back-end services and one of the main requirement is to make the whole flow reactive. Previously the services used hibernate with PostgreSQL so the mentioned connections were provided by the framework. Since I have to…
gabkov
  • 342
  • 5
  • 9
19
votes
4 answers

R2DBC - Oracle Database Support

I found R2DBC when I was searching reactive relational database drivers, but I couldn't see any driver for Oracle DB. Does anyone have any information on whether to provide support?
Can
  • 191
  • 1
  • 4
18
votes
1 answer

How to join tables in r2dbc?

In java reactor, r2dbc. I have two tables A, B. I also have repositories for them defined. How can i get data made up of A join B? I only come up with the following approach: call databaseClient.select from A and consequently in a loop call select…
voipp
  • 1,243
  • 3
  • 18
  • 31
17
votes
2 answers

Why does Spring not provide reactive (non-blocking) clients for relational databases?

I've used Vert.x toolkit for creating reactive applications with support for relational DBs like MySQL and Postgres. I know Spring provides reactive support for some NoSQL DBs like Cassandra and Mongo but are they willing to provide the same for…
Mohamed Ibrahim Elsayed
  • 2,734
  • 3
  • 23
  • 43
15
votes
0 answers

r2dbc - This is likely a bug leading to unpredictable outcome

We use spring-data-r2dbc:1.3.2 and dev.miku:r2dbc-mysql:0.8.2.RELEASE and experience a strange issue in production. We don't understand what is the root cause and whether it is a recoverable or can really create unpredictable outcome (as the log…
Victor Perepelitsky
  • 196
  • 5
14
votes
4 answers

reactive repository throws exception when saving a new object

I am using r2dbc, r2dbc-h2 and experimental spring-boot-starter-data-r2dbc implementation 'org.springframework.boot.experimental:spring-boot-starter-data-r2dbc:0.1.0.M1' implementation 'org.springframework.data:spring-data-r2dbc:1.0.0.RELEASE' //…
lapots
  • 12,553
  • 32
  • 121
  • 242
12
votes
1 answer

How to fix "Consider defining a bean of type 'org.jooq.DSLContext' in your configuration." after update to jOOQ 3.15.0

In my Vaadin and Spring Boot application, I have updated from jOOQ 3.14.12 to 3.15.0. After this update my application is not starting up again. This is the error I get: *************************** APPLICATION FAILED TO…
McPringle
  • 1,939
  • 2
  • 16
  • 19
10
votes
1 answer

Is Micronaut Data with R2DBC a more scalable approach than classical “one thread per connection” model Micronaut Data JDBC

According to micronaut-data reactive guide, "... In the case of reactive execution and if the backing implementation is blocking, Micronaut Data will use the Configured I/O thread pool to schedule the query execution on a different thread. If the…
Jim C
  • 3,957
  • 25
  • 85
  • 162
10
votes
2 answers

How to configure schema for R2DBC PostgreSQL

I try to use Spring Data R2DBC with postgres. I know some configuration for url, username, password. spring.r2dbc.url spring.r2dbc.username spring.r2dbc.password Is there something for the schema? Any list of setting available?
robert trudel
  • 5,283
  • 17
  • 72
  • 124
9
votes
3 answers

How to execute multiple inserts in batch in r2dbc?

I need to insert multiple rows into one table in one batch. In DatabaseClient i found insert() statement and using(Publisher objectToInsert) method which has multiple objects as argument. But would it insert them in one batch or not? Another…
voipp
  • 1,243
  • 3
  • 18
  • 31
9
votes
2 answers

R2DBC unable to create connection with h2 protocol

I'm trying to leverage H2 for testing and have the following configuration in src/test/resources/application.yaml: spring: r2dbc: url: r2dbc:h2:file://testdb I have an empty test annotated with @SpringBootTest but when I run it I get the…
Jit B
  • 1,206
  • 14
  • 26
9
votes
6 answers

Database migrations with R2DBC

I am new to R2DBC (https://r2dbc.io/). I would like to know whether r2dbc's ecosystem has a database migration tool/framework. It seems Liquibase & Flyway depend on JDBC. Is there a plan for allowing those frameworks to support a r2dbc driver? Any…
balteo
  • 23,602
  • 63
  • 219
  • 412