Stack Overflow
Stack Overflow

Questions tagged [r2dbc-postgresql]

For questions regarding the PostgreSQL implementation of the R2DBC SPI. See also tags "r2dbc" and "postgresql".

Refers to the PostgreSQL implementation of the R2DBC SPI. Refer to the tag info for r2dbc for information on Reactive Relational Database Connectivity Service Provider Interface and refer to tag info for postgresql for information on PostgreSQL object-relational database management system.

103 questions
0
votes
2 answers

Testcontainers and r2dbc (password authentication failed for user "test")

I have a project that I would like to test using test container. However, when trying to initialize the database in the container, an error occurs Caused by: org.springframework.r2dbc.connection.init.UncategorizedScriptException: Failed to execute…
skyho
  • 1,438
  • 2
  • 20
  • 47
0
votes
1 answer

DB fields are not properly mapped to java objects when using reactive postgres r2dbc

I have a Spring Boot application with reactive stack (WebFlux). I work with PostgreSQL database using r2dbc driver. DB contains 2 records with all values present, but when I query I get empty fields. Below you can see the service response. [ { …
stakeika
  • 55
  • 1
  • 8
0
votes
0 answers

using postgesql DB with spring Boot application. app using r2dbc config to connect with DB. want to create jdbc config with r2dbc to connect same DB

r2dbc: url: r2dbc:postgresql://${DB.URL:}/${DB.NAME:}?currentSchema=${DB.SCHEMA.NAME:} username: ${DB.USERNAME:} password: ${DB.PASSWORD:} pool: enabled: true initial-size: 5 max-size: 100 jdbc-datasource: url:…
Sharafat Ali
  • 1
  • 1
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…
Amol Kshirsagar
  • 253
  • 3
  • 16
0
votes
0 answers

R2dbc postgresql data loss issue

I have a reactive kafka consumer which read the data and saves the data into postgresql db using reactive drivers. Sometimes some data gets missed to save in the database , without any error . However, I could see the data read by my kafka consumer…
developer
  • 35
  • 7
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…
Sujoy
  • 25
  • 3
0
votes
1 answer

How to write testcase for DatabaseClient of r2dbc spring-boot library?

I am having the below class @Repository public class ItemRepository { @Autowired DatabaseClient databaseClient; @Autowired private Environment queries; protected String sql(String key) { return…
Umang Kamdar
  • 33
  • 2
  • 6
0
votes
1 answer

How to handle null values for list using r2dbc ReactiveSortingRepository

I am using the R2DBC library with ReactiveSortingRepository and i am having the below query to fetch some data. @Query("SELECT DISTINCT item_id FROM item_table" + " WHERE year = :year" + " AND (:itemName IS NULL OR item_name…
Umang Kamdar
  • 33
  • 2
  • 6
0
votes
0 answers

R2DBC + spring : Failed to instantiate [io.r2dbc.pool.ConnectionPool]: Factory method 'connectionFactory' threw exception with message

When trying to initialize the application, I got an error. r2dbc + Caused by: org.springframework.beans.BeanInstantiationException: Failed to instantiate [io.r2dbc.pool.ConnectionPool]: Factory method 'connectionFactory' threw exception with…
skyho
  • 1,438
  • 2
  • 20
  • 47
0
votes
2 answers

Postgres r2dbc batch insert problems

I am trying to batch-persist a Flux-stream of articles into a Postgres r2dbc The application has two identical article tables (article_origin and article_destiny) The origin table has a million article which I try to batch-insert into the empty…
artsgard
  • 11
  • 1
  • 4
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

R2DBC with WebFlux: notifications receiving stops silently

everyone. So, I have a WebFlux application which uses a PostgreSQL database as a queue (LISTEN/NOTIFY). It works more or less fine; the problem is that at some point the DB notifications just stop arriving. The notifications listener is set up in…
Alex Kiselev
  • 552
  • 2
  • 7
  • 22
0
votes
0 answers

Interval to Duration coversion issue in Spring Boot

While using Reactive Relational Database Connectivity (R2DBC), I have written a method to convert Interval to Duration in Java, below is the implementation import io.r2dbc.postgresql.codec.Interval; import java.time.Duration; Duration…
Aditya Tiwari
  • 11
  • 1
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
0
votes
1 answer

How to query jsonb datatype (Postgresql) in java code using Spring webflux & R2dbc

I have postgresql db with below structure CREATE TABLE products ( id bigserial, name varchar(30) NOT NULL, owner_id bigint, pdata jsonb NOT NULL, PRIMARY KEY (id) ); Here pdata is of jsonb datType exmaple of pdata(jsonb…
Abdullah Imran
  • 259
  • 3
  • 13
1 2 3 4
5
6 7