Questions tagged [spring-data-r2dbc]

Spring Data R2DBC is a module of Spring Data based on R2DBC R2DBC stands for Reactive Relational Database Connectivity.

See https://spring.io/projects/spring-data-r2dbc for more information.

412 questions
0
votes
1 answer

Validation query for R2DBC remains Idle when connection pool created using io.r2dbc.pool.ConnectionPoolConfiguration

I have a spring webflux application integrated with AWS Aurora Postgres. spring-boot-starter-webflux:2.6.6 spring-boot-starter-data-r2dbc:2.6.6 This brings in the below…
0
votes
0 answers

How to execute two queries simultaneously(in asynchronous manner) using r2dbc in reactive java

The ask is : to run a SELECT statement (with offset and limit) to run a COUNT statement (without offset & limit) Now, we want to run these two queries at once in r2dbc in an asynchronous manner(so that we send and get the result in same time, not…
0
votes
1 answer

How to perform simple streaming queries using Spring R2DBC?

I am looking for the equivalent of jdbcTemplate.queryForStream using R2DBC. I'm new to R2DBC, but this sounds like an ideal use case for it. So far all I can find are examples of how to use spring-data-r2dbc for a JPA-like experience. This is really…
Jake
  • 321
  • 3
  • 12
0
votes
1 answer

mono of map to flux conversion

I want to convert a Mono of map to flux . can anyone help me on that please? The object that I have is something like Mono> where map key is the project key From this mono I want to construct a flux of project which is…
0
votes
0 answers

R2DBC SQL mapper conversion

I have two tables in my use case.. Project Task A project can have multiple task associated with that project. In task table I have FK relationship with project table, simple M:M relationship. As in R2dbcRepository we do not have JPA support for…
0
votes
4 answers

Spring boot 3 and io.r2dbc -- Cannot encode parameter of type io.r2dbc.spi.Parameters$InParameter

I upgraded my application from Spring Boot 2.7.8 to 3.0.5 and I am facing problems with binding parameters in DatabaseClient. It is a spring gateway application which uses ReactiveSessionRepository. Here is the code: My pom:
ccc134
  • 1
  • 3
0
votes
0 answers

Getting "Access Denied for user (using password: YES ) " while using AWS RDS IAM based authentication for R2DBC

After 15 mins once my application is started, getting Access Denied to user <> : Using password YES Connector JAR used: org.mariadb:r2dbc-mariadb:1.1.2 I understand this is an open feature request:…
0
votes
0 answers

R2dbc bind does not work with onErrorResume

I'm trying to save a record public Mono save(Post p) { return databaseClient.sql("INSERT INTO posts (title, date, content) VALUES (:title, :date, :content)") .filter((statement, executeFunction) ->…
Inessa
  • 27
  • 3
0
votes
0 answers

How to do batch saveAll with R2BDC

I am using R2DBC Springboot framework to perform my data extraction/insertion. I noticed that when i tried to perform the query below, it is not saving the records in parallel but sequentially. Saving record takes more than 25 minutes to save 2…
Ugine
  • 143
  • 8
0
votes
0 answers

Spring Data R2DBC Reactive - return String value from a simple query

Basically I have a simple select statement but instead of returning a Mono to the controller, I first want to check if it really returned the String (surname) of this user but instead when trying to get the String it throws an Exception. Code is…
0
votes
0 answers

"Unsupported array type" while saving object with one to many relation

I have two entities User and UserAuthority with one to many relation like following @Getter @Setter @Table(name = "users") @Entity public class User extends BaseEntity { @OneToMany(mappedBy = "user") private Set
0
votes
0 answers

Cannot read Postgis Geography data type in R2DBC

I am using PostGIS Geography type in my R2DBC Repository with custom Reader but even then I am getting this error. Cannot decode value of type io.r2dbc.postgresql.codec.Point with OID 25281 This is my build.gradle.kts dependencies { …
nicholasnet
  • 2,117
  • 2
  • 24
  • 46
0
votes
0 answers

Spring Data R2dbc Explicit Converter never called

I have the following model: @Table("organisation") public class OrganisationModel { @Id @Column("id_organisation") private OrganisationId id; @Column("id_parent") private OrganisationId parentId; } The IDs in the database are Integers.…
stg93
  • 1
  • 1
  • 1
0
votes
0 answers

How to make this r2dbc url?

Properties: Name: app_port_poc hostname: greshamdevdb01.global.trafigura.com port: 1521 service name: greshamdev01.global.trafigura.com My application in running in dev profile. application-dev.yml: r2dbc: url:…
0
votes
1 answer

How to map PostgreSQL 'infinity' value to LocalDateTime in Spring Data R2DBC?

How to map PostgreSQL 'infinity' value to LocalDateTime in Spring Data R2DBC? Java field, private LocalDateTime expireOn; In the database, it is auto-generated when there is no value or a null value passed from API.
Thirumal
  • 8,280
  • 11
  • 53
  • 103