Hi, I'm currently fixing a bug in an older legacy system of ours.

Hi,

I'm currently fixing a bug in an older legacy system of ours. As part of it's operation, this process relies on using ACPs as part of a query to the DB to limit the amount of results. Here's the query:

SELECT DISTINCT ID
FROM a
Limit ac!startRow, ac!endRow

Now, if I open that node and then try to save it (by clicking "ok") it returns me this error:

The database returned ARV's that may not be supported. Message: 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 \\'\\'\\', \\'\\'\\' at line 4

I've tried using three version of the connector, in case it was a JDBC bug, but no go. Does anyone have any idea how I can resolve this?...

OriginalPostID-87122

OriginalPostID-87122