Sequence "HIBERNATE_SEQUENCE" not found; SQL statement

Question

In my spring mvc app, i have the following object. I am trying to make a visual of data using devtool in my app.

@Entity @Data public class ConsultationRequest {     @Id     @GeneratedValue     private Long id;      private String name;      private String email;      private String purpose;      private String programme;      private int year;      private String language;      private String comments;     @Enumerated(EnumType.STRING)     private ConsultationStatus status; } 

Then i used the jpa to make the entity:

@Repository public interface ConsultationRequestRepository extends JpaRepository<ConsultationRequest, Long> {  } 

The problem is when i load my application, i face with 2 errors:

 Unsuccessful: drop sequence hibernate_sequence [36morg.hibernate.tool.hbm2ddl.SchemaExport  Sequence "HIBERNATE_SEQUENCE" not found; SQL statement: 

Then when i open the

http://localhost:8080/h2-console/ 

I cannot see the table. It seems that the in the boot process, table is not made.

Answer 1

Update your code as below:

 @Id  @GeneratedValue(strategy = GenerationType.IDENTITY)  private Long id; 

As you have not specified a sequence table name, hibernate will look for a sequence table named as hibernate_sequence and use it as default.

For Oracle/Postgres, increment fields used are sequence tables.
In MySql, there are increment fields that automatically increment.