JCR jackrabbit pagination

Question

I'm using the following JCR-SQL2 Query to retrieve some files from jackrabbit repository

    SELECT id FROM [nt:file]
  WHERE ISDESCENDANTNODE([/repo/cms]) 

How can I use pagination in jackrabbit to retrieve only a limit number of files.

I mean the COUNT in MS-SQL or LIMIT in MySQL

Answer 1

How about this:

Query query = queryManager.createQuery(queryString, Query.SQL);
QueryImpl q = (QueryImpl) query;
q.setLimit(10);
q.setOffset(10); // Start from the 10:th file
QueryResult result = q.execute();