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

How to integrate liquibase with spring data reactive?

Have anybody tried to integrate liquibase with spring reactive stack? From what I've googled, liquibase still doesn't support r2dbc driver and it requires you to add both spring data jdbc & r2dbc dependencies. It works well with an empty project -…
0
votes
1 answer

R2DBC: Why are RowsFetchSpec operators (.all(),.first(),.one()) signal onComplete although record is stored in database?

I am using DatabaseClient for building a custom Repository. After I insert or update an Item I need that Row data to return the saved/updated Item. I just can´t wrap my head around why .all(), .first(), .one() are not returning the Result Map,…
safarione
  • 65
  • 7
0
votes
1 answer

Generate many other individual mono out of one originating mono with R2DBC and Reactor

I created a database sequence with an increment of 5, allowing me to reserve a range of values in memory, and dividing my number of access to the database by 5. ( my real life case is 100000 values) My R2DBC service will call R2DBC API and do a…
Mirak
  • 59
  • 9
0
votes
1 answer

Spring r2dbc composite support

It seems Spring r2dbc does not support Composite Primary Key / Embedded Classes. What other options or work around can be followed in this case? If i have a table which has Composite Key, then how can I get Flux of objects using partial key, may be…
Spartacus
  • 337
  • 4
  • 12
0
votes
1 answer

java.lang.IllegalArgumentException: MySQL only supports single generated value. jooq r2dbc

I am experiencing this issue java.lang.IllegalArgumentException: MySQL only supports single generated value. in all my insert queries not just this table. I am using jooq 3.15 and r2dbc. what could be the issue public Mono
martin kimani
  • 277
  • 8
  • 18
0
votes
2 answers

How to define schema name in @MappedEntity annotation for r2dbc

I have kotlin & Micronaut application connecting to postgresql using r2dbc for reactive approach r2dbc: datasources: default: schema-generate: NONE dialect: POSTGRES url: r2dbc:postgresql://localhost:5434/mydb username:…
Ryuzaki L
  • 37,302
  • 12
  • 68
  • 98
0
votes
1 answer

Enable R2DBC configuration only on demand

I'm working on a library that is consumed by some other project. The library offers database access through JDBC and I'd like to add support for R2DBC too in the same library. The consuming project should be able to switch between JDBC and R2DBC…
Liviu
  • 118
  • 14
0
votes
1 answer

Unexpected NoSuchMethodError RowMetadata.getColumnMetadatas() - In spite of correct dependencies

When running my application (Spring Boot 2.5.7) - after updating to spring-data-r2dbc 1.3.7, I get the NoSuchMethodError RowMetadata.getColumnMetadatas(). (I have also tried this with 1.4.0 - 1.3.7 is where the problem first surfaces.) In this…
0
votes
0 answers

Configure schema user in Oracle R2dbc

I have two users DBOWNER & DBUSER. DBOWNER will have right to all DDL commands and will create the tables in it. DBUSER has CURD rights on DBOWNER tables. From Oracle R2DBC I want to use DBUSER to perform data entry in tables inside DBOWNER.
DevC
  • 9
  • 1
0
votes
0 answers

Spring WebFlux - Return Custom Query Select

I am learning Spring WebFlux. I am trying to return a List from this query using the r2dbc repository that shows me the number of sales in each category. @Query("SELECT COUNT(sales.id)as salesnumbers, sales.type_contract as typecontract FROM sales"…
Joji
  • 3
  • 1
  • 3
0
votes
1 answer

Spring Boot WebFlux Kotlin R2DBC suspend pagination return type

webflux r2dbc repository No example was found to return the page object. Is there an appropriate way? Let me know if you have a good example. my service stack spring-boot webflux, r2dbc, mysql, kotlin repository interface…
0
votes
0 answers

java.lang.NoClassDefFoundError: Could not initialize class io.netty.handler.ssl.JdkSslClientContext

I am writing tests for flux streams and when I run the tests I get the error java.lang.NoClassDefFoundError: Could not initialize class.io.netty.handler.ssl.JdkSslClientContext. but when I check on the dependencies in the netty packages the class is…
martin kimani
  • 277
  • 8
  • 18
0
votes
1 answer

No qualifying bean repository with r2dbc postgres

I recently try to using r2dbc with postgres "0.8.8.RELEASE" (pg r2dbc maven dependecy) and spring boot "2.5.2" I declared following properties in my application.yml: spring: jpa: properties: hibernate: dialect:…
0
votes
0 answers

Not able to insert data in MSSQL using r2dbc (non spring)

I am new to r2dbc. I am trying to connect to MSSQL DB using R2DBC (non spring project) with reactor. It is not establishing the connection and also the data is not getting inserted into the table. I have tried by giving wrong table name as well, but…
pri
  • 49
  • 2
  • 5
0
votes
0 answers

Not persisting entity with thymeleaf, spting data and r2dbc

Im trying to create Skill entity through Thymeleaf form and post it: controller's endpoint @PostMapping("/add") public String addSkill(@ModelAttribute Skill skill){ log.info( " orly? "+ (skill== null)); log.info(skill.getName()…
tarmogoyf
  • 298
  • 3
  • 17