Database Writer Knime 3.2


I just realized that the database writer node in Version 3.2 does not write any (also existing) columns if you highlite "insert null for missing columns". The console list 

WARN  Database Writer      0:2594     Error while adding row #2 (Row0), reason: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'xxx' at line 1

Best regards


Hi Jerry,

can you please send me your workflow or any sample data that you use? i already tried with different data and different databases but still cannot reproduce the error.

Best regards,


Hi Budi,

when I tried to construct a similar workflow that I have in small I could also not repeat the error. Don't know what happened. Sorry for the false alarm.

Best regards