topic Re: tOracleRow_1_NB_LINE_DELETED does not yield correct results in Talend Studio

tOracleRow_1_NB_LINE_DELETED does not yield correct results

sensiva — Fri, 08 Dec 2017 14:30:18 GMT

Hello / Hi

I had a requirement to get the number of rows deleted from a table after i execute the query using toraclerow. I used the option NB_LINE to get the value of number of lines deleted during the operation .

I used a tjava with System.out.println(((Integer)globalMap.get("tOracleRow_1_NB_LINE_DELETED"))); to get the info, but this always returns null. Not sure if i am going wrong somewhere. I am planning to go for a workaround with toracleinput and toracleoutput.

could anyone advice if its really the solution to go with the workaround or am i making some mistake with the toraclerow..

Thanks

Re: tOracleRow_1_NB_LINE_DELETED does not yield correct results

TRF — Fri, 08 Dec 2017 18:51:21 GMT

Hi,
Based on the documentation, tJava is executed first, but only once in the subjob. Normally, tJava has no input or output data flow and is used as a separate subjob.
So, depending on where is placed the component it may be normal to get null value.
Share your job design if necessary.

Re: tOracleRow_1_NB_LINE_DELETED does not yield correct results

Anonymous — Mon, 11 Dec 2017 03:24:47 GMT

Hello,

Please have a look at this article about:What-is-the-difference-between-tJava-tJavaRow-and-tJavaFlex.

Hope it will help.

Best regards

Sabrina

Re: tOracleRow_1_NB_LINE_DELETED does not yield correct results

sensiva — Mon, 11 Dec 2017 15:13:34 GMT

On executing the tjava as "when subjob ok", it works fine. Thanks..

One another question "Can we access these globalmap variables from tmap component ? "

Regards

Re: tOracleRow_1_NB_LINE_DELETED does not yield correct results

Anonymous — Tue, 12 Dec 2017 06:47:23 GMT

Hello,

@sensiva wrote:

On executing the tjava as "when subjob ok", it works fine. Thanks..

One another question "Can we access these globalmap variables from tmap component ? "

Regards

What's your further processing? Could you please give us more information about your requirement?

Best regards

Sabrina