Spring JPA + Boot +Sequence Generator always 0

Question

The following code only renders an ID of 0

@Id
@GeneratedValue(strategy=GenerationType.AUTO, generator="PROJECT_SEQ_GEN")
@SequenceGenerator(name="PROJECT_SEQ_GEN", sequenceName="X.X_PROJECT_SEQ", allocationSize=1)
private long projectId;

I tried SEQUENCE and AUTO but both with the same result. x_project_seq.nextval works fine in my Oracle database. I would like to keep using the sequence already defined in the database.

According to the Getting Started guide by Spring - Accessing Data with JPA ...

"The Customer’s `id property is annotated with @Id so that JPA will recognize it as the object’s ID. The id property is also annotated with @GeneratedValue to indicate that the ID should be generated automatically."

From their example it looks like all they did was create new Customer and the IDs were automatically generated. What am I missing here?

Your strategy = GenerationType.AUTO should be strategy = GenerationType.SEQUENCE — Edward J Beckett
– Edward J Beckett, Commented Mar 31, 2015 at 0:17

Edward J Beckett · Accepted Answer · 2015-03-31 00:30:25Z

2

You are using the wrong GenerationType for your implementation. Update your strategy declaration to use strategy = GenerationType.SEQUENCE and simply use PROJECT_SEQ_GEN for the sequenceName value.

@Id
@GeneratedValue(strategy=GenerationType.SEQUENCE, generator="PROJECT_SEQ_GEN")
@SequenceGenerator(name="PROJECT_SEQ_GEN", sequenceName="PROJECT_SEQ_GEN", allocationSize=1)
private long projectId;

edited Mar 31, 2015 at 0:30

answered Mar 31, 2015 at 0:22

Edward J Beckett

5,1402 gold badges43 silver badges41 bronze badges

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

1 Comment

otgw Over a year ago

I wrote in my post that I have tried both (based on some answers I've read in other posts)

Community · Accepted Answer · 2017-05-23 11:43:25Z

0

Took me all morning but I finally fixed the issue.

I was using Hibernate tools to auto generate POJOs and all the annotations were being placed at the method level, however, Spring recommends (requires?) them at the field level. You can't just move the Id annotations to the field level either, because it's either one or the other. So I followed this answer to customize Hibernate tools to generate POJOs with the annotations all at the field level.

Now it's all good.

edited May 23, 2017 at 11:43

CommunityBot

11 silver badge

answered Mar 31, 2015 at 17:32

otgw

3901 gold badge5 silver badges16 bronze badges

Collectives™ on Stack Overflow

Spring JPA + Boot +Sequence Generator always 0

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related