Hibernate sequence not generated

Question

Im working on a Spring (not Boot!) project, with Hibernate and PostgreSQL database. I also use Flyway for migration. I use Flyway to generate the schema of the database, and insert initial data to it with given SQL scripts in my resources folder. For this reason, I excluded the hibernate.hbm2ddl.auto property from my hibernate.properties file. On the startup, the schema is created and the data is inserted to the database, but my problem is, that this way Hibernate doesn't generate its sequence, and I cant save data from the application:

org.postgresql.util.PSQLException: ERROR: relation "hibernate_sequence" does not exist

What can I do with this?

You should provide the schema. But the error message is saying hibernate_sequence does not exist. So you have to create the sequence to DB and try. — Nur Zico
– Nur Zico, Commented Jul 4, 2017 at 11:15
I see. So its completely okay to create an SQL script manually, that creates the hibernate_sequence? — David Veres
– David Veres, Commented Jul 4, 2017 at 11:17

mihatel · Accepted Answer · 2017-07-04 13:34:23Z

6

As you didn't provide any code not sure what is wrong there, assume missing @SequenceGenerator annotation, I'll provide the one is working for me.

@Entity
@Table(name = "your_table")
@SequenceGenerator(name = "your_table_id_seq", sequenceName = "your_table_id_seq", allocationSize = 1)
public class YourTable implements Serializable {

@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "your_table_id_seq")
private Long id;

. . .

answered Jul 4, 2017 at 13:34

mihatel

84615 silver badges38 bronze badges

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

1 Comment

David Veres Over a year ago

Thank you, I am looking forward to implement this solution too!

Andrey · Accepted Answer · 2017-07-04 11:18:51Z

3

You need to create a sequence like this:

CREATE SEQUENCE hibernate_sequence START 1;

answered Jul 4, 2017 at 11:18

Andrey

1914 silver badges13 bronze badges

2 Comments

David Veres Over a year ago

Now its better, but still have errors. The sequence is created, but now I cant insert data from the app, because

org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "user_pkey"   Detail: Key (id)=(1) already exists.

The order is the following: create hibernate_sequence, create tables, insert data. Seems like inserting the data not incrementing the value in hibernate_sequence?

Andrey Over a year ago

Add DEFAULT nextval(‘hibernate_sequence’) to id in your schema

Collectives™ on Stack Overflow

Hibernate sequence not generated

2 Answers 2

1 Comment

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related