java.sql.SQLSyntaxErrorException: Table 'test.hibernate_sequence' doesn't exist

SpringBoot 2.1.4

在使用Spring Data JPA时调用JpaRepository.save(Person)方法保存对象到mysql数据库中的时报错

java.sql.SQLSyntaxErrorException: Table 'test.hibernate_sequence' doesn't exist

解决方法

将@GeneratedValue改为@GeneratedValue(strategy=GenerationType.IDENTITY)解决问题

@Entity
public class Person {
  @Id
  @GeneratedValue
  private Long id;
  ...
}

@Entity
public class Person {
  @Id
  @GeneratedValue(strategy=GenerationType.IDENTITY)
  private Long id;
  ...
}