How to view SQL executed

[Anonymous]

Hi,
I'm new user of TOS.
I would like to view SQL generated and executed by TOS to store in log file.
I create a job to read data from spreadsheet file and insert it into database (MySQL).
It's work fine, but I don't know how to visualize SQL executed in my database.
I use the tLogRow component to view data but output isn't SQL but raw data.
I try checking Enable debug mode in advanced settings in tMySQLOutput component but nothing changes.
Does anyone know how to view/store SQL ?
Thx in advance.
Informations:
- TOS 3.0.1.r19980
- Vista SP1
- Java project

[_AnonymousUser]

I confirm the null output of
System.out.println(((String)globalMap.get("tMysqlOutput_1_QUERY")));

[_AnonymousUser]

I also confirm System.out.println(((String)globalMap.get("tMysqlOutput_1_QUERY"))); produces a bunch of nulls.

[Anonymous]

does anyone know if this is working yet i am also getting nulls when i try pass a var from SQL to tJAVA

[Anonymous]

From this post:

https://community.talend.com/t5/Design-and-Development/Generated-Sql-Insert-statement/td-p/101412
You need to check "Enable debug mode" in the MysqlOutput_1 advanced settings, in order for:
System.out.println(((String)globalMap.get("tMysqlOutput_1_QUERY"))); to return a non-null value.