Questions tagged [r2dbc-mysql]
30 questions
15
votes
0 answers
r2dbc - This is likely a bug leading to unpredictable outcome
We use spring-data-r2dbc:1.3.2 and dev.miku:r2dbc-mysql:0.8.2.RELEASE and experience a strange issue in production.
We don't understand what is the root cause and whether it is a recoverable or can really create unpredictable outcome (as the log…
Victor Perepelitsky
- 196
- 5
4
votes
1 answer
Mapping to JSON Fields with Spring Data R2DBC and Reactive MySQL Driver
I'm trying to use JSON data type to store json data in a specific column in a MySQL database.
I followed this guide, and got storing and reading JSON working fine but now I get this error when trying to save another entity that have a boolean…
Eyal Ringort
- 601
- 6
- 19
3
votes
2 answers
Spring data r2dbc: Problem connecting to MySQL - Repository bean not found
I am trying to integrate MySql to spring boot application using r2dbc driver. While doing so encountering issue wherein the repository bean is not getting created. I saw similar questions but the approaches mentioned in those didn't help.
Error…
Ananth
- 787
- 5
- 18
3
votes
3 answers
R2DBC - IllegalArgumentException: Cannot encode parameter of type java.util.Date
I'm learning Reative jdbc with R2DBC MySQL. I have a repository like this:
public interface VerificationTokenRepository extends ReactiveCrudRepository {
The VerificationToken class looks like this:
@Table
public class…
AleGallagher
- 1,745
- 7
- 30
- 40
3
votes
1 answer
Spring Data R2DBC custom conversions does not work with json array
I'm trying to get custom conversions of Spring Data R2DBC working to deal json_array fields.
I have a MySQL table created by the SQL below.
create table prefecture
(
id bigint unsigned auto_increment,
region_ids json not null,
…
shota hizawa
- 105
- 2
- 8
3
votes
1 answer
R2DBC can be used for change data capture in Spring boot?
I have a classic Spring Boot Application connected to a MySQL database.
Can I use r2dbc driver and spring data r2dbc to develop another application that listens to the database changes like a change data capture?
I've studied the r2dbc driver…
Michelantonio Trizio
- 252
- 3
- 16
2
votes
2 answers
Getting reactor.pool.PoolShutdownException during save in database
Service is using org.springframework.r2dbc.core.DatabaseClient with reactor-pool and r2dbc-mysql driver.
I'm doing inserts in the database every 5-10 seconds (50-100 insert statements) and randomly after every 2-3 hours I'm getting…
Vladlen Gladis
- 1,699
- 5
- 19
- 41
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
0 answers
Spring data r2dbc update
I have a table with non-auto generated primary key which is basically a foreign key.
So, using withId method as said in the documentation.
https://docs.spring.io/spring-data/r2dbc/docs/1.2.3/reference/html/#reference
Creating a new instance is…
user1578872
- 7,808
- 29
- 108
- 206
1
vote
1 answer
SpringBoot 3 Webflux R2DBC MySQL Timezone issue
I'm using r2dbc with mysql to connect DB for spring boot webflux service. My application.yml is below:
spring:
r2dbc:
url:…
Shakthi
- 826
- 3
- 15
- 33
1
vote
1 answer
how to insert multi values into one column?
I have a question of mysql java pojo. I try to insert multi values into one column. But the code throws null values. These sql queries are used not on jpa, but r2dbc spring webflux. As you know table realtionship is not supported in r2dbc driver, so…
Joseph Hwang
- 1,337
- 3
- 38
- 67
1
vote
5 answers
java.lang.Integer cannot be cast to class java.lang.Long in R2DBC mysql model classes
I use R2DBC MySQL driver in my Spring Webflux reactive web. And I try to execute table schema SQL script. But the script continuously cause errors.
First, I make 3 model classes.
User.java
@Data
@AllArgsConstructor
@NoArgsConstructor
@Builder…
Joseph Hwang
- 1,337
- 3
- 38
- 67
1
vote
2 answers
Spring boot upgrade from 2.6.6 to 2.7.1 - dev.miku:r2dbc-mysql
I am upgrading spring boot from 2.6.6 to 2.7.1 and running into r2dbc-mysql error.
With Spring boot 2.6.6, I am using r2dbc-mysql.
runtimeOnly 'dev.miku:r2dbc-mysql'
Getting compilation error after upgrading Spring boot to 2.7.1.
So, commented the…
user1578872
- 7,808
- 29
- 108
- 206
1
vote
0 answers
Spring boot 2.7 webflux r2dbc use jasync-r2dbc-mysql
When I upgrade my project from spring boot 2.6.6 to 2.7.0, use r2dbc will got the error like this:
2022-06-16 12:40:51.655 [][][ERROR][][db-sql-netty-thread-2] - Operator called default onErrorDropped
java.lang.AbstractMethodError: Method…
J. Hu
- 53
- 8
1
vote
0 answers
Nested entities in spring webflux
I am trying to use nested entities in spring webflux.
I have an object User :
@Table
public class User {
@Id private Long id;
private String firstname;
private String lastname;
...getters, setters, constructors
}
And an object…
Jots
- 19
- 4