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.

Rohit Gaikwad · Accepted Answer · 2017-06-16 09:06:43Z

98

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.

edited Jun 16, 2017 at 9:06

answered Oct 1, 2016 at 15:04

Rohit Gaikwad

3,9443 gold badges21 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Marv · Accepted Answer · 2021-01-20 18:07:56Z

29

If someone is getting this error with Spring Boot testing(with H2) , we have to use following in the application.properties(or whatever profile we are using) :

spring.jpa.hibernate.ddl-auto=create-drop

edited Jan 20, 2021 at 18:07

Marv

3,5572 gold badges27 silver badges49 bronze badges

answered Jul 28, 2020 at 4:37

Ram Pratap

5404 silver badges10 bronze badges

2 Comments

Tomas Antos Over a year ago

I actually use the property: spring.jpa.hibernate.ddl-auto=update. That doesn't override the data in case they were inserted with non-generated keys in data.sql

pamcevoy Over a year ago

create-drop worked for POSTing data but not for loading from data.sql during startup with H2 database. The update value worked the opposite (worked fro data.sql but not for POST data) and the none value was the same as update

Amrut Prabhu · Accepted Answer · 2020-09-07 10:24:32Z

13

Setting the following property in the properties file helped me solve the hibernate_sequence problem for hibernate 5.4v

spring:
  jpa:
    hibernate:
      use-new-id-generator-mappings: false

answered Sep 7, 2020 at 10:24

Amrut Prabhu

1,52914 silver badges13 bronze badges

2 Comments

razvang Over a year ago

I had already wasted half a day on this, and tried everything. Nothing worked, until I have found this solution. When testing my DB Code, I use Liquibase to create the DB schema, and populate it with some data. In my tests, I was always getting this error: Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "HIBERNATE_SEQUENCE" not found; SQL statement This was the fix: spring.jpa.hibernate.use-new-id-generator-mappings=false

md_rasler Over a year ago

This also was the solution for me. I use liquibase as well to create the database tables with an intended target of PostgreSQL, and H2 for testing. The auto-increment works in PostgreSQL by creating a sequence, but not in H2. This was the solution for me, as the H2 db is not persistent and I just need a new next sequence ID for testing.

Matteo Baldi · Accepted Answer · 2017-08-10 08:27:31Z

9

Check persistence.xml

property name="hibernate.hbm2ddl.auto" value="create"

not hdm2ddl

This worked in my case.

edited Aug 10, 2017 at 8:27

Matteo Baldi

5,83811 gold badges44 silver badges54 bronze badges

answered Aug 10, 2017 at 8:11

David

911 silver badge1 bronze badge

Comments

Oncledjo · Accepted Answer · 2019-03-29 14:25:35Z

3

If you use a 2nd cache with liquidbase, you have to add the sequence in the changelog like this:

<changeSet author="liquibase-docs"
    id="createSequence-example">
    <createSequence catalogName="cat" cycle="false"
        incrementBy="1" ordered="true" schemaName="public"
        sequenceName="hibernate_sequence" startValue="0" />
</changeSet>

answered Mar 29, 2019 at 14:25

Oncledjo

311 bronze badge

Comments

Rafael N. Siqueira · Accepted Answer · 2021-11-03 21:15:08Z

3

SQL operation ERROR when start app spring-boot.

I added the setting in spring properties and solved: in the spring:jpa.hibernate.ddl-auto= create-drop to hibernate be able create or drop table automatically.

edited Nov 3, 2021 at 21:15

answered Nov 3, 2021 at 12:52

Rafael N. Siqueira

415 bronze badges

1 Comment

Community Over a year ago

Your answer could be improved with additional supporting information. Please edit to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers in the help center.

asfarasiknow · Accepted Answer · 2023-11-03 06:22:08Z

3

spring.jpa.hibernate.use-new-id-generator-mappings=false is no longer supported, use this instead

spring.jpa.properties.hibernate.id.db_structure_naming_strategy=legacy

answered Nov 3, 2023 at 6:22

asfarasiknow

3254 silver badges14 bronze badges

Comments

Flavio Oliva · Accepted Answer · 2022-09-27 12:40:33Z

0

For spring-boot 2.7.x and h2 2.x you need to add MODE=LEGACY; in the database connection:

example application.yml:

spring:
  datasource:
    url: jdbc:h2:mem:test;MODE=LEGACY;

exemple application.properties:

spring.datasource.url=jdbc:h2:mem:test;MODE=LEGACY;

answered Sep 27, 2022 at 12:40

Flavio Oliva

6748 silver badges19 bronze badges

Comments

Flavio Oliva · Accepted Answer · 2023-06-05 12:33:45Z

0

I ran into this issue while running some tests. Adding these annotations helped me fix the issue for me:

@Transactional
@DirtiesContext(classMode = DirtiesContext.ClassMode.BEFORE_CLASS)

answered Jun 5, 2023 at 12:33

Flavio Oliva

6748 silver badges19 bronze badges

Comments

Sendi · Accepted Answer · 2023-05-19 08:03:39Z

-1

If someone is having this problem while testing a repository, changing the code like below might help you:

From this:

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

To this:

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

answered May 19, 2023 at 8:03

Sendi

72 bronze badges

Comments

Monarch · Accepted Answer · 2023-07-24 05:03:57Z

-1

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

with

spring.jpa.hibernate.use-new-id-generator-mappings=false

in test-config.properties works for me

answered Jul 24, 2023 at 5:03

Monarch

1

Comments

Gru · Accepted Answer · 2021-06-19 19:52:40Z

-2

For Mysql:

the auto-increment is not added, modify ur table:

ALTER TABLE table_name MODIFY COLUMN id BIGINT AUTO_INCREMENT=1

answered Jun 19, 2021 at 19:52

Gru

851 silver badge7 bronze badges

Collectives™ on Stack Overflow

Sequence "HIBERNATE_SEQUENCE" not found; SQL statement

12 Answers 12

Comments

2 Comments

2 Comments

Comments

Comments

1 Comment

Comments

Comments

Comments

From this:

To this:

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

12 Answers 12

Comments

2 Comments

2 Comments

Comments

Comments

1 Comment

Comments

Comments

Comments

From this:

To this:

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related