If I use LcR2dbcRepository, I get the following error

[lecousin]

If I use LcR2dbcRepository, I get the following error

[lecousin]

Hi,
If you are using MySQL, you should do the following:

1. Add the dependency

<dependency>
  <groupId>net.lecousin.reactive-data-relational</groupId>
  <artifactId>mysql</artifactId>
  <version>0.4.1</version>
</dependency>

2. Add in your app a configuration class extending MySqlConfiguration, that has to provide the connection factory.

@Configuration
public class DBConfiguration extends MySqlConfiguration {

	@Override
	@Bean
	public ConnectionFactory connectionFactory() {
		return ConnectionFactories.get(
		    "r2dbcs:mysql://localhost:3306/bin-springreactive"
		);
	}
	
}

Can you try this ?

I keep this issue open, because I think we should provide a way to use the connection details from the application.yml instead of specifying it in the code

[lecousin]

Hi,

I made a new version and updated the README, to support configuration through application properties.

In order to use your connection configured in application.yml, you can upgrade your dependency to 0.4.2:

<dependency>
  <groupId>net.lecousin.reactive-data-relational</groupId>
  <artifactId>mysql</artifactId>
  <version>0.4.2</version>
</dependency>

And add this annotation to your application class (SpringDataR2dbcApplication):

@Import(MySqlConfiguration.class)

No more need to define the class DBConfiguration from my previous comment.

Can you confirm it solves your issue ?

Thanks for your feedback

[wang-xiaowu]

thanks
i'll try later

[lecousin]

As I didn't receive feedback, I'm closing this ticket because it has been answered. Please re-open if you still have an issue.