Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

DBMS
Product
DBMS
Version
JDBC Driver
Version
JDBC Driver
File
JDBC Driver
License
Included with JS7Comment
H2®2.3.2322.3.232h2-2.3.232.jarMPL 2.0, EPL 1.0no

DBMS and JDBC Drivers are Open Source

Use Java Option (JS7 - How To - Apply Java Options):
--add-opens=java.base/sun.reflect.annotation=ALL-UNNAMED

MariaDB®102.7.2mariadb-java-client-2.7.2.jarLGPLyesDBMS and JDBC Drivers are Open Source
MySQL®5.7, 8.08.xmysql-connector-java-8.x.jarProprietary Licenseno

DBMS is Open Source, JDBC Drivers are not Open Source

The MariaDB® JDBC Driver can be used for access to MySQL® databases

Oracle®12c, 18c, 19c, 21c21.8ojdbc8-19.19.0.0.jar
FUTC Licenseyes

DBMS and JDBC Drivers are not Open Source

Use ojdbc8*.jar for Java 8 and Java 11
Use ojdbc11*.jar for Java 11 and Java 17

PostgreSQL®10, 11, 12, 13, 14, 1542.4.3postgresql-42.4.3.jarBSD 2-clauseyesDBMS and JDBC Drivers are Open Source
SQL Server®2016, 2017, 2019, 20229.x, 10.x, 11.x, 12.xmssql-jdbc-<version>.jre8.jar
mssql-jdbc-<version>.jre11.jar
mssql-jdbc-<version>.jre17.jar
Proprietary Licenseno

DBMS and JDBC Drivers are not Open Source
Use mssql*.jre11.jar for Java 11
    (JDBC Driver version 7.2 to 9.x)
Use mssql*.jre17.jar for Java 17
    (JDBC Driver version 10.2 and newer)

...

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.7.x.
  • 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.

...