Data3Sixty Analyze Enterprise, DB2 Drivers, Connection Problem

Comments

8 comments

  • Avatar
    Brad Brezinski

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

    0
    Comment actions Permalink
  • Avatar
    Adrian Williams

    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

     

    0
    Comment actions Permalink
  • Avatar
    Brad Brezinski

    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

    0
    Comment actions Permalink
  • Avatar
    Brad Brezinski

    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

    0
    Comment actions Permalink
  • Avatar
    Adrian Williams

    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.

    0
    Comment actions Permalink
  • Avatar
    Brad Brezinski

    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

    0
    Comment actions Permalink
  • Avatar
    Adrian Williams

    I believe the directory where the files are installed should be

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

    0
    Comment actions Permalink
  • Avatar
    Brad Brezinski

    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

    0
    Comment actions Permalink

Please sign in to leave a comment.



Powered by Zendesk