【BUG日记】【Hibernate】Error executing DDL “create table hibernate_sequence (next_val bigint) type=MyISAM

【日期】: 2020/10/12

【问题】:

  • Error executing DDL “create table hibernate_sequence (next_val bigint) type=MyISAM” via JDBC Statement.
  • Error executing DDL “insert into hibernate_sequence values ( 1 )” via JDBC Statement
  • 【BUG日记】【Hibernate】Error executing DDL “create table hibernate_sequence (next_val bigint) type=MyISAM
  • 【BUG日记】【Hibernate】Error executing DDL “create table hibernate_sequence (next_val bigint) type=MyISAM

【原因】: Entity类中,定义的字段使用了注解:@GeneratedValue【BUG日记】【Hibernate】Error executing DDL “create table hibernate_sequence (next_val bigint) type=MyISAM

【如何发现】: 启动项目时候发现报错。

【如何修复】: 在注解@GeneratedValue后添加:(strategy = GenerationType.IDENTITY)

【BUG日记】【Hibernate】Error executing DDL “create table hibernate_sequence (next_val bigint) type=MyISAM

【总结】: 高处不胜寒。