I want to create my database tables with InnoDB, I'm using Spring Boot 2.1.3 and MySQL 8.0, so i used this:
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQL8Dialect
And, yeah, it works, but i got a lot of errors in my console:
2019-04-03 19:11:55.182 INFO 1820 --- [ restartedMain] org.hibernate.dialect.Dialect : HHH000400: Using dialect: org.hibernate.dialect.MySQL8Dialect
2019-04-03 19:11:55.966 WARN 1820 --- [ restartedMain] o.h.t.s.i.ExceptionHandlerLoggedImpl : GenerationTarget encountered exception accepting command : Error executing DDL "alter table application drop foreign key FKldca8xj6lqb3rsqawrowmkqbg" via JDBC Statement
org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "alter table application drop foreign key FKldca8xj6lqb3rsqawrowmkqbg" via JDBC Statement
And this one for each of my table:
Caused by: java.sql.SQLSyntaxErrorException: Table 'test.usr' doesn't exist
"test.usr" -> "test" is my schema name, and "usr" is a table name.
But it still creates all of my tables, so how can i get rid of this errors?
As Antoniossss proposed, I've just used Flyway to handle my database. Thanks.