topic not able to print DBInput_1_Query in Talend Studio

not able to print DBInput_1_Query

IamHulk — Sat, 16 Nov 2024 03:16:46 GMT

my job flow like

tfileinputDelimted--main-->tflowtoiterate--iterate-->tdbinput--main-->tjava

input file is txt its having schema and table name. in dbinput component im writing query like select * from schema.table;

i'm getting output as expected. but while i'm printing source query in java its printing null.

in tjava i'm printing like system.out.println(((string)globalMap.get("tdbinput_1_query"));

nivedhitha — Thu, 13 Feb 2020 18:17:54 GMT

can you provide screenshots of your jobs?

mks02 — Fri, 14 Feb 2020 02:24:39 GMT

To print the sql query in tjava, you need to print the query on OnSubJobOK as below:

t<DB>Input -- t<DB>Output

| OnSubjobOk

tJava

System.out.println("tJavaTable:TBL Loaded" + (String)globalMap.get("tMysqlInput_1_QUERY"));

Thanks.