r2dbc-mysql | R2DBC MySQL Implementation | Reactive Programming library

So after some research I found out the exception is returned if no columns are returned in r2dbc. Issue was either insert was not happening or jooq could not return generated key. Turns out its the latter and it's a known jooq issue its documented very well here https://github.com/jOOQ/jOOQ/issues/2943 but there is a workaround for returning the generated value which is what I wanted in the first place. so below is the refactored code and its working now.

It turns out to be a Spring boot issue. Please refer to the below git issue for the resolution

https://github.com/spring-projects/spring-data-r2dbc/issues/659

https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html says:

The tx_isolation and tx_read_only system variables have been removed. Use transaction_isolation and transaction_read_only instead.

You checked and discovered the server version is 8.0.17. This is more authoritative than the handshake headers message.

I recommend searching your classpath for any leftover jar files with old versions of the connector. You may have both version 8.0.26 of the connector and an older version that hasn't been updated to use the new option names.

I realized my mistake. I forgot to add .subscribe() to the method userRepository.save(user);

So the test method is:

By default WebClient runs with a connection pool. The default settings for the pool are 500 max connections and max 1000 pending requests. You have JMeter and try to simulate 10000 but you do not specify how you distribute the load. You may need to increase the max pending requests. Have a look at this documentation and this documentation.

If you want to configure the WebClient then you need:

Please, be aware of the second information tip in the Spring Data R2DBC documentation when they explain Query Methods:

R2DBC repositories internally bind parameters to placeholders with Statement.bind(…) by index.

Please, try to define your method as: