Versions Compared

Key

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

...

For a number of DBMS the JDBC Drivers are included with JS7. However, due to restrictions for bundling of JDBC Drivers with Open Source software for some DBMS users have to individually download the JDBC Driver from the vendor's web site:

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.0yesDBMS 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 MySQL®

Oracle®12c, 18c, 19c19.7ojdbc8.jar
ojdbc10.jar
FUTC LicenseyesDBMS and JDBC Drivers are not Open Source
Use ojdbc10.jar for Java 10 releases and newer
PostgreSQL®10, 11, 1242.2.19postgresql-42.2.19.jarBSD 2-clauseyesDBMS and JDBC Drivers are Open Source
SQL Server®2012, 2014, 2017, 20199.xmssql-jdbc-9.x.jre8.jar
mssql-jdbc-9.x.jre11.jar
mssql-jdbc-9.x.jre15.jar
Proprietary Licenseno

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

Hibernate Configuration Files

  • Hibernate configuration files are used from an XML format. During installation the respective hibernate configuration file is created and can later on be manually updated.
  • After installation of JOC Cockpit the Hibernate configuration file is available with ./jetty_base/resources/joc/hibernate.cfg.xml
  • By default the Hikari Connection Pool is used.

...