Problems for create sequence in PostgreSQL and SpringBoot (JPA)

Question

I have a problem for create a sequence in PostgreSQL, I use a SpringBoot/Hibernate/JPA for this issue, When the application will create tables and sequences, Hibernate don´t use the schema property for @SequenceGenerator.

   @Entity
   @Table(schema=Schemas.ADMIN, name="tbl_client")
   public class Client implements CommonsEntity<Integer>{

   private static final long serialVersionUID = 1L;

   static final String SQ_CLIENT = "sq_client";

   @Id
   @Column(name="id_client")
   @GeneratedValue(generator=Client.SQ_CLIENT, strategy=GenerationType.AUTO)
   @SequenceGenerator(schema=Schemas.ADMIN, name=Client.SQ_CLIENT    sequenceName=Client.SQ_CLIENT, initialValue=1, allocationSize=1)
   private Integer id;

The sequence created in Postgre is: create sequence sq_client

I use SpringBoot 1.3.5 and Hibernate 4.3.11.

Thanks.

I resolved using Hibernate version 5 and SpringBoot 1.4.X.

Caio
– Caio

2016-12-13 14:24:17 +00:00
Commented Dec 13, 2016 at 14:24 — Caio
– Caio, Commented Dec 13, 2016 at 14:24

Shweta Shaw · Accepted Answer · 2019-06-16 12:21:59Z

3

I think you are using incorrect strategy for GeneratedValue.

  @Id
  @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = SQ_CLIENT)
  @SequenceGenerator(name = SQ_CLIENT, sequenceName = SQ_CLIENT,
      allocationSize = 1,initialValue=1)
  private long id;

answered Jun 16, 2019 at 12:21

Shweta Shaw

535 bronze badges

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

Collectives™ on Stack Overflow

Problems for create sequence in PostgreSQL and SpringBoot (JPA)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related