topic Re: [resolved] tJava null result for globalMap.get("tELTOracleMap_1_QUERY") in Talend Studio

[resolved] tJava null result for globalMap.get("tELTOracleMap_1_QUERY")

Anonymous — Tue, 23 Dec 2014 04:52:22 GMT

I get a null result for ((String) globalMap.get("tELTOracleMap_1_QUERY")) in tJava Component. I tried enabling debug mode by checking advanced setting of tELTOracleMap . However, I did not find any such option.
Below is the Job Screen Shot That I am using.
Please guide.

Re: [resolved] tJava null result for globalMap.get("tELTOracleMap_1_QUERY")

Anonymous — Tue, 23 Dec 2014 06:48:20 GMT

Hi,

Thank you for your post! We can't see the screenshot on our side. Could you attach it on the forum again, please? That would be great.

Best regards
Sabrina

Re: [resolved] tJava null result for globalMap.get("tELTOracleMap_1_QUERY")

Anonymous — Tue, 23 Dec 2014 08:11:48 GMT

Please refer to the screen shot.
I get a null result for ((String) globalMap.get("tELTOracleMap_1_QUERY")) in tJava Component. I tried enabling debug mode by checking advanced setting of tELTOracleMap . However, I did not find any such option.
Below is the Job Screen Shot That I am using.
Please guide.

Re: [resolved] tJava null result for globalMap.get("tELTOracleMap_1_QUERY")

Anonymous — Tue, 23 Dec 2014 09:48:34 GMT

Hi,
Actually, we don't find this global variable ((String) globalMap.get("tELTOracleMap_1_QUERY")) defined in tELTOracleMap. Could you please give us more information about job requirment?
Best regards
Sabrina

Re: [resolved] tJava null result for globalMap.get("tELTOracleMap_1_QUERY")

Anonymous — Tue, 23 Dec 2014 10:55:54 GMT

Hello,
As per the reply for this post .
I tried using the variable.

Requirement: I am trying to add two tables on some key. The sql will be generated in result of this joins. This SQL can be viewed by clicking tELTOracleMap and selecting tab "Generated SQL Query". I want to read this using program so I am using globalMap with key as tELTOracleMap_1_QUERY . The same solution was suggested in above liked post, However, I get null value instead of query .

Re: [resolved] tJava null result for globalMap.get("tELTOracleMap_1_QUERY")

Anonymous — Thu, 25 Dec 2014 08:30:00 GMT

Hi mnavedqureshi,
Is your issue resolved? Could you please share your solution with us?
Best regards
Sabrina

Re: [resolved] tJava null result for globalMap.get("tELTOracleMap_1_QUERY")

Anonymous — Thu, 25 Dec 2014 13:05:37 GMT

Yes.
Thankyou xdshi.
Issue is resolved. Key for globalMap should be tELTOracleMap_1QUERYtable1.