topic Re: tMap -> tOracleRow ? How to ? in Talend Studio

tMap -> tOracleRow ? How to ?

Anonymous — Sat, 16 Nov 2024 14:33:37 GMT

Hi,
I try to design a job who has a csv file in input with 2 cols : ID and DATA. The purpose is to update an oracle table whose target table name, target column (aka DATA in the csv file) and reference column (aka ID) are set dynamically by the context variables.
I use a tOracleRow component to type the update query (see the screenshot).

The problem seems to be that I can't retrieve data from the tMap component.
massive_update.id and massive_update.data still be null in the query (see in debug mode) but are well completed in the trace.
Hope you can help me.
Thanks.
LB

Re: tMap -> tOracleRow ? How to ?

amaumont — Thu, 30 Aug 2007 10:51:16 GMT

Could you post a screenshot of your tMap content ?
Could you connect also a tLogRow from you fileInputCSV to check if data are read correctly.

Re: tMap -> tOracleRow ? How to ?

Anonymous — Thu, 30 Aug 2007 11:11:58 GMT

The tMap :

And the job running with the trace :

Re: tMap -> tOracleRow ? How to ?

amaumont — Thu, 30 Aug 2007 14:33:18 GMT

Your job should work, but your query is evaluted once at start of job, so variables id and data are null at this moment.
This is not the attempted behavior for this type of components, I created a bug issue to correct it, see 1876.
Meanwhile this correction, you can use a tOracleOutput, but you won't be able to set column names from context variables 😐

Re: tMap -> tOracleRow ? How to ?

Anonymous — Thu, 30 Aug 2007 15:17:01 GMT

Ok, I'll actively follow up the correction.
Thanks for your quick reply !