DBJoin Issue After Upgrading to 4.1

CloverDX Platform
1

After upgrading Designer and Server to 4.1, the transforms in my DBJoin’s now throw an error - “An error occurred while extracting DB metadata: You have an error in SQL syntax; check the naual that corresponds to your MySQL server version for the right syntax to use near ‘?’ at line 1”. All of my graphs have been working for some time before the upgrade, so nothing has changed. I know I have a connection to the DB because I can see all the tables in the dialog. This is very frustrating because it’s stopping me from working.

2

In case anyone experiences this, I found the solution. The ? in the query now needs to be enclosed in single quotes. This is not documented as far as I can tell and is a change in behavior from the previous version. I’m using mySQL

3

Hi,

Could you please provide more information on the issue. I’m curious to know:

  • What DB connection your using?

  • What JDBC driver version and database version you are using?

  • Which version were you using previously and to which version did you upgrade to?

Also, it would be great if you could provide your graph.

4

I’m using MySQL via Rackspace’s Cloud DB service, I think they use MySQL 5. Not sure on the JDBC driver. I upgraded to 4.1.1 from 4.0.2 (I think). Nothing else changed in my environment, but the placeholder in the query below now needs the single quotes around it. Without the quotes, it’s generates the error I mentioned above.

<attr name="sqlQuery"><![CDATA[SELECT id FROM stores WHERE extid = '?']]></attr>

Also, it would be great if you could provide your graph.

5

Hi,

It appears that your experiencing an issue that was actually fixed in CloverETL 4.1.2, you can see more details on this here. I would recommend that you upgrade to aforementioned version.