[hibernate-dev] SchemaExport adds engine=MyISAM to all create table statements.

[Petar Tahchiev]

Hey guys,

I've been using Hibernate's SchemaExport tool (5.1.x) for a long time it
has always created an sql script with create-table statements like this:

    create table abstract_modifiable_entity (
        id bigint not null,
        code varchar(255) not null,
        created_by varchar(255),
        created_date datetime,
        last_modified_by varchar(255),
        last_modified_date datetime,
        primary key (id)
    );

However now that I try to upgrade to the latest 5.2.x I see a change - it
adds engine=MyISAM to the end of every create-table statement:

    create table abstract_modifiable_entity (
       id bigint not null,
        code varchar(255) not null,
        created_by varchar(255),
        created_date datetime,
        last_modified_by varchar(255),
        last_modified_date datetime,
        primary key (id)
    ) engine=MyISAM;


Is this intentional or a bug? I tried to find something in the changelog
but I couldn't. I even tried to declare the InnoDB dialect:

spring.jpa.database-platform=org.hibernate.dialect.MySQL57InnoDBDialect

but it still adds the MyISAM engine.

Is there any API to set the required engine?

Thank you.
-- 
Regards, Petar!
Karlovo, Bulgaria.
---
Public PGP Key at:
http://pgp.mit.edu:11371/pks/lookup?op=get&search=0x19658550C3110611
Key Fingerprint: A369 A7EE 61BC 93A3 CDFF  55A5 1965 8550 C311 0611