search

SAP / olingo-jpa-processor-v4

The JPA Processor fills the gap between Olingo V4 and the database, by providing a mapping between JPA metadata and OData metadata, generating queries and supporting the entity manipulations.
Apache License 2.0
121 stars 76 forks source link

version 2.1.0 is incompatible with Oracle Database #307

Open sungongpeng opened 1 month ago

sungongpeng commented 1 month ago

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 commented 1 month ago

look like Pull Request https://github.com/SAP/olingo-jpa-processor-v4/pull/303 would fix Issue 2: $count

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

wog48 commented 1 month ago

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

Try to generalize PR 303