I am getting below error while configuring Query Database Smart Service:-

vineeta6579 over 10 years ago

I am getting below error while configuring Query Database Smart Service:-

• 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

When I am passing static parameters it works but on passing activity variable it shows above error.

My-sql DB Version: 5.6.16
Appian Version: 7.5
Mysql JDBC Version: mysql-connector-java-5.1.31-bin.jar
...

Discussion posts and replies are publicly visible

Parents

0 vineeta6579 over 10 years ago

Thanks Eduardo.
Between clause is working for me. As you mentioned in other posts to use mysql-connector-java-3.x-bin.jar but Appian 7.5 support v5.1.14 or higher version only.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 vineeta6579 over 10 years ago

Thanks Eduardo.
Between clause is working for me. As you mentioned in other posts to use mysql-connector-java-3.x-bin.jar but Appian 7.5 support v5.1.14 or higher version only.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data