Data360 Analyze

 View Only
  • 1.  Data3Sixty Analyze Enterprise, DB2 Drivers, Connection Problem

    Posted 09-18-2019 10:08

    Hello,

    We are getting the message, "Unable to load Driver Class: com.ibm.db2.jcc.DB2Driver".

    There are the jar files we have installed: db2jcc4.jar, db2jcc_license_cisuz.jar, db2jcc_license_cu.jar

    In this directory ../site-7731/lib/bd/db2

    Do we have the correct jar files installed? I can connect to the DB2 in our installation of LAE6.1.4. But we can connect to the same DB2 in our newly installed Data3Sixty....

    Thanks

     



  • 2.  RE: Data3Sixty Analyze Enterprise, DB2 Drivers, Connection Problem

    Posted 09-18-2019 11:42

    Clarification, we can not connect to the same DB2 in out newly installed Data3Sixty.



  • 3.  RE: Data3Sixty Analyze Enterprise, DB2 Drivers, Connection Problem

    Employee
    Posted 09-20-2019 03:41

    Hi Brad,

    If you are using a release on the Analyze Long Term Support track (3.4.x) you should consider upgrading to v.3.4.3 which ships with the DB2 JDBC driver pre-installed. We will also be shipping this driver in the next release on the Feature release track next month (v.3.5.1).

    Both of these releases will use the jcc-11.5.0.0.jar

     

    Note, Analyze uses Java 8 vs. LAE 6.1.4 which uses Java 7. There is a comment on this page that "JDK/JRE 1.8 support first included with JDBC drivers bundled with v10.5FP7" which, from the table, corresponds to v.4.19.49 for the db2jcc4.jar

    https://render-prd-trops.events.ibm.com/support/pages/db2-jdbc-driver-versions-and-downloads

     



  • 4.  RE: Data3Sixty Analyze Enterprise, DB2 Drivers, Connection Problem

    Posted 09-20-2019 08:08

    Hi Adrian,

    Thanks. We are running D360 Analyze (3.4.2). I loaded jcc-11.5.0.0.jar and I'm still getting the same error.

    We now have



  • 5.  RE: Data3Sixty Analyze Enterprise, DB2 Drivers, Connection Problem

    Posted 09-20-2019 08:11

    I'm not sure why that last post was cut. The files are installed in ../site-7731/lib/db/db2. In addition to the new jar the other jar files installed are listed in my original post.

    Thanks,

    Brad



  • 6.  RE: Data3Sixty Analyze Enterprise, DB2 Drivers, Connection Problem

    Employee
    Posted 09-20-2019 09:21

    The jcc-11.5.0.0.jar is an alternative to using the db2jcc4.jar.  I think you should be using one or the other (set) but not both - the node may be picking up the class from the db2jcc4.jar.

    Did you check the version number of the db2jcc4.jar you have installed to confirm whether it is one that is compatible with Java 8? 

    If you are using the jcc-11.5.0.0.jar instead then it will still need to be licensed so you will still need the b2jcc_license_cisuz.jar (you may get an error indicating it is not licensed if the driver jar cannot find this file when it is run). If this is the case you should add the site-7731/lib/db/db2 directory to the JDBC node's DbDriverClasspath property.



  • 7.  RE: Data3Sixty Analyze Enterprise, DB2 Drivers, Connection Problem

    Posted 09-20-2019 09:56

    Thanks, I should have remembered that. I removed the db2jcc4.jar, so it should only have access to jcc-11.5.0.0.jar. But, I'm getting the same error, "Unable to load driver class:...". Thoughts? Thanks, Brad



  • 8.  RE: Data3Sixty Analyze Enterprise, DB2 Drivers, Connection Problem

    Employee
    Posted 09-23-2019 07:02

    I believe the directory where the files are installed should be

     ../site-7731/lib/java/db/db2



  • 9.  RE: Data3Sixty Analyze Enterprise, DB2 Drivers, Connection Problem

    Posted 09-25-2019 08:44

    We resolved this by adding the string below to the DbDriverClasspath of a JDBC node.

    {{%ls.appdatadir%}}/lib/db/db2

    I believe the variable is a system variable. The rest of it is the remaining portion of the path that points to the location of the required drivers. I think we only need this for JDBC nodes connecting to DB2 db's.

    Thanks everyone! Brad