JPA does not use sequence

Question

I have created a sequence in the database (PostgreSQL) and I have the following annotations in the domain model. I am using JPA. However, when I invoke the web service (REST) without an id in the object that I want to create it throws a constraint error. However shouldn't it use a value from the sequence below?

@Id
@SequenceGenerator(name = "user_seq", sequenceName = "user_seq", allocationSize = 1)
@GeneratedValue(strategy = GenerationType.IDENTITY, generator = "user_seq")
private int id;

Caused by: org.hibernate.exception.ConstraintViolationException: could not execute statement Caused by: org.postgresql.util.PSQLException: ERROR: null value in column "id" violates not-null constraint

Mikko Maunu · Accepted Answer · 2013-05-18 17:59:04Z

1

When value comes from database sequence, GenerationType.SEQUENCE should be used as a strategy. GenerationType.IDENTITY is used with identity columns.

answered May 18, 2013 at 17:59

Mikko Maunu

42.3k11 gold badges143 silver badges142 bronze badges

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

2 Comments

LuckyLuke Over a year ago

Awesome, thanks for spotting that. I have written SEQUENCE in the other classes. Is IDENTITY the correct type to use if you use auto incrementing column values as you can in MySQL for instance? I don't understand the explanation in the API.

Mikko Maunu Over a year ago

Welcome. Yes, identity is correct choice for MySQL auto increment.

Collectives™ on Stack Overflow

JPA does not use sequence

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related