4.4.1.2 Changes in Connection Properties

A complete list of Connector/J 8.0 connection properties are available in connector-j-reference-set-config. The following are connection properties that have been changed (removed, added, have their names changed, or have their default values changed) going from Connector/J 5.1 to 8.0.

Properties that have been removed (do not use them during connection):

• useDynamicCharsetInfo

• useBlobToStoreUTF8OutsideBMP , utf8OutsideBmpExcludedColumnNamePattern, and utf8OutsideBmpIncludedColumnNamePattern: MySQL 5.6 and later supports the utf8mb4 character set, which is the character set that should be used by Connector/J applications for supporting characters beyond the Basic Multilingual Plane (BMP) of Unicode Version 3.

• useJvmCharsetConverters: JVM character set conversion is now used in all cases

• The following date and time properties:

  • dynamicCalendars

  • noTzConversionForTimeType

  • noTzConversionForDateType

  • cacheDefaultTimezone

  • useFastIntParsing

  • useFastDateParsing

  • useJDBCCompliantTimezoneShift

  • useLegacyDatetimeCode

  • useSSPSCompatibleTimezoneShift

  • useTimezone

  • useGmtMillisForDatetimes

• dumpMetadataOnColumnNotFound

• relaxAutoCommit

• strictFloatingPoint

• runningCTS13

• retainStatementAfterResultSetClose

• nullNamePatternMatchesAll (removed since release 8.0.9)

Properties that have been added:

• mysqlx.useAsyncProtocol (deprecated since release 8.0.22)

Property that has its name changed:

• com.mysql.jdbc.faultInjection.serverCharsetIndex changed to com.mysql.cj.testsuite.faultInjection.serverCharsetIndex

• loadBalanceEnableJMX to ha.enableJMX

• replicationEnableJMX to ha.enableJMX

Properties that have their default values changed:

• nullCatalogMeansCurrent is now false by default