Skip to content
Advertisement

Tag: jpa

JPA Batch inserts with non auto generated id

im triying to batch insert a few Million Entitys. The Batch insert kind of works, but my programm executes a few JDBC Statements in the background which i dont want. } my Repository: my Entity: my JPA Settings: The Batch Insert Does work, but if i try to Upload 100 Entitys i have 33 JDBC Statements which are checking the

Cursor based pagination for table without a unique and sequential id column?

I’m investigating using cursor-based pagination. I have the following (postgres) table: and had begun to sketch out the pagination query (not tested): I’ve been reading these posts: https://slack.engineering/evolving-api-pagination-at-slack-1c1f644f8e12 https://engineering.mixmax.com/blog/api-paging-built-the-right-way/ https://coderwall.com/p/lkcaag/pagination-you-re-probably-doing-it-wrong which both state that the cursor should be a unique, sequential column to paginate on. However, my table does not have an auto-incrementing sequential primary key. Instead it’s primary key

Advertisement