Dynamic query in global variable to be used in tMySQLRow
Hi everyone!
I am generating a dynamic query in tjavaFlex and storing it into global variable.
It is similar to this :globVar = insert into test(id,name) values('"+row1.line.split(",")[0]+"','"+row1.line.split(",")[1]+"')
When I use this global variable in tmysqlrow's query tab( for which the input is row1.line), it inserts extra single quote at the start and end which is creating an issue for me.
If i manually pass the global variable with double quotes at start and end, it works fine.
Any help guys? I am even storing the globVar in a file. and the query is generated fine.
Can you show us exactly what you use to set this in the tJavaFlex and exactly what you use in your DB component? Giving us a pseudocode version isn't enough to identify the issue I'm afraid.
Part1: So there is delimited file with header is "id,name"
tjavaFlex reads the header and creates a query as : insert into test(id,name) values('"+row1.line.split(",")[0]+"','"+row1.line.split(",")[1]+"')
this query is saved in a globalMap.
Part2. tmysqlrow reads input file rows (row1) which has just one column for e.g : 1,john, and i have used globalMap variable in the query tab. Please see the screenshot.
It inserts "'"+row1.line.split(",")[0]+"' and '"+row1.line.split(",")[1]+"' in the table.
But if i copy the generated query within double quotes, it populates actual values in the table i.e. 1 , John.
I see. You cannot store Java code inside a Java variable. It will be treated as a Java String. This is what is happening in your job. What is wrong with the method of adding the code directly to the DB component? Does this break a requirement somewhere?
