JPA ERROR You have an error in your SQL syntax; check the manual that corresponds to your MariaDB’ server version for the right syntax to use near ‘type = `MyISAM`’

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB' server version for the right syntax to use near 'type = `MyISAM`'

The problem is that in Hibernate 5.x and earlier the dialect org.hibernate.dialect.MySQLDialect is for MySQL 4.x or earlier and the fragment TYPE=MYISAM that is generated by this dialect was deprecated in MySQL 4.0 and removed in 5.5.

so here you should put the best dialect for your bd server

for example for MariaDb you have the choice between:

• org.hibernate.dialect.MariaDBDialect
• org.hibernate.dialect.MariaDB53Dialect

If you are using MySQL, or if the above two dialects for MariaDB don’t exist in your version of Hibernate:

• org.hibernate.dialect.MySQL5Dialect
• org.hibernate.dialect.MySQL55Dialect
• org.hibernate.dialect.MySQL57Dialect

in my case i was in MySQLDialect and to resolve i changed dialect to MySQL5Dialect

Thank you!