Error: The given id must not be null for GeneratedValue in JPA

Question

My object:

@Entity
@Table(name="user")
public class User {
    @Id
    @Column(name="uid")
    @GeneratedValue(strategy=GenerationType.IDENTITY)
    private Long id;

  //more code
 }

When I POST user JSON without uid, I am getting error as the given id must not be null. Which should not be the case while uid should be generated by the database. Please point what am I missing.

JSON:

{
"email": "john@mail.com",
"name": "John Doe",
"phone": "98-765-4445"
}

Error:

{
"timestamp": 1501058952038,
"status": 500,
"error": "Internal Server Error",
"exception": "org.springframework.dao.InvalidDataAccessApiUsageException",
"message": "The given id must not be null!; nested exception is java.lang.IllegalArgumentException: The given id must not be null!",
"path": "/api/user/"
}

can you try --> @GeneratedValue(strategy = GenerationType.TABLE), this uses sequence table id assignment — JavaLearner1, Jul 26 '17 at 09:05
@GeneratedValue(strategy = GenerationType.AUTO) will work, Ref: https://stackoverflow.com/questions/4102449/how-to-annotate-mysql-autoincrement-field-with-jpa-annotations — JavaLearner1, Jul 26 '17 at 09:12

Anil Bhaskar · Accepted Answer · 2021-11-30T02:20:09.353

9

It was my bad, I was calling foo(user.getId()) before saving the User object into the database. Takeaways from this: @GeneratedValue(strategy=GenerationType.IDENTITY) is the correct code and generates identical ids while saving to database¹. And Long is not a problem. Thanks.

[1]: I am saving the object into the database by, something like: userRepository.save(user).

edited Nov 30 '21 at 02:20

answered Jul 26 '17 at 10:36

Anil Bhaskar

3,354
4
27
48

3

It is always a good practice to post the correct code once you find the solution so that new learners who cannot understand jargons (like persisting in this case) can grasp it quickly. – Rahul Aug 25 '18 at 22:22
@Rahul thanks, I did it long time ago. I edited as much as possible. Hope it is better now. – Anil Bhaskar Nov 30 '21 at 02:21

score 0 · Answer 2 · answered Jul 26 '17 at 09:11

0

To generate string uuid's for primary keys (as I assume you are trying to do) you can try the following code:

@Id
@GeneratedValue(generator = "uuid")
@GenericGenerator(name = "uuid", strategy = "uuid2")
private String id;

answered Jul 26 '17 at 09:11

Mustafa

4,870
3
23
37

Error: The given id must not be null for GeneratedValue in JPA

2 Answers2