Spring Data JPA Native Query paging

Mysql

Spring Data JPA and native queries with pagination

Spring Data and Native Query with pagination

public interface UserRepository extends JpaRepository<User, Long> {    @Query(value = "select * from users order by id desc \n#pageable\n",            countQuery = "select count(*) from users",            nativeQuery = true)    Page<User> findAllRandom(Pageable pageable);}

If there is a sort in the Pageable object, sorting can be removed here order by .
countQuerycan be omitted.

H2

The H2 database will be \n#pageable\n changed into a \n-- #pageable\n form.

Oracle

Spring Data JPA Local query (with paging)

The Oracle database will be \n#pageable\n changed to ?#{#pageable} form.

Spring Data JPA Native Query paging