Stack Overflow
Stack Overflow

Questions tagged [spring-data-r2dbc]

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.

412 questions
2
votes
0 answers

How to gerenate custom id in spring data r2dbc?

When I have many entities and I want to use custom id generators (for example snowflake) with different sequences for each entity, should I write the corresponding generator in each entity or write all the id generators in one configuration class or…
周晨阳
  • 21
  • 1
2
votes
1 answer

Spring, H2, R2DBC and Liquibase: /.testdb.trace.db: Read-only file system

When trying to start a Spring Boot application for tests (with H2 database) with R2DBC and Liquibase configured, I get the following error: 2022-10-04 12:50:18.893 INFO 57774 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished…
eeqk
  • 3,492
  • 1
  • 15
  • 22
2
votes
1 answer

Make jpa and coroutine repositories/r2dbc co live in spring boot application

I'm working on kotlin/spring boot application and my main target is to make it reactive. For now this application use plain JpaRepository for data access and what I'm trying to do is to slowly rework repositories to use CoroutineCrudRepository, one…
mr.nothing
  • 5,141
  • 10
  • 53
  • 77
2
votes
3 answers

Bad SQL grammar - Spring data R2DBC with Oracle

I'm using Spring Data R2DBC with Oracle 11g and I have the following error using method findById of R2dbcCrudRepository executeMany; bad SQL grammar [SELECT GAME_PHASE.* FROM GAME_PHASE WHERE GAME_PHASE.ID = :P0_id FETCH FIRST 2 ROWS ONLY] This is…
Alessio Fiore
  • 467
  • 1
  • 7
  • 18
2
votes
0 answers

ReactiveCrudRepository Criteria Query

I want to discuss a bit further the usage of Criteria and ReactiveCrudRepository. Spring data r2dbc supports query by example. Which in many cases is too limited. For example, all types other than String are exact-match only. Navigating the issues…
João Verissimo Ribeiro
  • 51
  • 4
2
votes
2 answers

WebFlux Spring Boot @Transactional with reactive MongoDB

Does WebFlux Spring Boot @Transactional annotation work with reactive MongoDB? I use WebFlux Spring Boot with reactive MongoDB like: id 'org.springframework.boot' version '2.6.7' ... implementation…
Mikhail Geyer
  • 881
  • 2
  • 9
  • 27
2
votes
1 answer

Oracle R2DBC query hangs / never completes

I am using Oracle r2dbc in my Spring Boot application. I have a DatabaseClient set up and when I call: databaseClient.sql("select ...").fetch().one().block(); The function never returns. It just hangs forever. Why is this?
Alexander Taylor
  • 16,574
  • 14
  • 62
  • 83
2
votes
1 answer

How to zip nested lists with reactor and R2dbc

I have 3 tables in a postgres data base and am using R2dbc to query and connect them in a relational manner. I have 3 entity classes (possibly shouldn't be data classes, but shouldn't effect the example) @Entity @Table(name = "parent", schema =…
AlexJ
  • 39
  • 7
2
votes
1 answer

Spring Boot and R2DBC: io.r2dbc.spi.R2dbcNonTransientResourceException: Connection validation failed

I'm using Spring Boot 2.4.9 with WebFlux and R2DBC, deployed using the standard Netty server. The database is PostgreSQL. There is only one R2DBC repository class in the app. R2DBC is configured in application.properties with these…
user3303372
  • 761
  • 1
  • 10
  • 21
2
votes
2 answers

Unknown system variable 'tx_isolation' when using spring R2DBC to connect with a mySQL server version 8

I created a new spring boot project using the IntelliJ Idea's spring initializer and checked the Web/Spring reactive Web and the SQL/Spring data R2DBC dependencies. I also added the the dependency to the R2DBC implementation for MySQL …
Readren
  • 994
  • 1
  • 10
  • 18
2
votes
0 answers

Spring data r2dbc blob - Blob data handling

I am using Reactive Spring Boot 2.5.4 with MySQL data source. I am not sure how to read/write blob with Spring data r2dbc. Table - user_note Columns - id, name, description Here, description column is a blob data type. My Domain class: class…
user1578872
  • 7,808
  • 29
  • 108
  • 206
2
votes
1 answer

Spring R2DBC - Getting "Table already exists" error while creating h2 table using schema.sql and ConnectionFactoryInitializer

Getting the error "Table Customer already exists" when i tried to create a table in H2 in memory database using schema.sql. I am using spring boot version: 2.5.4 and below is my pom.xml. It works fine if i use spring boot version: 2.4.3
Deedai
  • 125
  • 1
  • 9
2
votes
1 answer

where can I find documentation of r2dbc metrics?

Where can I find in depth descriptions of the r2dbc metrics? Specifically I try to understand what exactly these…
Stuck
  • 11,225
  • 11
  • 59
  • 104
2
votes
3 answers

Filtering query with R2DBC

I need do a filtering query with some query parameter. I need that if the query parameter is null, the condition of the query (= or LIKE, for example) is not evaluated and return me everything. I'm using R2DBC and I don't find a way to solve it.
Gianni Mirabello
  • 21
  • 3
2
votes
2 answers

r2dbc-pool connection not released after cancel

I have a strange behaviour with R2DBC Pool: We happen to create a large number of threads and send them to the R2DBC pool to acquire a DB connection. When all of the R2DBC connections from the pool are in use, the threads that we created queue for…
StephaneMarc
  • 21
  • 1
  • 2
1 2 3
…
27 28