r2dbc-postgresql | Postgresql R2DBC Driver | Reactive Programming library

[Question posted by a user on YugabyteDB Community Slack]

I am currently using YugabyteDB with the reactive Postgres driver (io.r2dbc:r2dbc-postgresql), and I am facing some intermittent issues like this one, as you can see in the stack trace below. I was told that the Postgres driver may not deal correctly with the Yugabyte load balancing, which maybe is leading me to this problem, and then maybe the actual Yugabyte driver would deal properly with such scenarios. However, I am using a reactive code, which means I need an R2DBC driver, and I did not find any official R2DBC Yugabyte driver.

Do you think a more appropriate driver would really solve such problem? If so, is there any other R2DBC driver that would be more suitable for my purpose here? If not, do you have any suggestions to solve the problem below?

I have a simple application built on top of org.springframework.boot:spring-boot-starter-parent version 2.5.4-SNAPSHOT and some derived dependencies:

• org.springframework.boot:spring-boot-starter-data-r2dbc
• org.springframework.boot:spring-boot-starter-webflux
• org.springframework.boot:spring-boot-starter-actuator
• io.r2dbc:r2dbc-postgresql

I use org.springframework.experimental:spring-native version 0.10.3 to enable Spring Native and build using the following plugin:

I use jooq 3.15 with r2dbc in my Spring application and have a problem by fetching data from DB.

I use nu.studer.jooq with version 6.0.1 for set up jooq in my gradle file:

I've created a Java Spring Boot service using the WebFlux reactive module, H2 in-memory database, and R2DBC reactive driver.

When I run the service, it fails with an "Unable to create a ConnectionFactory" error:

I have an example SpringBoot app in Kotlin and WebFlux. I divided whole application into modules (as I'm used to from asp.net).

Modules:

• core (models, DTO, helpers, etc...) referenced everywhere
• data (repositories, tables...) referenced only in business
• business (services, handlers...) referenced in api
• api actual SpringBoot application

My problem now is how to properly work with ReactiveCrudRepository<> and repositories in general. I have config class in data module to enable R2dbcRepositories.

Hi everyone I am write Rest api project with R2dbc (non-blocking) but problem is table relation

Task model

There is not much information that I've found in terms of configuration with Netty and Webflux using HTTP2.

I have used similiar configurations in the past without using reactor based spring boot modules, typically spring boot web. I have posted my steps below.

The problem is SSL not working correctly with Netty. Do I require more work in terms of setup? Hoping to get some pointers or examples to understand how to confiure this correctly please.

Generated Certificate

• generate cert valid for local dev usage: mkcert localhost 127.0.0.1

• output: certificate localhost+1.pem key localhost+1-key.pem

• generate keystore with openssl: openssl pkcs12 -export -in localhost+1.pem -inkey localhost+1-key.pem -out keystore.p12 -name localdev

Application Files

application.yaml

r2dbc config:

...

I am trying to do my first steps in reactive programming with Spring Boot (2.3.4.RELEASE). So far I am trying to creating an infinte stream of persons in a service method which is called in a REST controller method but it ends with that exception: "java.lang.IllegalStateException: The generator didn't call any of the SynchronousSink method " I tried to google some solutions for a few hours but I haven't found any propper one which fits to what I am trying to do.

This is my service method: