Skip to main content

IMPORTANT - Product End of Life Statement - IMPORTANT

Request RE, Survey, and Calendar 1.5 Support Ending December 31, 2020
Contact Kinetic Data Support with Questions
Kinetic Community

H2 Adapter

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


  • 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

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

Example: "h2"


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

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"


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"


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"


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

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


The username used to login to the database.

Example: "root"


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"


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": []