search

cismet / cids-server

Server components of the cids system.
GNU Lesser General Public License v3.0
5 stars 0 forks source link

LIMIT and OFFSET not supported in ORACLE queries #182

Open p-a-s-c-a-l opened 8 years ago

p-a-s-c-a-l commented 8 years ago

LIMIT and OFFSET not supported in ORACLE queries

http://localhost:8890/UDM2020-DI.GWK?role=all&limit=100&offset=0&omitNullValues=true&deduplicate=false

SELECT 261, GWK.ID FROM GWK ORDER BY GWK.ID ASC LIMIT 100 OFFSET 0;

-> ORA-00933: SQL-Befehl wurde nicht korrekt beendet

p-a-s-c-a-l commented 8 years ago

getMetaObjectsByQuery('SELECT 261, GWK.ID FROM GWK ORDER BY GWK.ID ASC LIMIT 100 OFFSET 0;' ...) in cids-server-rest-legacy LegacyEntityCore.getAllObjects()

-> Introduce getAllMetaObjects(..., limit, offset) Methods required by cids-server-rest legacy.

ci-cismet-de commented 7 years ago

Integrated branch 'bug/182-sql-queries (7711e9a5d6ecc639b29d7b5d17c6b442ace308fd)' into 'dev (6f24d9be13482ee6a209c784c5105dc6de8c25b2)' -- Build 361