topic Re: Nom de colonne non valide in Talend Studio

Nom de colonne non valide

hbensaid — Sun, 27 May 2018 15:26:53 GMT

Hi,

Can you please help to fix this issue:

i'm try to query Ratechange value from my MSSQL DB basing on the Rate selected from tfixFlow input(liste of value) but i'm getting this error after run job:

[statistics] connected
Exception in component tMSSqlInput_1 (SubJob_tRunjob)
java.sql.SQLException: Nom de colonne non valide : 'EUR'.

...

Thx in advance

Re: Nom de colonne non valide

TRF — Sun, 27 May 2018 15:59:06 GMT

Change the where clause like this:

... where RateChange.Rate = '" + (String)globalMap.get("row1.input") + "'"

beware of single quote before the 1rst double one and at the end of the where clause as you want the code generated looking like this:

... where RateChange.Rate = 'EUR'

Right?

Re: Nom de colonne non valide

hbensaid — Sun, 27 May 2018 17:03:50 GMT

Hi TRF,

It's work now thank you for your help & support.

Re: Nom de colonne non valide

TRF — Sun, 27 May 2018 17:28:20 GMT

Great!
Don't forget to mark your case as solved (Kudo also accepted)