How can I configure Hibernate 5 to force Mysql create tables using Innodb engine?

Question

Spent several hours to solve this issue, gave up finally. I need my app to create Innodb tables, but by default they are created in Myisam engine. I've tried to set property,

<property name="hibernate.dialect.storage_engine">innodb</property> but it won't work.

org.hibernate.dialect.MySQL57InnoDBDialect - deprecated

Found out there is org.hibernate.dialect.InnoDBStorageEngine class but I couldn't set it to property name="hibernate.dialect" in my hibernate.cfg.xml because of

org.hibernate.dialect.InnoDBStorageEngine' is not assignable to 'org.hibernate.dialect.Dialect

reason. Do you have any idea where I can set InnoDBStorageEngine? Or is there another way to force Hibernate use innodb while creating tables? Thanks in advance

Possible duplicate of [Hibernate: Create Mysql InnoDB tables instead of MyISAM](https://stackoverflow.com/questions/1459265/hibernate-create-mysql-innodb-tables-instead-of-myisam) — Aleh Maksimovich, Oct 14 '17 at 16:32
What is `default_storage_engine` in my.cnf? What version of MySQL are you using? — Rick James, Oct 14 '17 at 17:31

score 2 · Accepted Answer · answered Oct 14 '17 at 16:35

The Hibernate 5.2 documentaton suggests what to do in deprecation description

MySQL57InnoDBDialect - Deprecated

Use "hibernate.dialect.storage_engine=innodb" environment variable or JVM system property instead.

So use org.hibernate.dialect.MySQL57Dialect in combination with this property set.

How can I configure Hibernate 5 to force Mysql create tables using Innodb engine?

1 Answers1