JS7 JobScheduler

Space shortcuts

Page tree

Versions Compared

Old Version 76

changes.mady.by.user Andreas Püschel

Saved on

compared with

New Version 77

changes.mady.by.user Andreas Püschel

Saved on

Key

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

...

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

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®10, 11

from Release 2.7.3: 3.5.0
until Release 2.7.2:  2.2.7

mariadb-java-client-3.5.0.jar
mariadb-java-client-2.7.2.jar

LGPLyesDBMS 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, 21c
21.8

from Release 2.7.3: 19.25
until Release 2.7.2: 19.19

ojdbc8-19.24.0.0.jar
ojdbc8-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, 15from Release 2.7.3: 42.7.4
 until Release 2.7.2: 42.4.3		postgresql-42.7.4.jar
postgresql-42.4.3.jar
BSD 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)


In most situations it is technically possible to operate JS7 with newer versions of a DBMS or JDBC Driver if the version is actively supported by the DBMS vendor. Users frequently ask if JS7 is compatible with newer versions of a DBMS or JDBC Driver. It's the wrong question and your DBA should know the answer. Consider the following example for Oracle® that similarly applies to other DBMSs:

...