I've recently upgraded to Hibernate 3.2 and MySQL JDBC Driver 5.0.3. I'm using the Ant schemaexport task to generate my database tables. I'm getting the following warnings - maybe caused by the MySQLInnoDBDialect?

[schemaexport] (util.JDBCExceptionReporter 48 ) SQL Warning: 1287, SQLState: HY000
[schemaexport] (util.JDBCExceptionReporter 49 ) 'TYPE=storage_engine' is deprecated; use 'ENGINE=storage_engine' instead
[schemaexport] create table role (id bigint not null auto_increment, name varchar(20), description varchar(64), primary key (id)) type=InnoDB;
[schemaexport] (util.JDBCExceptionReporter 48 ) SQL Warning: 1287, SQLState: HY000
[schemaexport] (util.JDBCExceptionReporter 49 ) 'TYPE=storage_engine' is deprecated; use 'ENGINE=storage_engine' instead
[schemaexport] (util.JDBCExceptionReporter 48 ) SQL Warning: 1287, SQLState: HY000
[schemaexport] (util.JDBCExceptionReporter 49 ) 'TYPE=storage_engine' is deprecated; use 'ENGINE=storage_engine' instead
[schemaexport] create table user_role (user_id bigint not null, role_id bigint not null, primary key (user_id, role_id)) type=InnoDB;
[schemaexport] (util.JDBCExceptionReporter 48 ) SQL Warning: 1287, SQLState: HY000
[schemaexport] (util.JDBCExceptionReporter 49 ) 'TYPE=storage_engine' is deprecated; use 'ENGINE=storage_engine' instead
[schemaexport] (util.JDBCExceptionReporter 48 ) SQL Warning: 1287, SQLState: HY000
[schemaexport] (util.JDBCExceptionReporter 49 ) 'TYPE=storage_engine' is deprecated; use 'ENGINE=storage_engine' instead
[schemaexport] (util.JDBCExceptionReporter 48 ) SQL Warning: 1287, SQLState: HY000
[schemaexport] (util.JDBCExceptionReporter 49 ) 'TYPE=storage_engine' is deprecated; use 'ENGINE=storage_engine' instead
[schemaexport] alter table user_role add index FK143BF46AF503D155 (user_id), add constraint FK143BF46AF503D155 foreign key (user_id) references app_user (id);
[schemaexport] (util.JDBCExceptionReporter 48 ) SQL Warning: 1287, SQLState: HY000
[schemaexport] (util.JDBCExceptionReporter 49 ) 'TYPE=storage_engine' is deprecated; use 'ENGINE=storage_engine' instead
[schemaexport] (util.JDBCExceptionReporter 48 ) SQL Warning: 1287, SQLState: HY000
[schemaexport] (util.JDBCExceptionReporter 49 ) 'TYPE=storage_engine' is deprecated; use 'ENGINE=storage_engine' instead
[schemaexport] (util.JDBCExceptionReporter 48 ) SQL Warning: 1287, SQLState: HY000
[schemaexport] (util.JDBCExceptionReporter 49 ) 'TYPE=storage_engine' is deprecated; use 'ENGINE=storage_engine' instead
[schemaexport] alter table user_role add index FK143BF46A4FD90D75 (role_id), add constraint FK143BF46A4FD90D75 foreign key (role_id) references role (id);
[schemaexport] (util.JDBCExceptionReporter 48 ) SQL Warning: 1287, SQLState: HY000
[schemaexport] (util.JDBCExceptionReporter 49 ) 'TYPE=storage_engine' is deprecated; use 'ENGINE=storage_engine' instead
[schemaexport] (util.JDBCExceptionReporter 48 ) SQL Warning: 1287, SQLState: HY000
[schemaexport] (util.JDBCExceptionReporter 49 ) 'TYPE=storage_engine' is deprecated; use 'ENGINE=storage_engine' instead
[schemaexport] (util.JDBCExceptionReporter 48 ) SQL Warning: 1287, SQLState: HY000
[schemaexport] (util.JDBCExceptionReporter 49 ) 'TYPE=storage_engine' is deprecated; use 'ENGINE=storage_engine' instead

Is this something I should enter as an issue in JIRA - or is it a known issue?

Thanks,

Matt

hi matt,

have you tried MySQL5InnoDBDialect ?
there they use ENGINE=



jakob

Thank you - this solved the problem!