Max Records with MySQL


My environment is JEE with Oracle database. I'm developing an application that consumes a MySQL database through Integration Studio and that's working fine, but I can't set the Max. Records value in my Advanced Queries. I get the exception:  You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';.

I believe that this problem is related to the difference between Oracle and MySQL. Because my environment is Oracle the application is trying to set the limite using ROWNUM, and MySQL expects LIMIT.

Can anyone help?

No, that shouldn't be it.

The OutSystems Platform knows to which database type it's connecting to in each connection, so it won't be trying to generate Oracle code on your MySQL database connection.

What version of MySQL are you using?

Do you have a module that reproduces the issue?
I tried to create a module do reproduce the issue and then I saw in my query that I had a ";" in the end of the statement. That's causing the issue.

Thanks Ricardo.