Get nextvalue of sequence in postgres using JPA and not native query

Question

I have a sequence created using flyway in postgres which should start from 10000.

I want to get the next value of the sequence using JPA and not a native query , since i have different db platforms being run at different cloud providers.

I'm not able to find a JPA query to get the next value of a sequence, please redirect me to the right page if i am missing something already ..

Thanks for any help in that area though already!

P.S : I found this link which helps me doing the same with native query. postgresql sequence nextval in schema

Jens Schauder · Accepted Answer · 2019-03-14 09:19:07Z

1

I don't think this is possible in a direct way.

JPA doesn't know about sequences. Only the implementation knows about those and utilizes them to create ids.

I see the following options to get it to work anyway:

create a view in the database with a single row and a single column containing the next value. You can query that with native SQL which should be the same for all databases since it is a trivial select.
Create a dummy entity using the sequence for id generation, save a new instance and let JPA populate the id. A horrible workaround but pure JPA.
Bite the bullet and create a simple class that provides the correct native SQL statement to use for the current environment and execute it via JdbcTemplate.

answered Mar 14, 2019 at 9:19

Jens Schauder

82.6k35 gold badges199 silver badges379 bronze badges

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

Collectives™ on Stack Overflow

Get nextvalue of sequence in postgres using JPA and not native query

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related