v2.1.0, $count is not working whatsoever; pagination is not working

[akaFood]

when using $count = true or enable paginaiton, the following error is returned:
"class java.lang.Integer cannot be cast to class java.lang.Long (java.lang.Integer and java.lang.Long are in module java.base of loader 'bootstrap')".
The error was thrown at JPAExamplePagingProvider.class, getFirstPageMethod, Long maxResults = countQuery.countResults();.
Inside JPAJoinCountQuery.class, line 47 - return (Long) result.get(0); I saw that the total records count returned was Integer type, and its getting casted to Long, hence why the error occurred.

[wog48]

What database do you use?

[akaFood]

What database do you use?

DB2

[wog48]

The latest changes in version 2.2.0 should solve the problem with OFFSET and LIMIT. Please be aware that also OData indexof, which is converted by default into SQL locate, and OData substring, by default converted into SQL substring, may cause issues with Oracle. In case you need them, an implementation of ProcessorSqlPatternProvider needs to be provided via the session context. You can use JPADerbySqlPatternProvider or JPAPostgresqlSqlPatternProvider as an example.