Can I do pagination with spring-data-jdbc?

Question

I would like to use PagingAndSortingRepository with spring-data-jdbc but it not seem to work. It's only available with JPA ?

I tried to use PagingAndSortingRepository and use the findAll(Pageable pageable).

But I actually get a "No query specified on findAll"

score 5 · Answer 1 · answered Aug 06 '20 at 18:10

5

2020 Update

Support for PagingRepositories was introduced at version 2.0.0.M3 (2020-02-12).

answered Aug 06 '20 at 18:10

Gabriel Kaio

Jens Schauder · Accepted Answer · 2021-03-04T15:59:39.203

3

PagingAndSortingRepository is supported since version 2.0 M3

That version wasn't available when this question was asked.

Original answer

Yes, you are right, pagination isn't ready yet.

There is actually a PR that will create infrastructure for that but it won't enable the feature yet. For that you should watch https://jira.spring.io/browse/DATAJDBC-101.

edited Mar 04 '21 at 15:59

answered Apr 08 '19 at 09:49

Jens Schauder

Thank you, is not clear on documentation because the pagination is on the commons part (jpa/jdbc). Or maybe i miss it ? – MarS Apr 08 '19 at 09:54
yeah, that is rather unfortunate. – Jens Schauder Apr 08 '19 at 10:22

2 Answers2