NB line update with modification line in data base

[AYAHIAOUI1629282039]

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

[gjeremy1617088143]

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

[AYAHIAOUI1629282039]

yes i used tdbcommit

[gjeremy1617088143]

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.

[AYAHIAOUI1629282039]

how i can print my query ??

[AYAHIAOUI1629282039]

[gjeremy1617088143]

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 ?

[AYAHIAOUI1629282039]

i have null

[gjeremy1617088143]

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