MySQL Connector/J v8 will have several changes

[yoskhdia]

There are several changes from version 5.1 to 8.0 of the Connector/J.
(see also: https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-whats-new.html)
Things that need attention are as follows:

• The driver needs Java 8 platform
  • Perhaps, this will have no effect. Because ScalikeJDBC 3.0 requires Java 8 (or higher) and streams module is provided since 3.0 .
• driver name: com.mysql.jdbc.Driver -> com.mysql.cj.jdbc.Driver
  • This affects here.
• And... Are there any other attentions?

[seratch]

Since 6.x, I recognize a change in the driver's behavior while fetching database metadata. The change affected DB.getTable(name) and related APIs.

https://docs.oracle.com/javase/8/docs/api/java/sql/DatabaseMetaData.html

MySQL JDBC driver 6.x is not compatible with other major JDBC drivers. I'm not sure the behavior has been fixed in 8.x yet.

[seratch]

We're looking for contributors who investigate more about this topic.

[xuwei-k]

Updated some settings

• avoid MySQL 8 reserved word groups #1981
• prepare MySQL 8 test #1982
• use MySQL 8 instead of 5.7 in test #1983
• 7c6b4bf

TODO:

• sbt plugin scripted test