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

iainf over 11 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

0 Eduardo Fuentes
Appian Employee
over 11 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
0 iainf over 11 years ago

Thanks very much for this- we will try mysql-connector-java-3.1.14-bin.jar
(we're currently using mysql-connector-java-5.1.23-bin.jar)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 iainf over 11 years ago

Eduardo, do you have a link to good documentation for installing MySQL connectors? We've tried to bring up our JBOSS but have an error and struggling to debug.. thanks.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Omkar Ambardekar
Certified Lead Developer
over 11 years ago

Iain, what version of Appian are you using? The documentation for installing MySQL connectors for Appian 7.2 is here - forum.appian.com/.../Configuring_Relational_Databases
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Eduardo Fuentes
Appian Employee
over 11 years ago

Is the error showing up now that you switched to this connector? if that is the case did you modify the module.xml to point to the new jar?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 iainf over 11 years ago

Omkar, we are on 7.2- thanks for the link.
Eduardo, yes, we pointed correctly in module.xml but we are still working on the installation- will keep you posted on this.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel