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 Patty Isecke
Appian Employee
over 10 years ago

Try this:
1. standalone.xml
Update your driver definition FROM
<driver name="com.mysql.jdbc" module="com.mysql.jdbc">
<xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
</driver>
TO
<driver name="com.mysql.jdbc" module="com.mysql.jdbc" optional="true">
<xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
</driver>

2. Appian-ds.xml
Update the follow lines for your secondary datasource FROM
<xa-datasource-property name="serverName">dbserver</xa-datasource-property>
<xa-datasource-property name="portNumber">3306</xa-datasource-property>
<xa-datasource-property name="databaseName">secondarydb</xa-datasource-property>
TO
<xa-datasource-property name="URL">jdbc:mysql://dbserver:3306/secondarydb?useOldAliasMetadataBehavior=true&useServerPrepStmts=true</xa-datasource-property>
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Patty Isecke
Appian Employee
over 10 years ago

Try this:
1. standalone.xml
Update your driver definition FROM
<driver name="com.mysql.jdbc" module="com.mysql.jdbc">
<xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
</driver>
TO
<driver name="com.mysql.jdbc" module="com.mysql.jdbc" optional="true">
<xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
</driver>

2. Appian-ds.xml
Update the follow lines for your secondary datasource FROM
<xa-datasource-property name="serverName">dbserver</xa-datasource-property>
<xa-datasource-property name="portNumber">3306</xa-datasource-property>
<xa-datasource-property name="databaseName">secondarydb</xa-datasource-property>
TO
<xa-datasource-property name="URL">jdbc:mysql://dbserver:3306/secondarydb?useOldAliasMetadataBehavior=true&useServerPrepStmts=true</xa-datasource-property>
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data