ERROR: relation "hibernate_sequence" does not exist

Question

I do not want to use autoincrement id. I have this table in PostgreSQL:

CREATE TABLE public.project
(
    id character varying(255) COLLATE pg_catalog."default" NOT NULL,
    name character varying(255) COLLATE pg_catalog."default" NOT NULL,
    number bigint NOT NULL,
    state character varying(255) COLLATE pg_catalog."default",
    CONSTRAINT project_pkey PRIMARY KEY (id)
)

And I have this model:

@Entity
@Table(name = "project")
@JsonIgnoreProperties({ "hibernateLazyInitializer", "handler" })
public class Project {

@Id
@Column(name = "id")
private String id;

@Column(name = "name")
private String name;

@Column(name = "number")
private BigInteger number;

@Column(name = "state")
private String state;

I want to use simple ID I do not want to use autoincrement and hibernate_sequence, and do not understand where I wrong.

And I have error: ERROR 11088 --- [ restartedMain] o.h.engine.jdbc.spi.SqlExceptionHelper : ERROR: relation "hibernate_sequence" does not exist

Do you have anywhere in the model annotation @GeneratedValue? — Simon Martinelli, Jun 12 '19 at 12:25
do you have any serial data type on postgresql ? because hibernate will generate sequence for this type that because you can take this error — Mithat Konuk, Jun 12 '19 at 12:32
Yes, I have much serial data type in other tables. If I understand good. — SIn san sun, Jun 12 '19 at 12:37
Possible duplicate of [Migrating Hibernate 3 to 5: relation hibernate\_sequence does not exist](https://stackoverflow.com/questions/35230317/migrating-hibernate-3-to-5-relation-hibernate-sequence-does-not-exist) — Nikolai Shevchenko, Jun 12 '19 at 12:37

score 2 · Answer 1 · edited Sep 19 '21 at 08:58

2

In our entity you should use @GeneratedValue(strategy = GenerationType.IDENTITY) on your id especially if your table will autoincrement id.

edited Sep 19 '21 at 08:58

Andronicus

25,419
17
47
88

answered Sep 19 '21 at 04:03

mohamed sandwidi

51
4

score 0 · Answer 2 · answered Nov 10 '20 at 15:07

0

Run:

CREATE SEQUENCE hibernate_sequence START 1;

answered Nov 10 '20 at 15:07

dimirsen Z

873
13
16

score 0 · Answer 3 · answered Nov 24 '20 at 10:22

In my case I could solve the problem by upgrading the postgres driver to a more recent version which seems to work with different (older) postgres versions as well. (updated version in build.gradle):

implementation 'org.postgresql:postgresql:42.2.18'

score -1 · Answer 4 · answered Jun 12 '19 at 12:30

-1

You need to set spring.jpa.properties.hibernate.id.new_generator_mappings=false in your application.properties file.

answered Jun 12 '19 at 12:30

xserc

1

ERROR: relation "hibernate_sequence" does not exist

4 Answers4