JPA sequence generator says increment size differs from the value in DB

Question

@Table(name = "CACHING_DATA")
@Entity
public class CachingData implements Serializable {
    @Id
    @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "CACHING_SEQUENCE")
    private Long id;
    private String protocolecode;
    private String uuid;
}

I have above entity class and oracle sequence. But I am getting following error.

Caused by: org.hibernate.MappingException: The increment size of the [CACHING_SEQUENCE] sequence is set to [50] in the entity mapping while the associated database sequence increment size is 1.

Drop and recreate the database, might be helpful – Romil Patel Jun 24 '20 at 14:29 — Romil Patel, Jun 24 '20 at 14:29

Adata · Accepted Answer · 2020-06-24T15:23:17.353

3

You can use allocationSize = 1 for the sequence

@SequenceGenerator(name = "SomeNameForTheGenerator", sequenceName = "CACHING_SEQUENCE", allocationSize = 1)

here the samish issue: org.hibernate.MappingException: The increment size of the sequence is set to [10] in the entity mapping while ... size is [1]

edited Jun 24 '20 at 15:23

answered Jun 24 '20 at 15:10

Adata

84
6

Any idea what that would look like as .hbm.xml? – d00d Oct 28 '22 at 13:02

JPA sequence generator says increment size differs from the value in DB

1 Answers1