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
What's the proper way to convert a Flux object to Another Flux object and then save in Spring r2jdbc data repository?
In my project, I was trying to convert a Flux object to a different one and to save as a list of Flux. createPostTagsReactor() method uses convertToPost for some business logic.
@Test
public void creatPostTagsReactor(){
Map…
Monjur Morshed
- 84
- 3
- 9
0
votes
1 answer
How to do two delete operation based on condition in spring boot webflux?
I am trying to have a delete operation(r2dbc) using Webflux based on the condition as below, but switchIf empty is not working as expected. Specific Items are deleted successfully is getting printed always irrespective of filter condition satisfies…
sub
- 527
- 1
- 7
- 24
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
1 answer
How to do a join for every object in a Flux with a database call returning a Mono
I have two database calls one returning a Flux and another returning a Mono
The LegacyPerson class contains an legacyPersonId and a name.
The PersonKey class contains and legacyPersonId and a PersonID
I want to get as result an Mono
- where the…
Jacob
- 1
- 1
0
votes
1 answer
Spring Webflux - R2dbc : How to run a child query and update value while iterating a result set
I am new to Reactive repositories and webflux. I am fetching a list of data from DB, iterating it using map() to build a DTO class object, in this process I need to run another query to get the count value and update the same DTO object. When I try…
Siva Sakthi
- 21
- 8
0
votes
1 answer
readonly transaction with Spanner R2DBC and Spring Data
Is there a possibility to use read-only transactions with Spring Data R2DBC and especially with Google Spanner DB Backend? RO-transactions are supported in the Spanner R2DBC driver and offer much scalability advantage (no locking!). However, it is…
Kamil Roman
- 973
- 5
- 15
- 30
0
votes
1 answer
r2dbc:Calling Stored Proc in mysql with in and out parameters
Does r2dbc currently supports calling Stored proc in my sql with in/out parameters ?
I am trying to call Stored Proc using databaseClient which returns a String.But I am getting the below exception.Do I have to add anything to call SP from r2dbc.My…
Arnold
- 73
- 8
0
votes
1 answer
Spring data r2dbc error - Truncated incorrect DOUBLE value
I am using Spring data r2dbc and facing a strange issue.
implementation 'org.springframework.boot:spring-boot-starter-data-r2dbc'
runtimeOnly 'dev.miku:r2dbc-mysql'
runtimeOnly 'mysql:mysql-connector-java'
Getting error with update…
user1578872
- 7,808
- 29
- 108
- 206
0
votes
1 answer
Why Kotlin return Deferred<{Comparable & java.io.Serializable}> instead of Deferred?
Acording to intellij and gradle, this variable a type is Deferred<{Comparable & java.io.Serializable}>:
val a = async(IO) { possibleIdDeferred.await()?.also { repo.findAttrById(it) } ?: run { "" } }
where possibleIdDeferred is Deferred and…
rado
- 5,720
- 5
- 29
- 51
0
votes
1 answer
Cannot resolve method 'execute' in 'DatabaseClient'
I try to repeat the code from the course.
SQL queries should be created for initialization and run in public void setup(), but I faced with some problems:
Cannot resolve method 'execute' in 'DatabaseClient'
Reference to 'create' is ambiguous, both…
Daniel Ross
- 19
- 3
0
votes
1 answer
Always Encrypted with R2DBC
I trying to save to a table with encrypted fields but I cannot find R2DBC support.
Image of encrypted columns
Found a similar question but without using R2DBC
SQL Server Column Encryption using Azure Key Vault and Spring Boot
JDBC documentation it…
José López
- 1
- 1
0
votes
1 answer
[R2DBC-Spring-Data-kofu]:Expressing distinct in criteria API
Hello I try to convert a jpql query to the criteria api.
the sql query is
SELECT COUNT(DISTINCT id) FROM `user` WHERE login != :anonymousUser
I've just succeed to reach this query with criteria
SELECT COUNT(id) FROM `user` WHERE login !=…
cheroliv
- 113
- 4
- 10
0
votes
2 answers
encrypt parameter in sql server and sprig data r2dbc
I'm using Spring data R2DBC and I can connect in localhost my project with my database using this code:
public class R2dbcConfig extends AbstractR2dbcConfiguration {
private final ApplicationDatabaseProperties applicationDatabaseProperties;
…
chavalife17
- 162
- 1
- 2
- 10
0
votes
1 answer
Spring R2DBC - Connect to a SQL Server Database using Windows Authentication
trying to connect with MSSQL server with windows authentication using reactive(R2DBC) JDBC driver
#Data Source Configuration
spring:
r2dbc:
url: r2dbc:mssql://host:port
name: dbname
properties:
domain: xyz
…
jbaddam17
- 277
- 2
- 10
0
votes
1 answer
Multiple R2DBC datasource with Spring boot
I want to migrate my app to WebFlux, but the tricky part that I have bean which connects to 6 data sources by such mechanism
public class MultiRoutingDataSource extends AbstractRoutingDataSource {
@Override
protected Object…
Bohdan Myslyvchuk
- 1,657
- 3
- 24
- 39