Version 8.0.30 is the latest General Availability release of the 8.0 series of MySQL Connector/J. It is suitable for use with MySQL Server versions 8.0 and 5.7. It supports the Java Database Connectivity (JDBC) 4.2 API, and implements the X DevAPI.
X DevAPI: For document-modifying methods that are chained after
modify()and take a document path expression as one of its arguments (that is,
arrayAppend()), Connector/J now throws an error when the document path is empty or is a null string. (Bug #34259416)
Historically, MySQL Server has used
utf8as an alias for
utf8mb3. Since release 8.0.29,
utf8mb3has become a recognized (though deprecated) character set on its own for MySQL Server and to make things consistent, in release 8.0.30, any collations prefixed with
utf8_are now prefixed with
utf8mb3_instead. To go with that change, Connector/J has updated its character set and collation mapping accordingly in this release, and users are encouraged to update to Connector/J 8.0.30 to avoid potential issues when working with MySQL Server 8.0.30 or later. (Bug #34090350)
References: See also: Bug #33787300.
A few links in the CONTRIBUTING.md file in the distribution packages were broken. They have now been fixed or removed. (Bug #34082503)
The description for the connection property
rewriteBatchedStatementshas been corrected, removing the limitation that server-sided prepared statements could not take advantage of the rewrite option. (Bug #34022110)
A spelling error has been fixed in the source file for the
PropertyDefinitionsclass. Thanks to Weijie Wu for contributing the fix. (Bug #106779, Bug #33976245)
DatabaseMetaData.getTypeInfoalways returned false for
AUTO_INCREMENTfor all data types. With this fix, Connector/J returns the correct value for each data type. Also, the missing types
DOUBLE PRECISION UNSIGNEDhave been added to the
ResultSet. (Bug #106758, Bug #33973048)
Contrary to the the MySQL requirement for comments, Connector/J did not require a whitespace (or a control character such as a newline) after "
--" to mark the beginning of a comment within a SQL statement. This fix aligns Connector/J with the MySQL requirement. (Bug #76623, Bug #20856749)