Preconditions for supported Database Management Systems
The following preconditions have to be met to allow JobScheduler to work with a Database Management System (DBMS):
- JobScheduler database connections are made using JDBC and therefore a JDBC driver for that DBMS is required.
- Not all JDBC drivers are compatible with our Open Source License and cannot be provided with the JobScheduler distribution.
- Therefore users should download the respective JDBC drivers from the DBMS vendor web site.
- The JobScheduler installer provides a script for the DBMS that creates the required database objects, e.g. tables, indices.
- The JobScheduler has been tested to be compatible with the respective release of the DBMS.
DBMS compatibility matrix
The following terms are used in the matrix:
- 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 | n/a | 11.1.0.7.0-Production | ojdbc6.jar | |
| SQL Server® | 2000, 2005, 2008. 2012 | 2014 | 1.3.1 | jtds-1.3.1.jar | Alternatively use the Microsoft JDBC Driver JS-1707 - Getting issue details... STATUS |
| 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 (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 JS-1799 - Getting issue details... STATUS 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 | 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 |
See also
- How can JobScheduler run with PostgreSQL 9-1 and newer?
- How can JobScheduler operate with a lightweight database such as H2?