Transation with Insert Clause for Database Writer?

Hi, Thanks a lot for this great tool.

May I know if Database Writer use insert for entire data table in one transaction?

Could we specify the batch size? (like 500 record per transaction?)

The Database Writer uses an PreparedStatement together with "INSERT INTO" to either create a new table or append rows to an existing one; after the whole table as be interated a 'commit' is performed. UPDATE is currently not supported.


At the time of  bulk data  insertion / updation using Database Writer node , how commit is performed? is it performed in batch mode or after the complete insertion / updation its work.

I am using KNIME 2.11.3 / 2,12  version. Please let me know . its very urgent.

Thanks in advanced.