H2 Database
Important Note: Please consult the following post – JNDI vulnerability in H2 database consoles
Install
Go to the following page: https://www.h2database.com/html/download.html. Select Windows Installer (“Last Stable” version).
![](https://minisoft.com/support/wp-content/uploads/2022/01/H2-210.png)
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.
![](https://minisoft.com/support/wp-content/uploads/2020/09/h2_2.png)
![](https://minisoft.com/support/wp-content/uploads/2020/09/h2_3.png)
In the System Variables, modify the Path variable to include the bin directory of the Java install directory to the path, such as: C:\Program Files\Java\jdk14.0.1\bin
![](https://minisoft.com/support/wp-content/uploads/2020/09/h2_4.png)
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: C:\Program Files\Java\jdk14.0.1
![](https://minisoft.com/support/wp-content/uploads/2020/09/h2_5.png)
H2 Console
Default Console URL: http://localhost:8082
Create a new database by editing the JDBC URL path, for example:jdbc:h2:C:\Minisoft\eFORMz_6\h2db\companyname;AUTO_SERVER=TRUE
![](https://minisoft.com/support/wp-content/uploads/2020/09/console1.png)
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;
![](https://minisoft.com/support/wp-content/uploads/2020/09/console2.png)
Databases can be placed anywhere but it’s recommended that they are kept in the h2db folder under eFORMz:
Windows: C:\Minisoft\eFORMz_6\h2db\
Non-Windows: minisoft/h2db/
![](https://minisoft.com/support/wp-content/uploads/2020/09/console3.png)
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 -webPort 8083 -baseDir h2db " Start="true" />
Driver Class: org.h2.Driver
Connect URL: 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
![](https://minisoft.com/support/wp-content/uploads/2020/09/h2_sampleproject.png)
Database connection name: HMS_H2
Driver class: org.h2.Driver
URL: jdbc:h2:C:\Minisoft\eFORMz_6\h2db\HMS_H2;AUTO_SERVER=TRUE
Alt tag: ShipFX