417 questions
0
votes
0
answers
40
views
R2dbc Mssql Login with service account principal
I'm working on a spring webflux app. I've been connecting to an Azure SQl database using username/password.
Now I want to switch to Active Directory Service principal, I now have a client id, a client ...
0
votes
0
answers
106
views
Spring r2dbc - SQL Server support version
I’m working on a Spring Boot WebFlux project and I’m planning to use R2DBC to interact with Microsoft SQL Server. However, I’m having difficulty finding clear information on which version of SQL ...
1
vote
2
answers
247
views
R2DBC: Convert Integer to Boolean for Specific Column in Spring Data Entity
I am using Spring Data R2DBC with MySQL, and I'm facing an issue with type conversion when mapping a database column of type INT to a Boolean field in my entity.
Entity Definition:
import org....
1
vote
1
answer
183
views
@Trasactional annotation not working with webflux 3.3.2
We have recently started upgrading spring webflux version 2.7X to 3.3.2. After this upgrade, when we hit API with Postman it goes to controller layer and if service layer method is annotated with @...
1
vote
0
answers
311
views
Locking rows in DB using R2DBC PostgreSQL and Webflux
I have an issue when trying to concurrently select rows in postgesql database using R2DBC driver.
I have method that should create entity with order number based on total quantity of these entites in ...
0
votes
0
answers
67
views
r2dbc-postgresql calling a PLSQL function returning SETOF with TYPE has only one column
I am calling a POSTGRES PLSQL function from r2dbc, that returns a SETOF foo_type, where foo_type is a user-defined type. Basically this works, but the call returns rows with only a single String ...
0
votes
0
answers
49
views
AWS RDS DB Connection not restarting
In reactive spring boot service, use case is like we are trying to receive message from SQS and process it but we are observing that the db connections are getting closed once queue is empty and ...
-1
votes
2
answers
585
views
How to use CamelCase instead of SnakeCase in Spring JPA R2DBC
I need to access a legacy database that uses camelCase for both table names and column names.
I had hoped specifying @Table and @Column values with exact matches would work. But the values I specify ...
0
votes
1
answer
72
views
Unexpected behaviour when using spring data reactive repository saveAll() in WebFilter with response body
I would like to call a repository saveAll method in a WebFilter class, but when I return with a body populated ServerResponse the saveAll doesn't save anything in the DB. Returning without a body, the ...
0
votes
1
answer
310
views
Implementing Cursor-Based Pagination with R2dbc: Trouble with Backward Pagination Subquery
I'm trying to implement cursor-based pagination with a custom implementation using R2dbc. Forward pagination works fine, but backward pagination isn't working correctly.
The query for forward ...
0
votes
0
answers
76
views
R2DBC Core DatabaseClient.sql replacing column 'key' to '[*]key'
r2dbc.core.databaseclient.sql replace query that have column name 'key' to '[*]key' and this causes error in the query execution.
Mono<Map<String, Object>> first = db.sql("SELECT key ...
1
vote
1
answer
548
views
Spring r2dbc jOOQ transaction rollback not working
Transaction rollback does not seem to work when using r2dbc and jOOQ
DemoRepository
suspend fun insert(id: String) {
if (id == "b") {
throw RuntimeException("error while ...
0
votes
1
answer
446
views
Converter<Row, Entity> for spring data r2dbc not working
I try to implement one-to-one relationship query in @Query. The relevant table structure is as follows
@Table("t_author")
data class Author(
@field:Id
val id: Long,
var name: ...
1
vote
0
answers
397
views
How to elegantly manage transactions in Spring WebFlux with traditional database frameworks?
How to elegantly manage transactions in Spring WebFlux with traditional blocking database framework frameworks, such as JDBC, JPA, and MyBatis?
Some features of Spring Data R2DBC are not very good, so ...
2
votes
0
answers
236
views
Is it possible to use an Azure User Assigned Managed Identity to connect to an Azure SQL DB with an r2dbc driver?
I'd like to connect to an Azure SQL DB from a Spring Boot webflux (reactive) application deployed as an Azure Container App. Is it possible to connect to the Azure SQL DB using passwordless ...
2
votes
1
answer
3k
views
spring boot - r2dbc - webflux - postgre - bad SQL grammar
I started (with spring initializer) a simple Reactive (non-blocking) app...
But whenever try to make any query to postgres db always end up with: "org.springframework.r2dbc.BadSqlGrammarException:...
1
vote
0
answers
185
views
Spring reactive db (r2dbc) insert data multithread issue
I'm trying to insert data in parallel ,using spring r2dbc, to psql table
No matter how I run ,either in different connections or using the same connection and running in parallel batches/statements
...
0
votes
0
answers
484
views
Why is Blockhound detecting a blocking call after I added r2dbms to spring?
I added postgres support to my application, but when I try to run the tests, I keep getting a blocking call error from blockhound, and I'm not sure why this is happening. The application it's runs ...
1
vote
0
answers
238
views
Slice/Page method return Reference in R2DBC is invalid?
In a nutShell , when i try to use slice/page as method reuturn value in r2dbc , i encounter the error , below is two difference api reference and corrsponding error stack
Flux<Slice<Object&...
0
votes
0
answers
995
views
Unable to create R2DBC connection factory for mysql through auto configuration unless change scope of another dependency to runtime
java.version=17
spring-boot-starter-data-r2dbc=3.1.1
spring-boot-starter-webflux=3.1.1
I have specified the following in application.properties to be picked up by the auto configuration.
spring.r2dbc....
1
vote
0
answers
181
views
Upgraded from miku to asyncer r2dbc, facing autoconfigure error when compiling
I'm getting the following error after my upgrade when running @SpringBootTest and @AutoConfigureTestDatabase
No qualifying bean of type 'org.springframework.r2dbc.core.DatabaseClient' available: ...
0
votes
1
answer
3k
views
Could not open R2DBC Connection for transaction after resume connection to db
Recently discovered a problem such a problem. I am using a reactive application written in Spring boot 3.x. , r2dbc postgresql, spring webflux
At the time of processing the request, the connection to ...
1
vote
1
answer
1k
views
Using @modifying with spring r2dbc
As I understand you should use @Modifying whenever you write for example update query with @Query annotation, but I've seen many times people don't use that annotation when using R2dbcRepository or ...
0
votes
1
answer
2k
views
Generic way to handle nested objects in Spring Data R2DBC
In my Spring Boot Webflux project, I'm using Spring Data R2DBC for reactive data access. The project involves fetching data from a relational database, where some tables have columns containing JSON ...
0
votes
1
answer
1k
views
Google Spanner Deadline Exceeded with simplest queries
I'm using GCP+R2DBC in a Spring Boot application. This is a simplified version of my code:
public class WidgetDetailsCustomRepositoryImpl implements WidgetDetailsCustomRepository {
private final ...