Follow up: Returning auto generated IDs in DB insert/writer nodes

[armingrudd]

Hi,

Just wanted to check if there is any updates for this (Internal reference: AP-6693)?

Insert data in several tables of database

Hi, I’m afraid the solution @Jeany came with will produce problems if the table’s ID is declared as auto increment as @dbolshev suggested. If you make up a custom ID ignoring auto increment you could end up with duplicate ID either immediately or in the future. You usually have an option to get last inserted ID from DB session but I haven’t noticed yet KNIME is able to work with that. I’d consider the best solution changing the way ID is generated from auto-increment to obtaining new ID from a…

Returning auto generated IDs in DB insert/writer nodes

Hi, When we insert new rows to the database and the IDs are auto generated in DB, how can we have the IDs of the rows we just added? Actually, I’m requesting for a feature in DB Insert/writer nodes to return IDs of the inserted rows in the output data port.

[bruno29a]

+1 from me if I did not ask for it from the other thread

[ScottF]

Hi Armin, I checked and at the moment there is nothing new to report here. I added another +1 on the original ticket.