Uploaded image for project: 'SET - Setups'
  1. SET - Setups
  2. SET-5

JobScheduler setup includes not longer a JDBC driver for DB2®. The driver has to be added by the user

    XMLWordPrintable

Details

    • Feature
    • Status: Approved (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • 1.9.3, 1.10
    • 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.

      Attachments

        Activity

          People

            oh Oliver Haufe
            oh Oliver Haufe
            Oliver Haufe Oliver Haufe
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - 3 hours
                3h
                Remaining:
                Remaining Estimate - 3 hours
                3h
                Logged:
                Time Spent - Not Specified
                Not Specified