This module is a part of the NetHomeServer. The H2DatabaseTCPServer connects with a local H2 TCP Database and will open up connectivity to store and read values from a H2 database.

The item is used in storing value item logs written by other home items such as thermometers and hygrometers. It is also used to retrieve data when viewing graphs from a home item.

See also discussion below on how to configure the database for logging of value items.

• Start and Stop TCP Service is for the H2 Database server itself.
• Start and Stop Web Service is for the H2 web console itself.

These settings are available in the home item:

• Item name is whatever name you would like to call the new item, for example “H2DatabaseServer”.
• DatabasePath is the location on your installation where H2 can access the database. Enter a “~” (tilde) character for the current users directory. On a Raspberry Pi installation (Linux) this is the user NetHome's directory at /home/nethome.
• TCP active on startup when checked will activate the H2 database server on startup of NetHomeServer.
• TCP Port is the internal port for accessing the H2 database console.
• WEB active on startup when checked will activate the H2 web console on startup of NetHomeServer.
• WEB Port is the public port for accessing the H2 web console.
• WEB public when checked will make the H2 web console made available to the public - they will still have to log in though. If unchecked will only allow connections locally to the web console (on the same machine, localhost, 127.0.0.1, etc).

Note: You may have to stop and start the service(s) if you change any of the settings.

http://www.h2database.com/html/main.html