topic Re: Null value when reading from mysql in Talend Studio

Null value when reading from mysql

Anonymous — Sat, 16 Nov 2024 08:04:50 GMT

Hi all,

I want to assign a single value from mysql to a context variable using the following job:

tMysqlinput --> max_finding1(main) --> tJava (a screenshot is also attached)

tMysqlinput returns only one value:

"select max(id) as mysql_finding_id from finding;"

tJava :

System.out.println(max_finding1.mysql_finding_id);
context.db_id=max_finding1.mysql_finding_id;

but I'm getting a null value as a result. while printing the result to a log, I can see the corrected value.

Do someone knows why I get null?

Thanks

manodwhb — Tue, 19 Jun 2018 06:00:20 GMT

@Emmaber,you need to re-design a job that below way.

tMysqlinput-->tSetGlobalvar

-->on Subjob then put tJava and pint the global variable value.

to know more about tSetGlobalvar use below link.

Anonymous — Tue, 19 Jun 2018 08:31:45 GMT

It works, thank you

manodwhb — Tue, 19 Jun 2018 08:35:19 GMT

You are welccoem!!,Kudos also accepted.