return resultMap // gets rendered as JSON. The JSON contains the count & the items for the current page
If the "params" map does not contain "offset", I get the results I expect. However, if I include "offset" and the number of items returned is small (I have not thoroughly investigated what qualifies as "small" but 2-5 records shows the problem), I get a correct result.totalCount, but "result" is empty.
For example, "offset=0" yields:
I have copy & pasted the SQL generated by Hibernate (with the offset clause) and the SQL returns the expected records.