I used to have the following working fine on 2.6:

<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-data-r2dbc</artifactId>
</dependency>
<dependency>
    <groupId>dev.miku</groupId>
    <artifactId>r2dbc-mysql</artifactId>
</dependency>

But since 2.7, I'm getting:

'dependencies.dependency.version' for dev.miku:r2dbc-mysql:jar is missing

I must have missed something in the R2DBC-related dependencies updates in 2.7, but I couldn't find my way out, what's the recommended Maven config for SpringBoot + R2DBC + MySQL? Is dev.miku:r2dbc-mysql still supported?

Perhaps related: - https://github.com/spring-projects/spring-data-r2dbc/issues/753 - https://github.com/spring-projects/spring-boot/issues/31015

Comment From: linghengqian

  • This is instead expected behavior, because according to https://github.com/r2dbc/r2dbc-bom/issues/53 , initializing a project via start.spring.io requires adding a version number to dev.miku:r2dbc-mysql, similar
<dependency>
     <groupId>dev.miku</groupId>
     <artifactId>r2dbc-mysql</artifactId>
     <scope>runtime</scope>
     <version>0.8.2.RELEASE</version>
 </dependency>
  • According to https://twitter.com/mp911de/status/1527570621210804224?s=20&t=DhIv6rS1z9k_RaXXFVxNMQ , I can't seem to contact the author of this dependency.

Comment From: sp00m

I see, fair enough, thanks for pointing me to these links I couldn't find.

It's indeed a bit concerning that this lib went silent since 0.8, I hope the author is doing alright.

Would you recommend moving to https://github.com/jasync-sql/jasync-sql then?

Comment From: snicoll

I've added a reference to R2DBC Borca in the release notes with a link to their release announcement. I am afraid we can't recommend what the next step should be. Please ask the R2DBC team.

Comment From: linghengqian

Should we explicitly add the version number to the dev.miku:r2dbc-mysql in the MySQL dependency at https://github.com/spring-io/start.spring.io to avoid the exception, because this Dependency not managed version number?

Comment From: wilkinsona

@linghengqian I've opened https://github.com/spring-io/start.spring.io/issues/921 to figure out what to do on start.spring.io.

Comment From: sp00m

Just a heads up, I've ended up using MariaDB's driver against our MySQL instances, worked like a charm. I'll keep an eye on the MySQL driver, thanks for the support 🙌

Comment From: linghengqian

Just a heads up, I've ended up using MariaDB's driver against our MySQL instances, worked like a charm. I'll keep an eye on the MySQL driver, thanks for the support 🙌

  • ~~As a reminder, there are known issues with testcontainer that use the Mariadb R2DBC driver to connect to MySQL Container, see https://github.com/jhipster/generator-jhipster/pull/18511 .~~ I misunderstood, no problem.

  • If someone could bring dev.miku:r2dbc-mysql to Oracle's MySQL forum, continue to discuss its future with the community, and point it there in this issue, it would be a better option.

  • update: My request about the R2DBC Driver post that I initiated on the MySQL forum's Connector/J, JDBC and Java has been hosted by the forum moderator approved, which is located in https://forums.mysql.com/read.php?39,704940,704940#msg-704940 , which is the first step.