Transation with Insert Clause for Database Writer?

KNIME Analytics Platform
1

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?)

2

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.

3

Hi,

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.