odd error messages for adding records to db table.
Hello!
I have got something that has been working earlier on using input directly to database from f ex CSV- files. However the problem might perhaps be a JDBC driver problem or some unhandled event in KNIME.
Tested with Knime 5.4.4.
I have 40+ tables in a db that handles regional weather data. Each table has 4 columns for:
A) “Comments” The reason why data was lost
B) adding a date from RecDate (which hastime included) - for speed - rather have speed even if it takes more storage space!
C) A logic string “Imputed” to show that the record is imputed.
D) “Method” a number of shorts for methods used for the imputation, such as LRF - last record forwarded, or BFO “borrowed data from other station modified by a formula”.
There are WriteErrors f ex “Column ‘Date_part’ cannot be null”!
And in workflow log:
2025-07-07 11:23:45,853 : WARN : KNIME-Worker-17-DB Writer 5:10 : : Node : DB Writer : 5:10 : Error during preparation
Blockquote CREATE TABLE test_table ( RecDate datetime NOT NULL, WindDir decimal(7,3) DEFAULT NULL, SLPressure decimal(5,1) DEFAULT NULL, Date_part date NOT NULL DEFAULT ‘1000-01-01’, Comments varchar(70) DEFAULT NULL, Imputed varchar(45) NOT NULL DEFAULT ‘0’, Method varchar(12) DEFAULT NULL, PRIMARY KEY (RecDate), KEY dateix (Datepart) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4swedishci;
Similar things have been working inside Knime in 3.x and early 4.x versions. Probably when I used built-in MySQL settings but with a MariaDB engine.
Regards,
Batjesen