EN
Spring + Hibernate + H2 - error - h2 Caused by: org.h2.jdbc.JdbcSQLException: Sequence "HIBERNATE_SEQUENCE" not found; SQL statement:
1 answers
6 points
How to fix this error:
xxxxxxxxxx
1
h2 Caused by: org.h2.jdbc.JdbcSQLException: Sequence "HIBERNATE_SEQUENCE" not found; SQL statement:
This error occurs when I try to save new entity with repository:
xxxxxxxxxx
1
UserEntity user = new UserEntity("Tom", 25);
2
userRepository.save(user);
My entity:
xxxxxxxxxx
1
import javax.persistence.*;
2
import java.util.Objects;
3
4
5
name = "users") (
6
public class UserEntity {
7
8
9
strategy = GenerationType.AUTO) (
10
private Long id;
11
12
private String name;
13
private int age;
14
15
// constructor
16
// getters, setters
17
}
Repository:
xxxxxxxxxx
1
import com.dirask.model.UserEntity;
2
import org.springframework.data.repository.CrudRepository;
3
import org.springframework.stereotype.Repository;
4
5
6
public interface UserRepository extends CrudRepository<UserEntity, Long> {
7
8
}
1 answer
2 points
Fix for this problem:
In UserEntity change:
xxxxxxxxxx
1
strategy = GenerationType.AUTO) (
to:
xxxxxxxxxx
1
strategy = GenerationType.IDENTITY) (
Entire entity fixed:
xxxxxxxxxx
1
import javax.persistence.*;
2
import java.util.Objects;
3
4
5
name = "users") (
6
public class UserEntity {
7
8
9
strategy = GenerationType.IDENTITY) (
10
private Long id;
11
12
private String name;
13
private int age;
14
15
// constructor
16
// getters, setters
17
}
0 commentsShow commentsAdd comment