version 2.1.0 is incompatible with Oracle Database

[sungongpeng]

Version 2.1.0
Database: Oracle 19c
Issue 1: query build
appending "OFFSET n LIMIT m" to a query, This is incorrect for Oracle database.

For Oracle, the correct
SELECT * FROM TABLE offset n rows FETCH NEXT m rows ONLY

Issue 2: $count
got error:
class java.math.BigDecimal cannot be cast to class java.lang.Long (java.math.BigDecimal and java.lang.Long are in module java.base of loader 'bootstrap'

[sungongpeng]

look like Pull Request
#303
would fix Issue 2: $count

Issue 1: query build
need a fix for oracle, like the fix for Sysbase in pull/303

[wog48]

For a quick fix you remove module odata-jpa-processor-cb from you pom.xml or gradle file.

Try to generalize PR 303

[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.