topic Re: NB line update with modification line in data base in Talend Studio

NB line update with modification line in data base

AYAHIAOUI1629282039 — Thu, 28 Oct 2021 14:05:54 GMT

Hello guys,

i need to know how i can see the number of line update (whith real modification) in data base. i use variable globale ((Integer)globalMap.get("tDBOutput_1_NB_LINE_UPDATED")) but results is all line despite there is no real modification in data base.

thank you

Re: NB line update with modification line in data base

gjeremy1617088143 — Thu, 28 Oct 2021 14:19:38 GMT

Hi, @Amine YAHIAOUI , do you commit the change in database , with tDBCommit component or auto commit in advanced settings of your DBConnection ?

Send me love and kudos

Re: NB line update with modification line in data base

AYAHIAOUI1629282039 — Thu, 28 Oct 2021 14:25:20 GMT

yes i used tdbcommit

Re: NB line update with modification line in data base

gjeremy1617088143 — Thu, 28 Oct 2021 15:16:22 GMT

could you share screenshot of your job ? tDBOutput_1_NB_LINE_UPDATED show the number of line updated, maybe you could print tDBOutput_1_QUERY to see the query send to the database for more investigation.

Re: NB line update with modification line in data base

AYAHIAOUI1629282039 — Thu, 28 Oct 2021 15:27:51 GMT

how i can print my query ??

Re: NB line update with modification line in data base

AYAHIAOUI1629282039 — Thu, 28 Oct 2021 15:28:31 GMT

Re: NB line update with modification line in data base

gjeremy1617088143 — Fri, 29 Oct 2021 07:20:55 GMT

on component ok link after Autoroute then tJava with:

System.out.println((String)globalMap.get("tDBOutput_1_QUERY"));

Do you use just update, or (insert or update), or (update or insert)

in tDBOutput ?

Re: NB line update with modification line in data base

AYAHIAOUI1629282039 — Fri, 29 Oct 2021 08:50:02 GMT

i have null

Re: NB line update with modification line in data base

gjeremy1617088143 — Fri, 29 Oct 2021 09:24:50 GMT

you can also select Enable debug mode in the advanced settings of the tdboutput component