Page History

...

...

As a prerequisite users have to download the H2 DBMS/JDBC Driver that both ship from a single .jar file, for example from using http://www.h2database.com/html/download-archive.html:

• JDBC Driver version 12.43.200 232 is reported to work with JS7 2.
  • At the time of writing versions 2.* are reported not to work with JS7 due to Bug 578086 - IDENTITY function no longer supported in H2 database.
  7.x.
  • The following Java option has to be used: --add-opens=java.base/sun.reflect.annotation=ALL-UNNAMED
  • For details see JS7 - How To - Apply Java Options.
• The DBMS/The JDBC Driver .jar file, for example example h2-12.43.200232.jar
  • can be specified with the JOC Cockpit graphical installer,
  • can be added to an existing JOC Cockpit installation, see chapter Individual JDBC Driver Versions.
    • In this situation users can run the following commands
      • cd $JETTY_BASE | cd %JETTY_BASE%
      • ../install/joc_install_tables.sh | ..\joc_install_tables.cmd

    • It is required to navigate to the JETTY_BASE directory to run the above commands in order to have the database being created in ./resources/joc/h2.as specified by the H2® Hibernate configuration file.

An Operation Script for H2® databases is explained from the JS7 - How to operate H2 Databases from the Command Line article.

H2® ships with a console application that by default is available for browsers from port 8082. It is not required to run the H2® console application, however, find the following information how to invoke the console application.:

• JOC Cockpit has to be stopped as if the embedded H2® database can be used by a single client only. Use of the AUTO_SERVER=TRUE property in the JDBC URL allows to operate JOC Cockpit and the H2® console application in parallel.
• The console application and the database are started by invoking the H2® .jar file like this:
  
  • cd $JETTY_BASE | cd %JETTY_BASE%
  • java -jar ./lib/ext/joc/h2-12.43.200232.jar -webAllowOthers -tcpAllowOthers
• It is required to navigate to the JETTY_BASE directory to run the above commands in order to have the database being created in ./resources/joc/h2.as specified by the H2® Hibernate configuration file.
• The H2® console application should launch a browser window if executed from the local machine and otherwise will displays a URL to connect to the application.
• For login users should specify
  • the URL: jdbc:h2:./resources/joc/h2/joc as indicated from the above Hibernate configuration file
  • the user name: joc
  • an empty password.

...