R2dbc

Read(110) Label: r2dbccli,

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 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. Two ways to manage memory under Windows are available: Change the memory settings in config.txt when starting esProc through the exe file; and in the .bat file when starting the application through the bat bile. Under Linux, change the memory size in the .sh file.

Below is the method of changing memory settings in config.txt under Windows:

java_home=C:\ProgramFiles\Java\jdk1.8.0_181;esproc_port=48773;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 inHelp-Function referenceto find their uses.