Go to the following page: https://www.h2database.com/html/download.html. Select Windows Installer (“Last Stable” version).
If the install cannot find Java, download and run the following: https://www.minisoft.com/download/?ID=openjdk14
Go to the Control Panel\System and Security\System\Advanced System Settings\Environment Variables.
In the System Variables, modify the Path variable to include the bin directory of the Java install directory to the path, such as:
In the System Variables, add a new variable called JAVA_HOME and point it to the same path above, but to the directory above the “bin” directory, such as:
Default Console URL: http://localhost:8082
Create a new database by editing the JDBC URL path, for example:
Set the database admin user/password to MINISOFT/password with the following command in the H2 console (H2 forces user names to upper case by default):
CREATE USER IF NOT EXISTS MINISOFT PASSWORD 'password' ADMIN;
Databases can be placed anywhere but it’s recommended that they are kept in the h2db folder under eFORMz:
Making H2 Run as a Service
It is recommended to set the Database Engine to run as an eFORMz service by adding the following entry to your ServiceManagerSettings.xml file in the eFORMz install directory (C:\Minisoft\eFORMz_6 on Windows):
<Service Name="H2 DBMS" Class="com.minisoft.h2.Service" Parameters="-tcp -web -webAllowOthers -webPort 8083 -baseDir h2db " Start="true" />
jdbc:h2:<path here no <> included>;user=<correct user here>;AUTO_SERVER=TRUE
Add this line and restart the service without the H2 console running.
eFORMz sample project database connection properties
Database connection name: