r2dbc_open()

Read(128) Label: open, cursor,

Description:

Connect to R2DBC and return a cursor.

Syntax:

r2dbc_open(url)

 

Note:

The external library function connects to R2DBC to access databases, including H2, MariaDB, MySQL, Oracle, Postgresql and SQL server.

When connecting to R2DBC to try to access H2, “options=DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE” in the URL cannot be omitted, otherwise there will be error about the table under handling.

Parameters:

url

The URL for accessing a database, whose format is r2dbc:dbtype://<host>:port/<database>

Return value:

A cursor

Example:

 

A

 

1

=r2dbc_open("r2dbcs:mysql://root:123456@127.0.0.1:3306/mytest")

Connect to mysql database

2

=r2dbc_open("r2dbc:h2:mem:///testdb?options=DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE")

Connect to H2 database

3

=r2dbc_open("r2dbc:postgres://postgres:123456@127.0.0.1:5433/mydb1")

Connect to postgresql database