Database Connector

0
Hey all, I'm using Database Connector connector and I'm trying to use Limit and offset but seems is not possible. Why I need it? I need to transfer around 500 000 objects from external database to Mendix and I don't wanna risk to have Java heap error during the action. This is how my sql is looking but Mendix is throwing error. SELECT String AS "String" from Table order by String limit 100 offset 1000
asked
1 answers
0

Hello Slavko,

 

I could find the following online for oracle db limit and offsetting, it uses offset and fetch:

 

SELECT employeeid, firstname, revenueFROM sales.employeeORDER BY revenue descOFFSET 2 ROWSFETCH NEXT 4 ROWS ONLY0

 

oracle documentation

 

Hope this fix it for you,

 

Good luck!

 

answered