Hub
NodeNode / Source

H2 Connector

DB Connection
Drag & drop
Like
Copy short link

This node creates a connection to a H2 database file via its JDBC driver. You need to provide the path to the database file or the name when using in-memory mode. No username and password are required for H2 databases.

This node uses the selected driver's JDBC URL template to create the concrete database URL. Field validation in the dialog depends on whether the (included) tokens referencing them are mandatory or optional in the template.

Node details

Output ports
  1. Type: DB Session
    DB Connection
    H2 DB Connection.

Extension

The H2 Connector node is part of this extension:

Related workflows & nodes

  1. 01 Practicing with Traditional Databases
    Big data Database
    L4-BD SELF-PACED COURSE exercise: - Remove, structure, create, and manipulate database ta…
    knime > Education > Self-Paced Courses > L4-BD Introduction to Big Data with KNIME Analytics Platform > Exercises > 01 Practicing with Traditional Databases
    knime
  2. 01 Practicing with Traditional Databases
    Big data Database
    L4-BD SELF-PACED COURSE exercise: - Remove, structure, create, and manipulate database ta…
    tqthanh168 > Public > Self-Paced Courses > L4-BD Introduction to Big Data with KNIME Analytics Platform > Exercises > 01 Practicing with Traditional Databases
    tqthanh168
  3. 01 Practicing with Traditional Databases
    Big data Database
    L4-BD SELF-PACED COURSE exercise: - Remove, structure, create, and manipulate database ta…
    halverdog > Public > L4-BD Introduction to Big Data with KNIME Analytics Platform > Exercises > 01 Practicing with Traditional Databases
    halverdog
  4. 01 Practicing with Traditional Databases
    Big data Database
    L4-BD SELF-PACED COURSE exercise: - Remove, structure, create, and manipulate database ta…
    manuel1972 > Public > Self-Paced Courses > L4-BD Introduction to Big Data with KNIME Analytics Platform > Exercises > 01 Practicing with Traditional Databases
    manuel1972
  5. Writing data into a database
    Database Db
    This workflow uses the new database framework to write a KNIME table into a database tabl…
    tobias.koetter > Public > DB > Writing data into a database
    tobias.koetter
  6. Query reader modified
    adrix > Public > workflow_HUB > Query reader modified
    adrix
  7. Using virtual db instead of cross join and rule-based filter
    Scenario: We have a loopup table of Cities and we want to retrieve the cities whose name …
    bruno29a > Public > Demo > Using virtual db instead of cross join and rule-based filter
    bruno29a
  8. Working with user-defined database variables
    Db Database Variable
    This workflow demonstrates how you can create user-defined database variables in KNIME us…
    tobias.koetter > Public > DB > DBVariables
    tobias.koetter
  9. Just KNIME It Challenge 5 - Date to Fiscal Year
    Justknimeit-5
    In the accounting firm you work for, you are given contracts which were executed on diffe…
    bruno29a > Public > Just Knime It Challenges > Just KNIME It Challenge 5
    bruno29a
  10. Advanced Query Building
    Database SQL Custom query
    +1
    This workflow shows how to write custom SQL queries using KNIME database nodes with an em…
    knime > Examples > 01_Data_Access > 02_Databases > 15_Advanced_Query_Building
    knime