tdblastinsertid does not function well

aminegac — Fri, 15 Nov 2024 22:55:35 GMT

hi there ,

my main issue is why i lose 'main' data flow if i pass throught OnComponenetOK and why i don't get last id inserted in a database table unless i pass throught that trigger OnComponenetOK or some trigger that lets the job pass some time period ; why can't i directly get the value of the last id inserted so that at least i can keep my 'main' flow data and add the new id to it and do what i want :

so if i use lastidINSERTED i lose data and i get the id : in this case i must use a trigger connection!

but if i use 'main'

connection

, i keep the data flow ; but i get a delayed last ID (first line i get 0 then for second iteration i get last ID of line 1 not line 2 of 2nd itereation !

that's the main reason i needed a workaround like subjobs and temporary files for 1 line only !!

is there by the way any replacement for temp file with 1 line ?? (i need a componenet that can keep data along all the iteration globally to use it for all subjobs while making sure i don't write any column types and names !! my object has around 150 attributes )

is there any solution that is as dynamic as possible to avoid writing code for each column 150 times ?

Re: tdblastinsertid does not function well

Anonymous — Fri, 13 May 2022 02:54:48 GMT

tDBLastIdInsertID: select the last insert id from the selected connection, make sure this component is used after the change are commit.

Can you share a screenshot of job to show where you use tDBLastInsertID?

Regards

Shong

topic tdblastinsertid does not function well in Talend Studio

tdblastinsertid does not function well

Re: tdblastinsertid does not function well