topic Re: how to log executed query to console? (tOracleRow) in Talend Studio

how to log executed query to console? (tOracleRow)

Anonymous — Thu, 30 Jul 2015 09:36:01 GMT

Need to log the executed query used within the tOracleRow component to the console window in order to have a complete Job execution protocol. Any idea how to log the query?

Re: how to log executed query to console? (tOracleRow)

Anonymous — Tue, 11 Aug 2015 09:27:16 GMT

Hi,
Here is a global variable ((String)globalMap.get("tOracleRow_1_QUERY")) from tOracleRow which is the SQL query statement being processed.
Best regards
Sabrina

Re: how to log executed query to console? (tOracleRow)

Lorenzo5 — Wed, 16 Nov 2016 10:18:30 GMT

Hi,
Here is a global variable ((String)globalMap.get("tOracleRow_1_QUERY")) from tOracleRow which is the SQL query statement being processed.
Best regards
Sabrina

Hi Sabrina,
is there any way to be able to enable/disable query logging for most/all DB components in a job, for debugging purpose?
I could use one/many tJava component(s) (one it'd be better), and 'println' any query I need to log, but sometime it is not so easy to find out where to link the tJava component for a good flow design and optimization.
Any suggestion?
Thank you,
Lorenzo

Re: how to log executed query to console? (tOracleRow)

vapukov — Wed, 16 Nov 2016 10:45:53 GMT

generally query - most easiest part for debug
You always can catch them from database side

Re: how to log executed query to console? (tOracleRow)

Lorenzo5 — Wed, 16 Nov 2016 11:19:14 GMT

generally query - most easiest part for debug
You always can catch them from database side

Sometime jobs are a better common point where to implement different monitoring/debug policies, to decide which queries to log, for example when you interact with different databases and/or a lot of clients and jobs are querying at the same time.

Re: how to log executed query to console? (tOracleRow)

vapukov — Wed, 16 Nov 2016 11:35:45 GMT

Sometime jobs are a better common point where to implement different monitoring/debug policies, to decide which queries to log, for example when you interact with different databases and/or a lot of clients and jobs are querying at the same time.

I have DBA background, so I just not meet no one case when I will need log queries in Talend, when need - I debug all direct on database
From my point of view - all problems could be only from variable parameters, so I will debug variables, but not a query
but as Sabrina explain above for the ROW component You can use - ((String)globalMap.get("tOracleRow_1_QUERY"))

Re: how to log executed query to console? (tOracleRow)

vapukov — Thu, 17 Nov 2016 00:59:40 GMT

in additional, I never look for this information, but at least in TAC (subscription) - all database queries write to the log

in Studio (not Open) You can select Log4JLevel - Debug (same if You Build Job), and You will also have all queries on console:

will need to check - component from Exchange for Log4Jhow it work

Re: how to log executed query to console? (tOracleRow)

vapukov — Thu, 17 Nov 2016 01:49:43 GMT

not so easy as on subscription, but still possible