Is there a Hibernate dialect for MySQL 8? Or should I use the org.hibernate.dialect.MySQL57Dialect that ships with Hibernate? I'm using hibernate 5.2.16
10 Answers
MySQL8Dialect(org.hibernate.dialect.MySQL8Dialect) is available in hibernate bundle 5.3.1.Final. You can use:
org.hibernate.dialect.MySQL8Dialect yes, For MySQL8, use org.hibernate.dialect.MySQL8Dialect
If you are using Gradle (e.g. for Grails) just configure:
in application.yml
dataSource: ... driverClassName: com.mysql.cj.jdbc.Driver dialect: org.hibernate.dialect.MySQL8Dialect .... in build.gradle
dependencies { ... runtime 'mysql:mysql-connector-java:8.0.17' ... Pay attention on mysql-connector version and non-deprecated driver class name
spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.MySQL8Dialect spring.jpa.properties.hibernate.dialect.storage_engine=innodb got from here
I know this question is a couple of weeks old, but for completeness it appears Hibernate 5.3 does have a MySQL8 dialect
I have not used it, so I cannot comment on its quality, but the support appears to be there.
2Yes, MySQL8Dialect for MySql 8. In my case I have used MySQL8Dialect for MySql 8 in my spring boot application by following way:
spring.jpa.database-platform=org.hibernate.dialect.MySQL8Dialect Looking over at MySQL 8's release notes, MySQL 8.x has been in development and has only been out for GA since 2018-04-19 (less than a month ago), so I doubt there would be a dialect already made specifically for it.
You can see a list of all hibernate dialects here, and as you can see, there is no MySQL 8 dialect.
MySQLDialect should only be used for MySQL 5 and earlier whereas MySQL57Dialect should be used for MySQL 5.x as well as 8.x for now.
If you are using SpringBoot
spring: jpa: hibernate: ddl-auto: update database-platform: org.hibernate.dialect.MySQL8Dialect I had the similar query as I installed MySQL 8 Server and tried to interact with the same using my Spring Boot Application.
But I was unable to do so.
When I explored the Source Code of MySQL5Dialect class, it's documentation clearly mentions that this dialect class has been dedicated to MySQL 5.X versions.
I am not sure whether it supports MySQL 8.X versions.
Thus I would suggest to use MySQL 5.X till an official dialect is released with Hibernate.
I was able to resolve this by simply adding the configuration below to my application.properties file.
#Hibernate spring.jpa.properties.hibernate.dialect= org.hibernate.dialect.MySQL8Dialect spring.jpa.driverClassName= com.mysql.cj.jdbc.Driver 
