Uploaded image for project: 'JBoss Enterprise Application Platform'
  1. JBoss Enterprise Application Platform
  2. JBEAP-19092

[GSS](7.3.z) HHH-12977 HHH-13910: MySQL57Dialect selected by automatic dialect resolution when using MySQL 8.0 database

XMLWordPrintable

    • +
    • Hide

      Dialect may be specified explicitly in the persistence.xml.

      Show
      Dialect may be specified explicitly in the persistence.xml .
    • Hide

      Deploy persistence unit without explicit dialect (referencing a connection pool and relying on Hibernate's automatic dialect resolution).

      Show
      Deploy persistence unit without explicit dialect (referencing a connection pool and relying on Hibernate's automatic dialect resolution).

      With MySQL 8 (e.g. 8.0.19), MySQL57Dialect is selected instead of MySQL8Dialect. Wrote a test that was examining the connection metadata:

      ... INFO ... HHH000400: Using dialect: org.hibernate.dialect.MySQL57Dialect
...
... INFO ... Database server : MySQL 8.0.19
... INFO ... Database driver : MySQL Connector/J mysql-connector-java-8.0.19 (Revision: a0ca826f5cdf51a98356fdfb1bf251eb042f80bf)

              gbadner@redhat.com Gail Badner (Inactive)
              rhn-support-sfikes Stephen Fikes (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: