topic Re: Editing tMySQLInput SQL query in Designer mode generates bad Code syntax in Talend Studio

Editing tMySQLInput SQL query in Designer mode generates bad Code syntax

Anonymous — Thu, 28 Jun 2018 22:12:34 GMT

I dragged a DB table from my Metadata tree onto my canvas and created a MySQL DB Input. The default SQL query pulls all the records in the table. I modified the query by adding a WHERE clause at the end to only retrieve certain records that I need to update.

Now I cannot get my job to compile because of a syntax error in my code. When I switch from the Designer mode to the Code mode I can see that my addition is not being correctly incorporated into the query string. My additional line is not being wrapped in quotes and appended with a '+' operator as it should be. I am unable to edit the code side directly and nothing I do on the Designer side is resulting in correct code. What am I missing here?

Re: Editing tMySQLInput SQL query in Designer mode generates bad Code syntax

Anonymous — Thu, 28 Jun 2018 22:31:00 GMT

This is strange and for sure not your fault.

Actually I do not use this feature, instead I ALWAYS design my queries outside Talend in a real SQL tool like DBeaver and check the query always with a explain plan to avoid long running queries.

Next I am usually never happy with the way, Talend Studio creates select SQL statements, because of the always full qualified identifier which blows up the SQL code.

Re: Editing tMySQLInput SQL query in Designer mode generates bad Code syntax

Anonymous — Mon, 02 Jul 2018 14:54:04 GMT

There's nothing wrong with my query, just that the tool is failing to incorporate my query correctly. Is there an alternative method you use?

Re: Editing tMySQLInput SQL query in Designer mode generates bad Code syntax

Anonymous — Mon, 02 Jul 2018 15:24:31 GMT

When I try to change the SQL back to the original statement by deleting my WHERE clause, the code window no longer updates to reflect my changes. It keeps my line there with the compilation error. Can someone please explain to me how and when the underlying code is synced with changes made on the Designer side?

Re: Editing tMySQLInput SQL query in Designer mode generates bad Code syntax

Anonymous — Mon, 02 Jul 2018 15:33:55 GMT

I have tried deleting the tDBInput element altogether and recreating it...twice now. The name of my input is tDBInput_3. When I go to the Code view, the errors in my code are variables referencing tDBInput_1, which no longer exists. Why isn't my code updating to match the designer window? How can I force a regeneration of the underlying java code?

Re: Editing tMySQLInput SQL query in Designer mode generates bad Code syntax

Anonymous — Tue, 03 Jul 2018 10:09:32 GMT

Have you tried typing the query without newline?