Variables, globalmap and built job

jcpreaux — Thu, 05 Jan 2017 17:34:22 GMT

Hello,

I've a job in which i use a tJava component to produce variables whom i put in globalmap.

tJava :
String moisPrec = TalendDate.formatDate("yyyyMM", TalendDate.addDate(TalendDate.getCurrentDate(), -1, "MM"));
globalMap.put("moisPrec",moisPrec);
...
And i get it in a sql query (tmysqlinput) :
"SELECT * FROM mytable
WHERE field = "+((String)globalMap.get("moisPrec"))+ " AND ..."
My trouble is when i launch the job from the studio the value of "moisPrec" is well resolved but when i launch the job from the standalone bult job (.bat), the value is "null".
(The snapshot below show the tJava and the tMysqlInput.)
I don't know where is my mistake, any help welcome.

Thanks

JCPreaux

Re: Variables, globalmap and built job

Anonymous — Fri, 06 Jan 2017 08:52:28 GMT

Hi,
We can't see the screenshot on our side. Could you attach it on the forum, please? That would be great.
Best regards
Sabrina

Re: Variables, globalmap and built job

jcpreaux — Fri, 06 Jan 2017 15:53:31 GMT

With the screenshot...

topic Variables, globalmap and built job in Talend Studio

Variables, globalmap and built job

Re: Variables, globalmap and built job

Re: Variables, globalmap and built job