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

arpitg over 10 years ago

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?...

Discussion posts and replies are publicly visible

Parents

0 arpitg over 10 years ago

Hi Eduardo,

I've tried using both the newest version of the connector, and the version you listed in that comment, and neither solved this issue.

I don't want to rewrite the entire process to overcome this issue, as this would require significant regression testing effort.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 arpitg over 10 years ago

Hi Eduardo,

I've tried using both the newest version of the connector, and the version you listed in that comment, and neither solved this issue.

I don't want to rewrite the entire process to overcome this issue, as this would require significant regression testing effort.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data