issue with where clause in mysql db component when comparing context variable with file name

Sudhee_Maximus — Fri, 15 Nov 2024 22:13:50 GMT

Hi There I am not able to figure out the reason behind the error in the place of FILENAME comparison with a context variable, I need to compare a filename stored in a context variable against the query with some other join values.

Unfortunately getting below error

Error :-

java.sql.SQLSyntaxErrorException: Unknown column 'XYZDATA_*****_********_****Test.dat' in 'where clause'

I want to know why this error occurs and how to solve this issue or what changes needed in the query to resolve this.

Thanks....

Re: issue with where clause in mysql db component when comparing context variable with file name

Anonymous — Tue, 03 Jan 2023 07:54:29 GMT

try to add single quotes to the value, eg:

"...where filename='"+context.filename+"'"

topic issue with where clause in mysql db component when comparing context variable with file name in Talend Studio

issue with where clause in mysql db component when comparing context variable with file name

Re: issue with where clause in mysql db component when comparing context variable with file name