Icon

kn_​forum_​36064_​db_​h2_​use_​uuid_​unique_​identifier

Example how to use H2 database with a uuid unique identifier


Example how to use H2 database with a uuid unique identifier

Example how to use H2 database with a uuid unique identifier H2 Supported Data Typeshttps://www.h2database.com/html/datatypes.htmlINTBOOLEANTINYINTSMALLINTBIGINTIDENTITYDECIMALDOUBLEREALTIMETIME WITH TIME ZONEDATETIMESTAMPTIMESTAMP WITH TIME ZONEBINARYOTHERVARCHARVARCHAR_IGNORECASECHARBLOBCLOB UUIDARRAYENUMGEOMETRYJSONINTERVAL DROP TABLE IF EXISTS "PUBLIC"."sample_05"; CREATE TABLE "PUBLIC"."sample_05" ( "Universe_0_0" double , "Universe_0_1" double , "Universe_1_0" double , "Universe_1_1" double , "Cluster Membership" varchar(255) , "GUID" uuid NOT NULL ) ; idea adapted fromhttps://forum.knime.com/t/assign-a-unique-id/71320/4?u=mlauber71 Generate a unique identifier GUID - uuidhttps://hub.knime.com/sjporter/spaces/Public/latest/GUID%20Generator~_D5O4za6bToqQAfiDB in memoryor as fileon a drivecreatesample_05from scratchremove table if it exists to have a clean startsample_00sample filesample_00sample_00sample_0 0=> check the typemappingINSERT INTO "PUBLIC"."sample_05" FROM "PUBLIC"."sample_00"sample_05=> check the typemappingsample_05'pure' GUID - uuidsample_00sample_05=> check the typemappingsample_05as string GUID - uuidString uuid = UUID.randomUUID().toString();for each linecollect resultssample_uuid.tableUUIDhttps://forum.knime.com/t/assign-a-unique-id/71320/4?u=mlauber71GUID Generator H2 Connector DB SQL Executor DB Table Remover Data Generator DB Table Creator DB Loader DB Table Selector DB SQL Executor DB Table Selector DB Reader DB Reader DB Table Selector DB Reader Java Snippet Chunk Loop Start Loop End Table Writer String Manipulation Example how to use H2 database with a uuid unique identifier H2 Supported Data Typeshttps://www.h2database.com/html/datatypes.htmlINTBOOLEANTINYINTSMALLINTBIGINTIDENTITYDECIMALDOUBLEREALTIMETIME WITH TIME ZONEDATETIMESTAMPTIMESTAMP WITH TIME ZONEBINARYOTHERVARCHARVARCHAR_IGNORECASECHARBLOBCLOB UUIDARRAYENUMGEOMETRYJSONINTERVAL DROP TABLE IF EXISTS "PUBLIC"."sample_05"; CREATE TABLE "PUBLIC"."sample_05" ( "Universe_0_0" double , "Universe_0_1" double , "Universe_1_0" double , "Universe_1_1" double , "Cluster Membership" varchar(255) , "GUID" uuid NOT NULL ) ; idea adapted fromhttps://forum.knime.com/t/assign-a-unique-id/71320/4?u=mlauber71 Generate a unique identifier GUID - uuidhttps://hub.knime.com/sjporter/spaces/Public/latest/GUID%20Generator~_D5O4za6bToqQAfiDB in memoryor as fileon a drivecreatesample_05from scratchremove table if it exists to have a clean startsample_00sample filesample_00sample_00sample_0 0=> check the typemappingINSERT INTO "PUBLIC"."sample_05" FROM "PUBLIC"."sample_00"sample_05=> check the typemappingsample_05'pure' GUID - uuidsample_00sample_05=> check the typemappingsample_05as string GUID - uuidString uuid = UUID.randomUUID().toString();for each linecollect resultssample_uuid.tableUUIDhttps://forum.knime.com/t/assign-a-unique-id/71320/4?u=mlauber71GUID Generator H2 Connector DB SQL Executor DB Table Remover Data Generator DB Table Creator DB Loader DB Table Selector DB SQL Executor DB Table Selector DB Reader DB Reader DB Table Selector DB Reader Java Snippet Chunk Loop Start Loop End Table Writer String Manipulation

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: m_lauber
Created at: 2020-09-18
On NodePit since: 2021-09-15
Last update: 2024-04-27
Created with KNIME version: v4.7.6
Tags: h2sqlcreatefromscratchdatabaseuuiduniqueidentifier

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!