topic Re: tOracleBulkExec NB_LINE_INSERTED in Talend Studio

tOracleBulkExec NB_LINE_INSERTED

BS0612 — Sat, 16 Nov 2024 07:46:16 GMT

Hello,

I am loading an Oracle Database with tOracleBulkExec. It works and the Database is loaded.

Now I trie to post the Global Variable NB_LINE_INSERTED using tJavaFlex and tLogRow connected with OnComponentOk.

System.out.println("NB_LINE_INSERTED: "+(globalMap.get((Integer)globalMap.get("tOracleBulkExec_1_NB_LINE_INSERTED"))));

But I get :

NB_LINE_INSERTED: null

Does anyone have an idea what's wrong? Thanks!

Re: tOracleBulkExec NB_LINE_INSERTED

Jesperrekuh — Fri, 24 Aug 2018 12:31:43 GMT

NB LINE INSERTED. works with a row-counter , therefore when using a script it doesn't loop no iterator is increased... and inevitable NULL

They should implement SQL_MESSAGE which returns the response message by the server.
But they didn't

Re: tOracleBulkExec NB_LINE_INSERTED

TRF — Fri, 24 Aug 2018 12:38:15 GMT

What if you connect the tJavaFlex with a OnSubjobOk trigger?

Re: tOracleBulkExec NB_LINE_INSERTED

BS0612 — Thu, 30 Aug 2018 11:32:27 GMT

Thanks, for the explaination.
What I don't understand is: Why is the global variable in the description of tOracleBulkExec offered, when this doesn't work?!

Re: tOracleBulkExec NB_LINE_INSERTED

brama — Thu, 30 Aug 2018 11:55:22 GMT

Hi,

NB_LINE_INSERTED will work, but this has to be used post insertion to DB is completed. Check whether you are trying to print the value before it is set. Use OnComponent OK or OnSubJob ok, then print it, this will work.

Thanks,

Ramachandran B