You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 12 Next »

page under construction

Elaboration required.

A specific set of databases is constantly being tested for use with JobScheduler. The database products and versions should be stated.

Preconditions for supported DBMSs

The following preconditions have to be met to allow JobScheduler work with a database:

  • 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 database 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 no knowledge of successful use with this DBMS version.
  • Recommended JDBC Driver: SOS has performed successful tests with the respective JDBC Driver. Other versions and other JDBC Drivers may work.

 

DBMSVersions confirmed as
compatible with JobScheduler
Versions with
uncomfirmed compatibility
Recommended JDBC
Driver Version
JDBC Driver provided
with JobScheduler
Comments

Oracle

8.1.7, 9.2, 10g, 11g1211.1.0.7.0-Productionojdbc6.jar 
MS SQL Server2000, 2005, 2008. 201220141.3.1jtds-1.3.1.jarAlternatively use the Microsoft JDBC Driver
DB28.x10.51.3.1db2jcc.jar 
MariaDB-10.0.14 mariadb-java-client-1.1.3.jar 
MySQL5.55.6.2 1.1.3mariadb-java-client-1.1.3.jarAlternatively use the MySQL JDBC Driver
PostgreSQL8.x, 9.1, 9.29.3.58.1postgresql-8.1-404.jdbc3.jar 
Sybase ASEASE 15.016.01.3.1jtds-1.3.1.jarAlternatively use the Sybase JDBC Driver

Notes on specific DBMS versions

 

  • No labels