JPA Entity class giving error with 2 @GeneratedValue fields

Question

I have two columns which will use @GeneratedValues, but when I am putting them like this it is giving error; " Exception Description: Class [class Testing] has two @GeneratedValues: for fields [Testing.SEQ_NO] and [Testing.ID]. Only one is allowed. "

@Table(name = "TABLE1")
@Entity
public class Testing{

@GeneratedValue(strategy=GenerationType.AUTO)
@Id
private Long id;

@Column(name = "LINKAGE_ID")
private int linkageId;

@Column(name = "TRANSFER_ID")
private int transferId;

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

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

@GeneratedValue(strategy=GenerationType.SEQUENCE,generator="SEQ")
@SequenceGenerator(name="SEQ",sequenceName="SEQ", allocationSize=1)
@Column(name = "SEQ_NO")
private int seqNo;



**I have also created a simple sequence in Db using this:**


CREATE SEQUENCE SEQ START WITH 1

I am trying to figure out a way to auto-generate both ID and SEQ_NO in same entity class. — verma_neeraj, Feb 09 '17 at 06:25
JPA spec says that only `@Id` fields can be generated. Some JPA providers (e.g DataNucleus) allow other fields to be generated too, but to be portable only generate the "id" field — Neil Stockton, Feb 09 '17 at 10:05

score 1 · Accepted Answer · edited May 23 '17 at 12:01

1

Like the error message says, Only one field with @GeneratedValue is allowed but you have two.
Please remove one of them.

I am afraid you can't do what you intended by simple annotations.
Check out this existing post for workaround.
workaround

Not sure why you need two columns in same table, whose value need to be auto incremented.
If you really want two Unique columns, you can use your id as usual and UUID for the other column.

edited May 23 '17 at 12:01

Community

1
1

answered Feb 09 '17 at 06:18

Minjun Yu

3,497
4
24
39

Hi @minjinyu, I have to auto-generate both. – verma_neeraj Feb 09 '17 at 06:23
1

@verma_neeraj I am afraid you can't do that with simple annotations in hibernate, bro. See update. – Minjun Yu Feb 09 '17 at 06:36
@mijinyu, Thanks a lot. – verma_neeraj Feb 09 '17 at 06:40
Can you explain why you need 2 columns in the same table to auto-increment so we could think some way around – Akshay Feb 09 '17 at 06:40
@verma_neeraj glad my answer helps. BTW, friendly reminder. When you reply someone's comment, you can type "@"+ first couple of letter of the name +"tab". The name will automatically pop up so that there will be no typo in the name, cheers. – Minjun Yu Feb 09 '17 at 06:44
@Akshay , ID is primary which is auto generated and SEQ_NO is another field which has to be auto generated not programmatically but via DB or annotations. – verma_neeraj Feb 09 '17 at 06:57
@verma_neeraj..have you got it or do you still need a way around? – Akshay Feb 09 '17 at 09:26
@Akshay, I am trying out that DB workaround suggested by Minjin Yu. – verma_neeraj Feb 09 '17 at 09:41
DB workaround worked!!! Just make a trigger for that column value incrementation. – verma_neeraj Feb 09 '17 at 12:26

score 0 · Answer 2 · answered May 21 '20 at 16:15

0

Using columnDefinition="serial" with Postgresql it works for me.

@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Long id;

@Column(columnDefinition="serial")
@Generated(GenerationTime.INSERT)
private Long seqNo;

answered May 21 '20 at 16:15

FilippoG

329
1
2
13

JPA Entity class giving error with 2 @GeneratedValue fields

2 Answers2

Linked