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.
Questions tagged [spring-data-r2dbc]
412 questions
0
votes
0 answers
R2DBC using Collection as parameter repository`s method for compare with uuid[]
DataBase: R2DBC Postgres
I have a column model_id at table with type: uuid[].
create table t_job
(
id uuid default gen_random_uuid() not null
primary key,
model_id uuid[] not…
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
0
votes
0 answers
how to configurate r2dbc with yaml?
I am configuring r2db-mysql application with yaml ,
but its run error when i try to connect mysql
here is my yaml config
spring:
r2dbc:
url:…
Peng
- 653
- 8
0
votes
2 answers
Error on getting records by id using r2dbc
In sandbox project trying reactive webflux with springboot and postgres. I added r2dbc, created endpoints - get all records and post endpoints work, but appeared problem with requests which use path variable (get one record, or delete by id)
Here is…
Sam Fisher
- 746
- 2
- 10
- 27
0
votes
1 answer
Spring does not see repository during scan on app start
Have sandbox springboot app. Decided to try reactive approach, postgres is used as database, I added r2dbc to the project to make my repository reactive. Here is my code:
@SpringBootApplication
public class Springboot2Application {
public static…
Sam Fisher
- 746
- 2
- 10
- 27
0
votes
2 answers
How to Fetch Data and then Delete it from database using Spring Webflux?
Delete Operation is not working. How can i fetch data and then delete it in a functional way? The code successfully run but it is not deleting data in database.
Controller Class
@DeleteMapping("/deleteUserById/{userId}")
public…
AM0007
- 29
- 4
0
votes
0 answers
Failed to obtain R2DBC Connection with Oracle R2DBC driver
I try to connect to oracle db (v19) via oracle's r2dbc driver and spring data r2dbc but receive Failed to obtain R2DBC Connection error. Did not observe any item or terminal signal within 10000ms in 'Connection Allocation'
I suspect that my…
ilham
- 33
- 5
0
votes
0 answers
How do I check multiple conditions before registering user in Spring WebFlux?
How do I check if an email address OR username is taken within the pipeline?
I found this answer for checking just the username:
public Mono create(String username, String password) {
User user = new…
Drason
- 41
- 1
- 8
0
votes
1 answer
Spring R2DBC DatabaseClient execute custom delete query in PostgreSQL
Hi im trying to delete user by his id from a table in Postgres database.
Im using Spring and R2DBC and trying to use DatabaseClient.execute("sqlCommand") for my custom delete query:
import…
Baal
- 77
- 8
0
votes
2 answers
Parallel save giving a duplicate key error in Spring R2DBC
I am getting a duplicate key error from the database (MySQL) for the scenario I have explained below.
Background
I need to save an entity to my database, but the entity id is not managed/generated by my system, so it comes from 3rd party with an id…
Can Cinar
- 401
- 1
- 8
- 18
0
votes
1 answer
Saving json array into postgresql data using spring boot java API
I have a Json Array in my request object and POJO object, I need to save that jsonarray field into jsonb column in my postgresql table.
"productId": "1",
"product":[
{
"name": "PENCIL",
"quantity":"5"
}]
I am getting an…
developer
- 35
- 7
0
votes
1 answer
Subscribing to an empty Flux causes an infinite loop
I have a call chain that looks something like this:
public ResponseEntity> create() {
return ResponseEntity.ok(saveList());
}
public Flux saveList() {
if(list.isEmpty()) return Flux.empty();
return…
sornvru
- 91
- 9
0
votes
0 answers
How to find data more effectively after saving in R2DBC
I use Spring R2DBC with Webflux and calling save() and findById() like below.
public Mono create(CommentDTO commentDTO, AuthenticatedUser authenticatedUser) {
return commentRepository.save(Comment.builder()
…
tail
- 105
- 1
- 1
- 9
0
votes
1 answer
Spring R2DBC Multi Datasource with Spring Boot
I created a service that connects to two schemas (ex. fo_pgdb, if_pgdb) My issue is when the service queries the table in the if_pgdb schema it looks as though it is querying the table in the fo_pgdb schema. I have checked and hard coded the…
Tony Neves
- 7
- 2
0
votes
1 answer
IllegalStateException: Unable to create a ConnectionFactory for
When I tried with non-reactive approach as below, am able to get connection without any issues.
spring.datasource.url=jdbc:sqlserver://AAAAA1011.na.app.corp\\bbbb;databaseName=mydb;integratedSecurity=true;authenticationScheme=JavaKerberos
But when…
john
- 1