Does it ever fork for anyone? ((String)globalMap.get("tDBRow_1_QUERY"))

Five Stars

Does it ever fork for anyone? ((String)globalMap.get("tDBRow_1_QUERY"))

Hi folks

 

I wonder whether this approach forks for anyone in order to catch a real SQL statement executed in a component tDBRow?

 

I saw few references to this way but in my case it always returs null. And I found no confirmations from users that it works.

null.PNG

 

tJava_2:

System.out.println(
((String)globalMap.get("row10"))+
((String)globalMap.get("tDBRow_1_QUERY"))
);

and the output is:

[statistics] connecting to socket on port 4009
[statistics] connected
nullnull

And yes, the constraction ((String)globalMap.get("row10")) does not work in my case either. 

 

Is there any user here havsing success on this?

 

Thanks and regards,

Alex


Accepted Solutions
Highlighted
Sixteen Stars
Sixteen Stars

Re: Does it ever fork for anyone? ((String)globalMap.get("tDBRow_1_QUERY"))

Because tJava component is executed first but only once in the subjob.

Use tJavaFlex or tJavaRow instead.


TRF

View solution in original post


All Replies
Highlighted
Sixteen Stars
Sixteen Stars

Re: Does it ever fork for anyone? ((String)globalMap.get("tDBRow_1_QUERY"))

Because tJava component is executed first but only once in the subjob.

Use tJavaFlex or tJavaRow instead.


TRF

View solution in original post

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog