...
The JDBC driver URL for Oracle RAC databases should be entered in the Host field of the database connection form. For example:
-
Code Block jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=OFF)(FAILOVER=ON) (ADDRESS=(PROTOCOL=TCP)(HOST=tst-db1.myco.com)(PORT=1604)) (ADDRESS=(PROTOCOL=TCP)(HOST=tst-db2.myco.com)(PORT=1604))) (CONNECT_DATA=(SERVICE_NAME=mydb1.myco.com)(SERVER=DEDICATED)))
...
This dialog form is offered for:
- ... IBM® IBM® DB2.
- ... MySql® MySql® when Use the MariaDB® JDBC® driver for MySql® databases was not checked.
- ... Microsoft® Microsoft® SQL Server or Sybase when Use the jTDS JDBC® driver for Sybase and Microsoft® SQL Server databases was not checked.
- ... Oracle® when Existing Oracle® JDBC® should be used was not checked.
The script for the creation of the database tables is started by the setup program and requires a JDBC® driver appropriate to the database system being used. See the
...
Overview and Requirements part of this installation guide for information about the database driver required by the JobScheduler Master. The
...
driver for
...
PostgreSQL and an Oracle ojdbc6 driver are included in the setup. However, the relevant IBM® DB2, MySql®, Sybase
...
, Microsoft® SQL Server and an Oracle® ojdbc7 JDBC® driver must be manually specified here. Note that for Microsoft® SQL Server and Sybase databases the jTDS JDBC® driver and for MySql® the MariaDB® JDBC® driver that is delivered as part of the JobScheduler setup can be used when the appropriate checkbox in the previous form was activated.
Note that for IBM® DB2 you have to provide a license file for the driver. As this driver will also be required by the JobScheduler later on, it is copied by the setup into the $SCHEDULER_HOME /lib/user_lib folder.
...