JPQL
does not provide a mechanism to limit queries. This is most often achieved by using the setMaxResults()
method on the Query
. If you must avoid specifying this in Java code, you could make a view in the database that contains your query and performs the limit. Then map an entity to this view as you would a table.
Example:
List<String> resultList= query.setMaxResults(100).getResultList();