#MySQL error: I am using a query node (in Appian not installed on cloud) to

iainf over 10 years ago

#MySQL error:
I am using a query node (in Appian not installed on cloud) to connect with a MySQL DB with the following query:
select id from canceltasks limit 999 offset ac!offset
and am getting the following 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 1
Can anyone help to debug?
Thanks...

Discussion posts and replies are publicly visible

Parents

0 Eduardo Fuentes
Appian Employee
over 10 years ago

What version of the MySQL driver are you using? I've seen this issue with versions newer than mysql-connector-java-3.1.14-bin.jar. You can try using this previous version of the JAR or modeling this (if the requirement allows it) using the BETWEEN function or a stored procedure
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Eduardo Fuentes
Appian Employee
over 10 years ago

What version of the MySQL driver are you using? I've seen this issue with versions newer than mysql-connector-java-3.1.14-bin.jar. You can try using this previous version of the JAR or modeling this (if the requirement allows it) using the BETWEEN function or a stored procedure
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data