Synapse not supporting pagination JPA

pankaj tiwari 1

When trying pagination with spring data jpa; getting duplicate records from other page and some records are being skipped.

KranthiPakala-MSFT 46,432 Reputation points Microsoft Employee

2020-09-30T01:26:44.187+00:00

Hi @pankaj tiwari ,

Welcome to Microsoft Q&A platform and thanks for using this forum.

I have reached out to internal team to get more info about your requirement. Will keep you posted as soon as I have an update from the team.

Thank you for your patience.
KranthiPakala-MSFT 46,432 Reputation points Microsoft Employee

2020-09-30T18:19:13.913+00:00
Hi @pankaj tiwari ,

Could you please confirm below details:

Are you using SQL pool or SQL on demand?

Is there a sample code/API that you could share with us?

Are you using Pageable interface?

How many records they are returning?

Looking forward to your response.

Thank you
KranthiPakala-MSFT 46,432 Reputation points Microsoft Employee

2020-10-01T21:44:14.5+00:00

Hi Pankaj,

Following up to see if you have got a chance to see my previous reply. If so could you please confirm above requested details.

Thank you
KranthiPakala-MSFT 46,432 Reputation points Microsoft Employee

2020-10-05T19:05:05.223+00:00

Hi there,

We still have not heard back from you. Just wanted to check if you still need assistance on this query? In case If you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.

Thank you