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
2
votes
0 answers

Spring r2dbc + actuator not collecting metrics

I have set up a Spring boot application using version 2.2.2.RELEASE with both spring-boot-starter-data-r2dbc and spring-boot-actuator-autoconfigure-r2dbc on the classpath. I am however unable to see any r2dbc metrics on the actuator endpoint, even…
Eduardo Bueno
  • 134
  • 1
  • 12
2
votes
1 answer

How to disable Postgres auto-commit in Spring Data R2DBC

I see that currently, you can disable auto-commit on Connection object. But when you work with Spring Data you don't have access to Connection object. Also, Postgres doesn't have this feature as part of the connection URL. Does anyone know how to…
Max Grigoriev
  • 1,021
  • 2
  • 13
  • 29
2
votes
1 answer

Can I use JDBC and R2DBC alongside each other in the same Spring application?

I have been working on a spring application for some time now and it has been using JDBC to retrieve data from my Postgres database server. Now my application has progressed to the point that it requires some reactive system to it. In my case, I am…
eyoeldefare
  • 2,136
  • 1
  • 15
  • 25
2
votes
1 answer

Spring + R2DBC: How to close DatabaseClient and TransactionalOperator?

I can create DatabaseClient and TransactionalOperator in my Spring Boot app using: @Autowired public App(ConnectionFactory factory) { DatabaseClient dc = DatabaseClient.create(factory); TransactionalOperator to =…
Ray Zhang
  • 1,411
  • 4
  • 18
  • 36
2
votes
0 answers

Best practices for managing Netty resources in WebFlux application with several Netty clients

Is there any best practices about managing Netty resources (EventExecutorGroup) in a reactive Application having several client libraries which are using Netty? Redis lettuce documentation states A vast part of Client resources consists of thread…
Roman M.
  • 45
  • 1
  • 7
2
votes
3 answers

ORM framework for reactive applications

I have been looking at spring-data-r2dbc for reactive DB access. But it seems it doesn't provide any ORM suppport, as stated on the project's page, it is not an ORM framework. Which options there are exist or planned to support ORM in reactive…
gnom_7
  • 71
  • 1
  • 7
2
votes
1 answer

ClassNotFoundException: org.springframework.data.repository.query.QueryMethodEvaluationContextProvider

Following the Getting Started with R2DBC video, I convert some of the repositories to reactive in an existing Spring Boot application with PostgreSQL as the database. The application works before the conversion. After I try to start up the…
vic
  • 2,548
  • 9
  • 44
  • 74
1
vote
0 answers

Exceptions with parallel queries while running in OpenShift

We're running a Spring Boot application with R2DBC MSSQL connection to an Azure SQL database. We addded a feature that basically does a JOIN in code (please disregard all performance issues here ;-)) and now we experience exceptions if this code is…
kschlesselmann
  • 91
  • 7
1
vote
0 answers

R2DBC repositpries do not work even for basic methods

I'm using Spring Boot, java 17 and Postgresql in my reactive web application. However even simplest methods like cardRepository.findAll(); return ERROR c.a.a.c.h.ControllerExceptionHandler - executeMany; bad SQL grammar [SELECT card.* FROM card]…
Sof
  • 13
  • 3
1
vote
1 answer

Using JOOQ DSLContext.transactionResult with setLocal

I am trying to set a local variable on Postgresql by using reactive way inside dslContext.transactionResult. I want to keep the user_id, the id of the user who changed the product table, in the product history table with the help of trigger. My…
Özlem Ulağ
  • 31
  • 4
1
vote
0 answers

How to use snowflakes in reactive applications or R2DBC support for snowflake?

To use postgres with reactive application, we can use - api 'io.r2dbc:r2dbc-postgresql:0.8.10.RELEASE' spring: r2dbc: url: r2dbc:postgresql://host:port/db Is there similar R2DBC support for snowflake? or How can we use snowflakes in reactive…
Amit Nayak
  • 583
  • 1
  • 6
  • 17
1
vote
1 answer

Difference between using JDBC and R2DBC connection for Jooq

The documentation for Reactive Fetching in Jooq mentions: Out of the box, all jOOQ provided publishers will block on the underlying JDBC connection, but if you provide jOOQ with a io.r2dbc.spi.Connection or io.r2dbc.spi.ConnectionFactory, then the…
SantaClara
  • 86
  • 1
  • 9
1
vote
1 answer

Spring Boot, R2DBC, Querydsl, query with parameter - MssqlBadGrammarException

When I run query with parameter Param, using directly SQLServer2012Templates everything works fine. [DEBUG] [||] com.querydsl.sql.AbstractSQLQuery, shows generated query with '?', but as I understand, it is not query sent to the SQL…
Adam Krawiec
  • 21
  • 1