PostgreSQL Spring Boot - hibernate_sequence is not generated

Question

Java 11
Spring Boot 2.2.4.RELEASE
PostgreSQL 42.4.9

I've been researching through Stack Overflow and other sources and have been unable to find an answer to my question.

Basically I have a Spring Boot application and I'm trying to save an object to a PostgreSQL db. When trying to save an object, I'm getting a hibernate_sequence does not exist error.

ERROR: relation "<schema>.hibernate_sequence" does not exist

Here is my entity that handles the id generation:

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "id", nullable = false, unique = true)
    private Long id;

From my application.properties file:

######### uses denoted schema (this schema must exist in db or have a .sql file in resources dir that creates it)
spring.jpa.properties.hibernate.default_schema=cinc_student
######### required to make spring use the schema.sql file in resources dir (if not using this file, this can be removed)
spring.datasource.initialization-mode=always
######### prevents hibernate from recreating unique indexes each time the app is restarted.
spring.jpa.properties.hibernate.schema_update.unique_constraint_strategy=RECREATE_QUIETLY

I'm using a schema.sql file under resources with the following line in it to create the schema:

CREATE SCHEMA IF NOT EXISTS cinc_student

I have two test databases that I point my application to locally. In one of the databases, the schema and hibernate_sequence were generated automatically without issue.

In the other db, the schema was created but the sequence was not generated. No difference in the code at all, just pointing to different freshly created empty local databases.

Can anyone explain?

I am not using a @GenerateSequence because I want it to use the default hibernate_sequence that should be generated out of the box. I will not be creating a manual sequence.

What are you using to generate the schema? Are you using hibernate's DDL function or something like flyway? — vkourt
– vkourt, Commented Dec 8, 2020 at 16:53
I'm using a sql file under resources "schema.sql" CREATE SCHEMA IF NOT EXISTS cinc_student — TylerTwoForks
– TylerTwoForks, Commented Dec 8, 2020 at 19:10

cfar · Accepted Answer · 2021-02-08 16:37:18Z

1

Add the following to application.properties. This will tell Spring to use the Postgre Dialect which will auto-create the hibernate_sequence on application startup.

spring.jpa.hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect

answered Feb 8, 2021 at 16:37

cfar

112 bronze badges

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

1 Comment

TylerTwoForks Over a year ago

Thanks but this does not resolve the issue. I already had that in my application.properties. This is extremely intermittent. Works most of the time as it should.

Mitch · Accepted Answer · 2023-04-06 20:58:42Z

1

Adding spring.jpa.generate-ddl=true to the application.properties worked for me.

Spring-boot version: 15.2
PostgreSQL version: v3.0.2

answered Apr 6, 2023 at 20:58

Mitch

1,9121 gold badge19 silver badges20 bronze badges

Collectives™ on Stack Overflow

PostgreSQL Spring Boot - hibernate_sequence is not generated

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related