Skip to main content
Kinetic Community

H2 Adapter

The H2 Adapter is used to retrieve data from a H2 Database.

Requirements

  • The Kinetic Schedule web server must be using JDK 6.0 or higher.
  • The following java libraries must be included in the Kinetic Schedule web application classpath:​
    • H2 JDBC Driver (h2-1.3.175.jar)
    • Kinetic Schedule H2 Adapter (kinetic-schedule-h2-adapter.jar)
  • The adapter and required jars can be downloaded using this zip file

Adapter Configuration

The following properties are required for all adapters.

 

Property Description
name

Any alpha-numeric value is acceptable, but should indicate this is a H2 adapter.

Example: "h2"

className

The value of the main adapter class file.  This will be a unique value specific to the adapter.

Value: "com.kineticdata.schedule.adapter.h2.H2Adapter"

 

Example Adapters Configuration File

{
    "adaptersConfig": {
        "adapters": [
            {
                "name": "h2",
                "className": "com.kineticdata.schedule.adapter.h2.H2Adapter"
            }
        ]
    }
}

 

Connection Configuration

The following properties are required for all connections, regardless of what type of adapter is used.  If the value for that property is not used by the adapter, the property must still exist in the configuration file.  The value for the property should be set to the blank string ("") if it is not used.

 

Property Description
name

The name of the connection that will be used in data source configuration files that use this connection.  Should be a name that correlates the adapter and server.

Example: "h2"

type

The value that was entered as the "name" property for the H2Adapter in the adapters configuration file.

Example: in the adapter configuration example above, the value would be "h2"

description

A description of the connection.  This is not seen by the end users, it is simply a way to describe what this connection interacts with.

Example: "H2 Database"

location

The JDBC string that points to where the database is being stored.

Example: "jdbc:h2:/Users/kineticdata/kinetic-schedule/db/schedule"

username

The username used to login to the database.

Example: "root"

password

The password used to login to the database.  This value can be entered as plain-text or encrypted with the Password Encryption form.

Example: "root"

useEncryption

Indicates if the password is stored in plain-text or encrypted form.

"true" if encrypted, "false" if plain-text

 

There are no additional parameters to the H2 Database Adapter.

 

Example Connector Configuration File

{
    "connection": {
        "name": "h2",
        "type": "h2",
        "description": "H2 Database",
        "location": "jdbc:h2:/Users/kineticdata/kinetic-schedule/db/schedule",
        "username": "root",
        "password": "root",
        "useEncryption": "false",
        "additionalParameters": []
    }
}