Details
-
Feature
-
Status: Approved (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
Description
Current Situation
- Now the JobScheduler setup contains a DB2 JDBC Type 2 Driver of the version
IBM DB2 JDBC Universal Driver Architecture 2.7.58
for DB2 server 8.1.
- This driver doesn't work together with Oracle Java 1.8
- According to IBM:
- The DB2® JDBC Type 2 driver for Linux, UNIX, and Windows operating systems has been discontinued. You should use the IBM® Data Server Driver for JDBC and SQLJ instead.
- Details
- The DB2 JDBC Type 2 Driver for Linux, UNIX, and Windows was deprecated in Version 8.2. This driver allowed Java™ applications to make calls to DB2 servers through JDBC. The DB2 JDBC Type 2 Driver used the DB2 CLI interface to communicate with DB2 data servers. The Java applications that used this driver had to run on a DB2 client. This driver supported all of the methods that are described in the JDBC 1.2 and 2.0 specifications.
- The IBM Data Server Driver for JDBC and SQLJ allows Java applications to make JDBC type 2 and JDBC type 4 connections using a single driver instance. The type 2 driver behavior of the IBM Data Server Driver for JDBC and SQLJ is referred to as IBM Data Server Driver for JDBC and SQLJ type 2 connectivity. This driver supports all of the methods that are described in the JDBC 3.0 and 4.0
Desired Behavior
- The JobScheduler setup includes neither the DB2 JDBC Type 2 Driver like before nor a current IBM® Data Server Driver for JDBC.
- The reasons for DB2 JDBC Type 2 Driver see above
- The reasons for a current IBM® Data Server Driver for JDBC is that the driver has to correspond to the DB2 server so that there is no guarantee that a driver in the JobScheduler setups matches.
- The JobScheduler setup requires that the user add an own IBM® Data Server Driver for JDBC during the setup.