Pagination with spring boot usiing jpa

Question

How can I implement a method that return a page of objects using JpaRepository and not PagingAndSortingRepository ?

My repository

public interface GroupRepository extends JpaRepository<Group, Long> { @Query(value = "SELECT g FROM Group") Page<Group> listAllByPage(Pageable pageable); }

My service implementation:

@Override public Page<Group> findGroupesByPagination(Pageable pageable) { return groupeRepository.listAllByPage(pageable); }

My rest Controller method:

@RequestMapping(value="/groups", method = RequestMethod.GET) public @ResponseBody Page<Group> list( Pageable pageable){ Page<Group> groupes = groupeServiceImpl.findGroupesByPagination(pageable); return groupes; }

Finally I got this error:

Error creating bean with name 'groupServiceImpl': Unsatisfied dependency expressed through field 'groupeRepository'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'groupRepository': Invocation of init method failed; nested exception is java.lang.IllegalArgumentException: Validation failed for query for method public abstract org.springframework.data.domain.Page rimtrack.org.repository.GroupRepository.listAllByPage(org.springframework.data.domain.Pageable)!

Try to add 'g' after 'Group' in select query: "select g from Group g" — Cepr0
– Cepr0, Commented Apr 14, 2017 at 10:22

ooozguuur · Accepted Answer · 2017-04-14 09:21:46Z

The query can be defined by an annotation somewhere or declared by other means. Consult the documentation of the specific store to find available options for that store. If the repository infrastructure does not find a declared query for the method at bootstrap time, it fails.

You should using Spring Data Jpa method. Reference

 Page<T> findAll(Pageable pageable);

Please change repository class.

Exam:

public interface GroupRepository extends JpaRepository<Group, Long> { Page<Group> findAlll(Pageable pageable); }

thanks for your response but i got the same error what should i do please help

Collectives™ on Stack Overflow

Pagination with spring boot usiing jpa

1 Answer 1

10 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

10 Comments

Linked

Related