{"id":8489,"date":"2020-09-24T12:35:58","date_gmt":"2020-09-24T19:35:58","guid":{"rendered":"https:\/\/minisoft.com\/support\/?p=8489"},"modified":"2022-01-17T12:59:06","modified_gmt":"2022-01-17T20:59:06","slug":"h2-database","status":"publish","type":"post","link":"https:\/\/minisoft.com\/support\/h2-database\/","title":{"rendered":"H2 Database"},"content":{"rendered":"\n

Important Note: Please consult the following post – JNDI vulnerability in H2 database consoles<\/a><\/p>\n\n\n\n

Install<\/h2>\n\n\n\n

Go to the following page: https:\/\/www.h2database.com\/html\/download.html<\/a>. Select Windows Installer (“Last Stable” version).<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

If the install cannot find Java, download and run the following: https:\/\/www.minisoft.com\/download\/?ID=openjdk14<\/a><\/p>\n\n\n\n

Go to the Control Panel\\System and Security\\System\\Advanced System Settings\\Environment Variables.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

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<\/code><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

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 \u201cbin\u201d directory, such as: C:\\Program Files\\Java\\jdk14.0.1<\/code><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

H2 Console<\/h2>\n\n\n\n

Default Console URL:<\/strong> http:\/\/localhost:8082<\/p>\n\n\n\n

Create a new database by editing the JDBC URL path, for example:
jdbc:h2:C:\\Minisoft\\eFORMz_6\\h2db\\companyname;AUTO_SERVER=TRUE<\/code><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

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;<\/code><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Databases can be placed anywhere but it’s recommended that they are kept in the h2db folder under eFORMz:<\/p>\n\n\n\n

Windows: C:\\Minisoft\\eFORMz_6\\h2db\\<\/code>
Non-Windows: minisoft\/h2db\/<\/code><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Making H2 Run as a Service<\/h2>\n\n\n\n

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):<\/p>\n\n\n\n

<Service Name=\"H2 DBMS\" Class=\"com.minisoft.h2.Service\" Parameters=\"-tcp -web -webPort 8083 -baseDir h2db \" Start=\"true\" \/><\/pre>\n\n\n\n
Driver Class:<\/strong> org.h2.Driver<\/code><\/p>\n\n\n\n
Connect URL:<\/strong> jdbc:h2:<path here no <> included>;user=<correct user here>;AUTO_SERVER=TRUE<\/code><\/p>\n\n\n\n
Add this line and restart the service without the H2 console running.<\/p>\n\n\n\n
eFORMz sample project database connection properties<\/h2>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Database connection name: HMS_H2<\/code>
Driver class: org.h2.Driver<\/code>
URL: jdbc:h2:C:\\Minisoft\\eFORMz_6\\h2db\\HMS_H2;AUTO_SERVER=TRUE<\/code><\/p>\n\n\n\n
Alt tag: ShipFX<\/p>\n","protected":false},"excerpt":{"rendered":"
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). 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 […]<\/p>\n","protected":false},"author":75,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[208,581],"tags":[645,646,582],"_links":{"self":[{"href":"https:\/\/minisoft.com\/support\/wp-json\/wp\/v2\/posts\/8489"}],"collection":[{"href":"https:\/\/minisoft.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/minisoft.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/minisoft.com\/support\/wp-json\/wp\/v2\/users\/75"}],"replies":[{"embeddable":true,"href":"https:\/\/minisoft.com\/support\/wp-json\/wp\/v2\/comments?post=8489"}],"version-history":[{"count":4,"href":"https:\/\/minisoft.com\/support\/wp-json\/wp\/v2\/posts\/8489\/revisions"}],"predecessor-version":[{"id":9896,"href":"https:\/\/minisoft.com\/support\/wp-json\/wp\/v2\/posts\/8489\/revisions\/9896"}],"wp:attachment":[{"href":"https:\/\/minisoft.com\/support\/wp-json\/wp\/v2\/media?parent=8489"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/minisoft.com\/support\/wp-json\/wp\/v2\/categories?post=8489"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/minisoft.com\/support\/wp-json\/wp\/v2\/tags?post=8489"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}