spring data jpa @query and pageable

Question

I'm using Spring Data JPA, and when I use @Query to to define a query WITHOUT Pageable, it works:

public interface UrnMappingRepository extends JpaRepository<UrnMapping, Long> {     @Query(value = "select * from internal_uddi where urn like %?1% or contact like %?1%",             nativeQuery = true)     List<UrnMapping> fullTextSearch(String text); } 

But if I add the second param Pageable, the @Query will NOT work, and Spring will parse the method's name, then throw the exception No property full found. Is this a bug?

public interface UrnMappingRepository extends JpaRepository<UrnMapping, Long> {     @Query(value = "select * from internal_uddi where urn like %?1% or contact like %?1%",            nativeQuery = true)     Page<UrnMapping> fullTextSearch(String text, Pageable pageable); } 

Answer 1

You can use pagination with a native query. It is documented here: Spring Data JPA - Reference Documentation

"You can however use native queries for pagination by specifying the count query yourself: Example 59. Declare native count queries for pagination at the query method using @Query"

public interface UserRepository extends JpaRepository<User, Long> {    @Query(value = "SELECT * FROM USERS WHERE LASTNAME = ?1",     countQuery = "SELECT count(*) FROM USERS WHERE LASTNAME = ?1",     nativeQuery = true)   Page<User> findByLastname(String lastname, Pageable pageable); }