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 |
DB2® | 8.x | 10.5 | 1.3.1 | db2jcc.jar | |
MariaDB® | - | 10.0.14 | 1.10: mariadb-java-client-1.1.7.jar 1.11: mariadb-java-client-1.3.0.jar | MariaDB Driver 1.3.0 can be used with release 1.10 | |
MySQL® | 5.5, 5.6, 5.7 | 1.1.7 | 1.10: mariadb-java-client-1.1.7.jar 1.11: mariadb-java-client-1.3.0.jar | MariaDB Driver 1.3.0 can be used for release 1.10 Alternatively use the MySQL JDBC Driver | |
PostgreSQL® | 8.x, 9.1, 9.2, 9.3, 9.4, 9.5, 9.6 | 8.1 | 1.10: postgresql-9.4-1201-jdbc4 1.11: postgresql-9.4.1209.jar | JDBC Driver 9.4.1209 can be used with release 1.10 | |
Sybase ASE® | ASE 15.0 | 16.0 | 1.3.1 | jtds-1.3.1.jar | Alternatively use the Sybase JDBC Driver |
See also
- How can JobScheduler run with PostgreSQL 9-1 and newer?
- How can JobScheduler operate with a lightweight database such as H2?