tMysqlLastInsertId returns the FIRST inserted ID???

One Star

tMysqlLastInsertId returns the FIRST inserted ID???

Hello,
I can anyone tell me what happens here? I have to insert some rows in a MySQL table, then to retrieve the last inserted ID. The insertion is correctly executed, but tMysqlLastInsertId returns not the LAST, but the FIRST inserted ID !! I can't believe it! This happens either if I commit the insertion or without committing them, please advise!

Thank you.

PS
Working on TOS Version: 3.1.3/ Build id: r26090-20090629-1316t
Community Manager

Re: tMysqlLastInsertId returns the FIRST inserted ID???

Hello
Change a little in your job:
...
|
onsubjobok
|
tMysqlLastInsertID---tLogRow---tMysqlCommit.

Best regards

shong
----------------------------------------------------------
Talend | Data Agility for Modern Business