...
- Confirmed as compatible: SOS has performed successful tests with the respective DBMS version.
- Unconfirmed compatibility: we have knowledge of successful use with this DBMS version. However we did not test JobScheduler with this DBMS release.
- Recommended JDBC Driver: SOS has performed successful tests with the respective JDBC Driver. Other versions and other JDBC Drivers may work.
DBMS | Versions confirmed as compatible with JobScheduler | Versions with unconfirmed compatibility | Recommended JDBC Driver Version | JDBC Driver provided with JobScheduler | Comments | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Oracle® | 8.1.7, 9.2, 10g, 11g, 12c, 18c | n/a | 11.1.0.7.0-Production | ojdbc6.jar | Newer JDBC Driver versions can be downloaded individiually:
New DBMS versions are are added to our test environment after availability of XE releases | ||||||||||
SQL Server® | 2008. 2012, 2017 | 2000, 2005, 2014 | 1.3.1 | jtds-1.3.1.jar | jTDS is not supported by its authors.
| ||||||||||
DB2® | 8.x (for releases up to 1.10) | 10.5 (for releases up to 1.10) | 1.3.1 | db2jcc.jar | DB2 is not supported starting from release 1.11 | ||||||||||
MariaDB® | - | 10.0.14 | 1.10: mariadb-java-client-1.1.7.jar 1.11, 1.12: mariadb-java-client-1.3.0.jar 1.12.6: mariadb-java-client-2.2.6.jar | MariaDB Driver 1.3.0 can be used starting from release 1.10 MariaDB Driver 2.2.6 can be used starting from release 1.12 | |||||||||||
MySQL® | 5.5, 5.6, 5.7, 8.0 | 8.0 (for releases starting from 1.12.6) | 2.2.6 | 1.10: mariadb-java-client-1.1.7.jar 1.11, 1.12: mariadb-java-client-1.3.0.jar 1.12.6: mariadb-java-client-2.2.6.jar | MariaDB Driver 1.3.0 can be used starting from release 1.10 MariaDB Driver 2.2.6 can be used starting from release 1.12.6
Alternatively use the MySQL JDBC Driver (required for use with MySQL 8) | ||||||||||
PostgreSQL® | 8.x, 9.1, 9.2, 9.3, 9.4, 9.5, 9.6,10.5, 11.2 | 9.4 | 1.10: postgresql-9.4-1201-jdbc4 1.11: postgresql-9.4.1209.jar | JDBC Driver 9.4.1209 can be used starting from release 1.10 | |||||||||||
Sybase ASE® | ASE 15.0 (for releases up to 1.10) | 16.0 (for releases up to 1.10) | 1.3.1 | jtds-1.3.1.jar | Alternatively use the Sybase JDBC Driver Sybase is not supported starting from release 1.11 |
DBMS Compatibility Test Results
...
Office Excel | ||||
---|---|---|---|---|
|
Office Excel | ||||
---|---|---|---|---|
|
Explanations:
- The above report is the result of automated compatibility testing and is updated on a per JobScheduler release.
- At the time of General Availability for JobScheduler Release 1.12.9 no JDBC Driver product compatible with Java 12 is available.
- Do not use JDBC Drivers marked as incompatible (orange color).
- Use of JDBC Drivers with limited compatibility (yellow color) results in warnings that you will find in the JobScheduler log files.
...