JS7 JobScheduler

Space shortcuts

Page tree

Versions Compared

Old Version 78

changes.mady.by.user Santiago Aucejo Petzoldt

Saved on

compared with

New Version Current

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®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.7.2

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

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 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)

...

  • Oracle® ships a newer version of their DBMS compatible to previous versions, e.g. the 19c release is compatible to 18c and down to 12c and 10g.
  • Compatibility includes that your DBA identifies the technical compatibility switch in the DBMS to run the 19c version compatible to 18c, 12c etc. This means your DBA is in control of compatibility.
  • SOS documents that JS7 is compatible to Oracle® 12c and 18c. This boils down to the fact that your DBA can run any newer version of the DBMS in a compatibility mode that supports 12c or 18c.
  • The question if SOS will ship a JS7 release specifically for 19c would mean that the product is no longer compatible to earlier releases of the DBMS. This will not happen. The JS7 is not too demanding when it comes to the DBMS, which is considered as a datastore.

The same applies to JDBC Drivers. There might be newer versions of JDBC Drivers that e.g. include bug-fixes. Do not ask SOS if JS7 is compatible to a specific JDBC Driver version. Ask your DBMS vendor if a newer version of the JDBC Driver is compatible to the one stated above. When picking a JDBC Driver then check compatibility with the Java version in use. For Java versions that can be used with JS7 see the Which Java versions is JobScheduler available for? article.

...