JS7 JobScheduler

Space shortcuts

Page tree

Versions Compared

Old Version 67

changes.mady.by.user Andreas Püschel

Saved on

compared with

New Version 68

changes.mady.by.user Andreas Püschel

Saved on

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®1.4.2001.4.200h2-1.4.200.jarMPL 2.0, EPL 1.0noDBMS and JDBC Drivers are Open Source
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, 19c19.7ojdbc8-18.3.0.0.jar
FUTC Licenseyes

DBMS and JDBC Drivers are not Open Source

Use ojdbc8*.jar for Java 8 releases and newer

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, 20199.x, 10.x, 11.xmssql-jdbc-<version>.jre8.jar
mssql-jdbc-<version>.jre11.jar
mssql-jdbc-<version>.jre15.jar		Proprietary Licenseno

DBMS and JDBC Drivers are not Open Source
Use mssql*.jre11.jar for Java 11 - 14
Use mssql*.jre15.jar for Java 15 and newer

...

  • Hibernate configuration files are used in an XML format.
  • JS7 - JOC Cockpit Installation On Premises
    • During installation the relevant hibernate configuration file is created and can be manually updated later on.
    • After installation of the JOC Cockpit the hibernate.cfg.xml Hibernate configuration file is available in
      • Unix
        • /var/sos-berlin.com/js7/joc/jetty_base/resources/joc
      • Windows
        • C:\ProgramData\sos-berlin.com\js7\joc\jetty_base\resources\joc
      • A different location for the configuration directory can be specified during installation of the JOC Cockpit.
  • JS7 - JOC Cockpit Installation for Docker Containers
    • The JOC Cockpit ships preinstalled from a Docker® image.
    • It is therefore recommended that users:
      • download/copy one of the Hibernate configuration files listed below to:
        • /var/sos-berlin.com/js7/joc/jetty_base/resources/joc
      • adjust changes to reflect their database connection. For use with H2® you can use the below sample without changes.
  • By default the Hikari Connection Pool is used.
  • Consider that XML requires special characters to be used with escape characters, for example a password in the Hibernate configuration file that includes the character & is written as &amp;. This applies to any values of XML elements and attributes in Hibernate configuration files.
    • Wrong: <property name="hibernate.connection.password">sec&ret</property>
    • Right: <property name="hibernate.connection.password">sec&amp;ret</property>

...

  • /var/sos-berlin.com/js7/joc/resources/joc/lib
  • The /var/sos-berlin.com/js7/joc/resources/joc directory is typically mounted to a Docker volume when running the container - for details see the JS7 - JOC Cockpit Installation for Docker Containers article. If the lib sub-directory does not exist then you can create it to store the JDBC Driver (*.jar) file.

...