Getting next value from sequence with jpa repository in postgreSQL

Question

I've seen the similar question, but in my situation it doesn't work. I need to get the next value of the sequence.

Model class:

@Entity
@Table(name = "item")
public class Item {
    @Id
    @SequenceGenerator(name = "id_seq", sequenceName = "item_id_seq", allocationSize = 1)
    @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "id_seq")
    @Column(name = "id", updatable = false)
    protected Long id;
}

Jpa Repository:

public interface ItemRepository extends JpaRepository<Item, Long> {
    List<Item> findFirst10ByOrderByPublicationDateDesc();

    @Query(value = "SELECT item_id_seq.nextval FROM item", nativeQuery = 
    true)
    Long getNextSeriesId();
}

I would appreciate any help.

Geha · Accepted Answer · 2017-11-25 21:30:39Z

19

I've found solution:

@Query(value = "SELECT nextval('item_id_seq')", nativeQuery =
            true)
    Long getNextSeriesId();

My mistake was that I used oracle syntax instead of postgreSQL, which I am using.

answered Nov 25, 2017 at 21:30

Geha

1,4852 gold badges12 silver badges18 bronze badges

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

Comments

Pravind Kumar · Accepted Answer · 2025-02-09 06:05:32Z

0

The same issue I also faced. The DB has sequecne under schema and after adding schema it working fine. My code is like -

@Entity
@Table(name = "Contact", schema = "tshema")
public class ContactUs implements AppEntity {

    @Id
    @SequenceGenerator(name = "OID_SEQ", sequenceName = "CONTACTUS_OID_SEQ", allocationSize = 1, schema = "tshema")
    @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "OID_SEQ")
    @Column(name = "oid", unique = true, nullable = false, updatable = false)
    private Long oid;
}

answered Feb 9 at 6:05

Pravind Kumar

9311 gold badge11 silver badges10 bronze badges

Collectives™ on Stack Overflow

Getting next value from sequence with jpa repository in postgreSQL

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related