Icon

kn_​forum_​26474_​db_​postgres_​catch_​insert_​error

several tries to capture errors with DB nodes and Postgres database

several tries to capture errors with DB nodes and Postgres database
-- work in progress --

https://forum.knime.com/t/handling-exception-in-db-insert/26474

several tries to capture errors with DB nodes and Postgres database-- work in progress --https://forum.knime.com/t/handling-exception-in-db-insert/26474 create400 linesdata_1new_iddata_1first 200 lines1st try1stsee resultsdata_insertcheck current resultssee resultsall 400lines (again)would update /existing linesand insert new onesbased onsee resultswouldupdate existing lines based onnew_idsee resultsNode 130Node 131data_insertdata_insertINSERT INTO "public"."data_1"SELECT * FROM "public"."data_insert"see resultssee resultsstreamingtry streaming of 1 line per iteration andresume after error PostgreSQLConnector Data Generator DB Table Creator Java Snippet(simple) DB Table Remover Row Splitter DB Table Selector DB Reader DB Reader DB Writer DB Table Selector DB Reader Sorter DB Merge DB Reader DB Update DB Reader 1st try 2nd try DB Table Remover DB Table Creator DB SQL Executor DB Reader DB Reader Component several tries to capture errors with DB nodes and Postgres database-- work in progress --https://forum.knime.com/t/handling-exception-in-db-insert/26474 create400 linesdata_1new_iddata_1first 200 lines1st try1stsee resultsdata_insertcheck current resultssee resultsall 400lines (again)would update /existing linesand insert new onesbased onsee resultswouldupdate existing lines based onnew_idsee resultsNode 130Node 131data_insertdata_insertINSERT INTO "public"."data_1"SELECT * FROM "public"."data_insert"see resultssee resultsstreamingtry streaming of 1 line per iteration andresume after errorPostgreSQLConnector Data Generator DB Table Creator Java Snippet(simple) DB Table Remover Row Splitter DB Table Selector DB Reader DB Reader DB Writer DB Table Selector DB Reader Sorter DB Merge DB Reader DB Update DB Reader 1st try 2nd try DB Table Remover DB Table Creator DB SQL Executor DB Reader DB Reader Component

Nodes

Extensions

Links