H2 Connector (legacy)

Source

This node is part of the legacy database framework. For more information on how to migrate to the new database framework see the migration section of the database documentation.

This node creates a connection to a H2 database file via its JDBC driver. You need to provide the path to the file. No username and password are required for H2 databases.

Note that H2 converts all column names to uppercase therefore we quote them so that their case is retained. This means that if you are writing your own SQL code (e.g. in the Database Table Selector) you have to quote column names, too (using double quotes).

Output Ports

  1. Type: Database Connection
    A database JDBC connection

Extension

This node is part of the extension

KNIME Connectors for Common Databases

v4.0.0

Short Link

Drag node into KNIME Analytics Platform