Limit findAll possible with Spring?

If you dont have a Pageable object that came from your controller and just need to get X amount of objects from DB, you can do the following:

First, your Repository class has to extend JpaRepository<T, ID> so it wil be able to query using a Pageable object.

Second, you can define a Pageable object this way:

Pageable limit = PageRequest.of(0,10);
return repository.findall(limit);

In this case, the query would return the first 10 objects.

You can find more info here (Scroll down to 4.1, Example 4) Note that the example actually extends PagingAndSortingRepository but JpaRepository contains all the methods from PagingAndSortingRepository and has additional functions aswell.

Edit: Thanks to @Zunnii for pointing out that new PageRequest() is now deprecated. I edited the snippet above to reflect that.

Pass a Pageable as a parameter like following:

Page<x> findAll(Pageable pageable);