Variables, globalmap and built job

[jcpreaux]

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

[Anonymous]

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

[jcpreaux]

With the screenshot...