404 questions
-1
votes
1
answer
92
views
How exactly non-blocking database access work? [closed]
I am trying to understand how worker thread gets returned for other operations while there is still data-access query operation going on? How does it work in reactive libraries? For example- How does ...
- 888
1
vote
1
answer
72
views
Spring R2DBC save returns id null
I'm using R2DBC with R2dbcRepository in Spring Boot.
I have a table called Dispatches with Jakarta annotations but when I invoke the save() method on my repository the save method returns the same ...
- 33
1
vote
0
answers
70
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 ...
2
votes
0
answers
173
views
Resource Leak in R2DBC after spring boot upgrade
Since updating our project from Spring Boot 3.1.3 to Spring Boot 3.4.3, we have come across an unusual problem that we have not seen before.
We have a findAll() method that gets a Flux (of type Platz)....
- 13.4k
1
vote
0
answers
346
views
Can I safely use both JDBC and R2DBC with Exposed in the same Kotlin application without transaction context conflicts?
I'm building a Kotlin server-side application using Ktor, JetBrains Exposed ORM, and coroutines. The app interacts with two databases:
SQLite (used as a local read-only reference DB)
PostgreSQL (used ...
- 477
0
votes
0
answers
105
views
Mapping R2DBC query result for a row with a column of array postgresql type
Stack: Kotlin 2.1.21, Spring Boot 3.5.3, Spring Data R2DBC 3.5.1
I got the folowwing code
enum class TimeTypesEnum {
FULL, PARTIAL;
companion object {
fun from(value: String): TimeTypesEnum =
...
- 43
0
votes
1
answer
57
views
Is Oracle Transparent Application Continuity also possible with r2dbc? [closed]
We have an API written in Kotlin that connects to an Oracle database with ojdbc(and JPA). High Availability is guaranteed via the Oracle Transparent Application Continuity settings.
The API uses ...
2
votes
1
answer
65
views
How do I add conditions that possibly do not exist
There are some tables like the following in our system: locations, addresses, cities.
The locations has a address_id that refers to addresses, and addresses has city_id that refers to cities.
...
- 9,671
0
votes
1
answer
77
views
repo.save() and repo.findById() does not work within the save reactive pipeline
I am trying a trivial test with a basic Spring Boot 3.4 application and the reactive MS Server driver r2dbc-mssql.
repo.save(User.builder().name("Joe Smoe").build())
.doOnNext(...
- 13
0
votes
0
answers
137
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 ...
0
votes
1
answer
88
views
Select more aggregate roots in a single query using Spring Data R2DBC
I have an application in Spring Boot 3.4.x using Spring Data R2DBC.
Let's say I have two aggregate roots, Book and Author. I understand that from the reactive point of view, it is not possible to work ...
- 1,902
0
votes
1
answer
62
views
r2dbc throws 'url' attribute is not specified on graalVm native app
Does graalVm have issues with r2dbc working on postgres in Kotlin? I run the sample demo project from spring boot initializers (Kotlin, sping-boot 3.4.3, java 21), which has r2dbc dependency. When I ...
- 1,091
0
votes
0
answers
140
views
SpringData r2dbc vs jpa when saving a list of entities with the same ids
In Jpa Spring Data when using saveAll for entities with the same ids - saveAll successfully saves all the enitities into the database. For example
public interface JpaRepository extends JpaRepository&...
- 1,211
2
votes
1
answer
172
views
How to programmatically rollback transaction using Jooq Non blocking API?
It's not documented here https://www.jooq.org/doc/latest/manual/sql-execution/transaction-management/
It only shows you that an uncaught exception will cause a rollback.
The problem is that ...
- 3,313
2
votes
0
answers
118
views
Understanding N+1 Problem: Why does R2DBC handle JOINs differently than JPA?
I have a query that joins two tables (events and event_properties):
SELECT e.*, ep.*
FROM event e
JOIN event_properties ep
ON e.event_properties_id = ep.id
WHERE e.status = 0
In my R2DBC ...
- 284