java - How to add limit to Hibernate query annotation? -

java - How to add limit to Hibernate query annotation? -

i have in java hibernate

@query("select dirpar directiveparagraph dirpar, directive dir " + "where dirpar.directive = dir " + "and dir.txtdircode = :txtdircode "); list<directiveparagraph> getbyname(@param("txtdircode") string name, @param("page") int page ,@param("size") int size);

i want retrieve limit , size, same way

select * tbldirectiveparagraph intdirectiveid = 1 limit 10,10;

how add together limit above @query annotation

you can seek adding pageable parameter getbyname method

@query("select dirpar directiveparagraph dirpar, directive dir " + "where dirpar.directive = dir " + "and dir.txtdircode = :txtdircode "); list<directiveparagraph> getbyname(@param("txtdircode") string name, pageable page);

and here's sample method call:

public void somemethod(){ pagerequest pager = new pagerequest(10,10); directiveparagraphrepository.getbyname("txtdircode",pager); }

java mysql hibernate jdbc spring-data-jpa