R2dbc

1. The directory containing files of this external library is: installation directory\esProc\extlib\R2dbcCli. The Raqsoft core jar for this external library is scu-r2dbc-cli-2.10.jar.

async-common-1.1.4.jar

jasync-mysql-1.1.4.jar

jasync-pool-1.1.4.jar

jasync-r2dbc-mysql-1.1.4.jar

joda-convert-1.8.1.jar

joda-time-2.9.7.jar

kotlin-logging-1.7.6.jar

kotlin-stdlib-1.3.61.jar

kotlin-stdlib-common-1.3.41.jar

kotlin-stdlib-jdk7-1.3.61.jar

kotlin-stdlib-jdk8-1.3.61.jar

kotlinx-coroutines-core-1.3.2.jar

kotlinx-coroutines-jdk8-1.3.2.jar

lombok-1.18.12.jar

netty-buffer-4.1.49.Final.jar

netty-codec-4.1.49.Final.jar

netty-common-4.1.49.Final.jar

netty-handler-4.1.49.Final.jar

netty-resolver-4.1.49.Final.jar

netty-transport-4.1.49.Final.jar

netty-transport-native-unix-common-4.1.51.Final.jar

r2dbc-h2-0.8.4.RELEASE.jar

r2dbc-mssql-0.9.0.RC1.jar

r2dbc-spi-0.9.0.RELEASE.jar

reactive-streams-1.0.3.jar

reactor-core-3.4.0.jar

reactor-netty-0.9.11.RELEASE.jar

slf4j-api-1.7.26.jar

spring-aop-5.3.1.jar

spring-beans-5.3.1.jar

spring-context-5.3.1.jar

spring-core-5.3.1.jar

spring-data-commons-2.4.1.jar

spring-data-r2dbc-1.2.1.jar

spring-data-relational-2.1.1.jar

spring-expression-5.3.1.jar

spring-jcl-5.3.1.jar

spring-r2dbc-5.3.1.jar

spring-tx-5.3.1.jar

Note: The third-party jars are encapsulated in the compression package and users can choose appropriate ones for specific scenarios.

 

2. R2dbcCli requires a JRE version 1.8 or above. Users need to install a higher version if the esProc built-in JRE version does not meet the requirements, and then configure java_home in config.txt under installation directory \esProc\bin. Just skip this step if the JRE version is adequate.

 

3. Users can manually change the size of memory if the default size isn’t large enough. Under Windows, make the change in config.txt when starting esProc through .exe file; and in .bat file when starting the application through the .bat file. Make the modification in .sh file under Linux.

To modify the config.txt file under Windows:

java_home=C:\ProgramFiles\Java\jdk1.8.0_181;esproc_port=48773;btx_port=41735;gtm_port=41737;jvm_args=-Xms256m-XX:PermSize=256M-XX:MaxPermSize=512M-Xmx9783m-Duser.language=zh

 

4. On the machine where esProc is installed, find the hosts file to add the IP address and hostname of the machine holding the R2dbc database. For example, if the IP address and hostname are 192.168.0.8 and masters respectively, here are the settings:

 

5. esProc provides a number of external library functions, including r2dbc_open(), r2dbc_exec(), r2dbc_query() and r2dbc_close(), to access R2DBC. Look them up in【Help】-【Function reference】to find their uses.