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
1 answer

How to Join multple table in R2DBC and Spring WebFlux?

//1. Person Entity class Person { private Integer id; private String name; Private Address addId; } //2. Address Entity class Address { private Integer addId; private String city; Private String state; Private String…
Vivek Pandey
  • 1
  • 1
  • 1
0
votes
1 answer

How to get results of select query in postgresql r2dbc?

I can execute this query just fine but I don't know how to extract the information returned by the select statement. Flux checkTableQuery = connectionMono.flatMapMany(connection -> connection .createStatement("select exists(\n"…
Adarsh
  • 11
  • 2
0
votes
1 answer

fetch specific attribute without @Query in repository

Having this entity: data class Avatar( // id is generated by postgres default value @Id val id: UUID? = null, val userId: Long, var avatar: ByteArray, ) and this schema: CREATE TABLE avatar ( id uuid PRIMARY KEY…
Stuck
  • 11,225
  • 11
  • 59
  • 104
0
votes
0 answers

How do I save two times in one request using webflux and r2dbc?

I use webflux with r2dbc. I try to save in two tables in one service, but there is only one actual save. There may be a way to do flatmap twice in the handler, but I want to use transaction in service. Handler.java Mono…
HooMin.Lee
  • 115
  • 1
  • 8
0
votes
1 answer

How R2DBC Statement.fetchsize exaclty works

I am using the r2dbc-postgresql driver. Let's say we have a table with 1000 records and the fetchSize is 100: connectionMono.flatMapMany( connection -> connection .createStatement("select age from users") …
lkatiforis
  • 5,703
  • 2
  • 16
  • 35
0
votes
1 answer

Flux returning only one value instead of all values

I have an issue with the following code whereby it only returns the first result for each table. @Service @Slf4j @Lazy @AllArgsConstructor public class QuizQueryService { R2dbcEntityOperations client; @Transactional(readOnly = true) public…
Davide Pugliese
  • 366
  • 7
  • 16
0
votes
1 answer

R2DBC maps to do relationships between tables in a database

How to use maps in spring data R2DBC, to take map tables/entities with relationships received/sent to a database? Using r2dbcCustomConversions, @WritingConverter and @ReadingConverter. Someone could give.some.example? Thanks a lot
GtdDev
  • 748
  • 6
  • 14
0
votes
1 answer

Change spring data r2dbc context to use R2dbcRepositories in a different database

How can I change spring data r2dbc repositories target-datatabase (maybe I am talking about 'Context')? Let me explain better. I am managing(ConnectionFactory Properties) 'connection factory' to execute SQL-DDL scripts in any database I want - OK;…
GtdDev
  • 748
  • 6
  • 14
0
votes
0 answers

Hibernate not found table in schema

I have a bit a problem, I have several microservices, but one throws an exception that others don't throws and work perfect ... [2020-09-28 16:55:38.304]|ERROR|TIBCO EMS Session Dispatcher…
Adrien Ruffie
  • 195
  • 4
  • 16
0
votes
1 answer

r2dbc postgres driver - how to extract PostgresqlConnection from PooledConnection

Hi, my Spring Boot application has r2dbc connection pool autoconfigured using a property file: spring.r2dbc.url=r2dbc:pool:postgres://localhost:5432/ecom spring.r2dbc.username=xxx spring.r2dbc.password=yyy Now I need to get…
Jacek Kurasiewicz
  • 1
  • 1
0
votes
0 answers

Numeric types mapping issue in Spring Data R2dbc with postgres

I tried to use Spring Data R2dbc/Postgres in a sample application. Spring Boot 2.4.0-M2 R2dbc Postgres (managed by Spring Boot) Spring Data R2dbc 1.2.0-M2(managed by Spring Boot) The table scripts. CREATE SEQUENCE IF NOT EXISTS…
Hantsy
  • 8,006
  • 7
  • 64
  • 109
-1
votes
1 answer

R2dbc integration test persisted data not available via API

I am trying to learn Spring web flux with r2dbc. I am trying to execute a test case as follows: Save the data by calling the save method directly via a repository bean. Fetch the saved data by invoking the API using the webflux test client. Step…
Munish Dhiman
  • 511
  • 1
  • 7
  • 22
-1
votes
1 answer

How to connect to postgres and execute query using r2dbc

I'm trying to write a simple function which will connect to postgres and execute a select statement. PostgresqlConnectionFactory connectionFactory = new PostgresqlConnectionFactory( PostgresqlConnectionConfiguration.builder() …
Santosh Hegde
  • 3,420
  • 10
  • 35
  • 51
1 2 3 4 5 6
7