Skip to content

Instantly share code, notes, and snippets.

View ATI-687's full-sized avatar

Kevin Veros Hamonangan ATI-687

  • DANA Indonesia
  • Jakarta, Indonesia
View GitHub Profile
@tcollins
tcollins / -Spring-JPA-Dynamic-Query-With-Limit
Last active February 22, 2024 10:21
Spring Data JPA - Limit results when using Specifications without an unnecessary count query being executed
If you use the findAll(Specification, Pageable) method, a count query is first executed and then the
data query is executed if the count returns a value greater than the offset.
For what I was doing I did not need pageable, but simply wanted to limit my results. This is easy
to do with static named queries and methodNameMagicGoodness queries, but from my research (googling
for a few hours) I couldn't find a way to do it with dynamic criteria queries using Specifications.
During my search I found two things that helped me to figure out how to just do it myself.
1.) A stackoverflow question.