Add support for MySQL

[mp911de]

We should add support for MySQL (dialect and tests) and use the https://github.com/jasync-sql/jasync-sql/ driver that wraps their asynchronous driver with an R2DBC facade.

[mp911de]

Open issues:

• R2DBC Statement.returnGeneratedValues(…) should retrieve generated keys on INSERT jasync-sql/jasync-sql#105
• R2DBC implementation should use R2DBC exceptions jasync-sql/jasync-sql#106

Beyond that, the driver does not yet support batching and ConnectionFactoryDiscovery

[oshai]

I am not sure what you mean by discovery. The driver do support parsing a url like this: com.github.jasync.sql.db.mysql.util.URLParser.parseOrDie(url).

Just in case it helps somehow.

[mp911de]

R2DBC has a built-in ConnectionFactory discovery through io.r2dbc.spi.ConnectionFactories.get(…) (and as soon as r2dbc/r2dbc-spi#48 gets merged also an URL-based variant). This allows a consistent configuration that is independent from the driver.

All it requires on the driver side is a ConnectionFactoryProvider implementation and registration for Java Service Loader.

[mp911de]

Here's a link to a working example: https://gist.github.com/mp911de/ace06d31527dcbb245d63f03a7f9322a

The linked artifact references a branch build. Once this ticket gets resolved, the support will be merged to master and support will be available from regular builds.

[oshai]

Add Connection factory here: jasync-sql/jasync-sql#112