[数据库] mysql-connector-java与MySQL、JDK对应的兼容版本

1 文由

MYSQL 数据库版本 与 驱动版本之间的兼容性，可能会涉及到 部分数据库特性(函数、语法)等是否能够正常使用的问题。

2 兼容性： mysql-connector-java VS Mysql数据库版本

• Summary of Connector/J Versions

Connector/J version	Driver Type	JDBC version	MySQL Server version	Status
5.1	4	3.0, 4.0, 4.1, 4.2	5.6, 5.7, 8.0*	General availability
8.0	4	4.2	5.6, 5.7, 8.0	General availability. Recommended version

• MySQL Connector/J 8.0 is highly recommended for use with MySQL Server 8.0, 5.7, and 5.6. Please upgrade to MySQL Connector/J 8.0.

官方更推荐MySQL5.6以上使用connector/j 8.0

3 兼容性: mysql-connector-java VS Java JDK版本

• Summary of Java Versions Required by Connector/J

Connector/J version	JRE Supported	JDK required for compiling source code
5.1	1.5.x, 1.6.x, 1.7.x*, 1.8.x**	1.5.x and 1.8.x ***
8.0	1.8.x	1.8.x

• *JRE 1.7 support requires Connector/J 5.1.21 and higher.

JRE 1.7 需要connector/J 5.1.21 以上

X 参考文献

• Chapter 2 Connector/J Versions, and the MySQL and Java Versions They Require - MySQL 【推荐】
• mysql-connector-java与Mysql、Java的对应版本 - CSDN
• https://repo1.maven.org/maven2/mysql/mysql-connector-java/