dataverse DB2 Iseries JDBC Connection

Comments

9 comments

  • Avatar
    Adrian Williams

    Hi Kevin,

    have you populated the driver's path in the DbDriverClasspath property?

     

    Also, its not clear whether /opt/dataverse-3.2.0/ is the Dataverse installation directory but if it is, the recommendation is to not install drivers in folders within the Dataverse installation directory. Rather the Dataverse install's site folder structure should be used, see the help article here:

    https://d3sa-preview.infogixsaas.com/docs/dist/help/Default.htm#e-node-help/Acquisition/jdbc-query.html#Advanced

    [Edit: ^ Updated URL]

    Regards,

    Adrian

     

    0
    Comment actions Permalink
  • Avatar
    Kevin Stanfield

    Thanks Adrian - I can't open the help article for some reason?

    I used the help functionality originally which gave the location for the driver file as detailed above.

    http://192.168.254.87:8081/docs/dist/help/Default.htm#h-tech-guides/database-connection-urls.htm

    0
    Comment actions Permalink
  • Avatar
    Adrian Williams

    Strange. The preview site's help is accessible from the wider internet (and I just checked it is still up and running).

    Maybe something to do with the routing of *.lavastorm.com from your site?

    The navigation within the help is Input Connectors > JDBC Query > Advanced database connection

    which should display this text

     

    0
    Comment actions Permalink
  • Avatar
    Kevin Stanfield

    Thanks Adrian,  possibly a lavastorm.com routing I've tried a number of ways but no success.

    Using the example of the file location /opt/dataverse-3.2.0/lib/java/macaccess/uclanload.jar should we be using:

    /opt/dataverse-3.2.0/lib/java/DB2access/jt400.jar

    with the same value in the DBDriverClassPath as above?

    Thanks

     

    0
    Comment actions Permalink
  • Avatar
    Adrian Williams

    The folders under the Dataverse install directory are for drivers that are shipped with the application.

    The page you are referring to includes this information:

    When the property value {{%ls.appDataDir%}} is substituted it should identify the site folder of the Dataverse instance. You can check how it is being resolved by configuring a Create Data node with the following in the 'Data' property:

    path

     {{%ls.appDataDir%}}

     

    e.g.

    When run it should give you the path to the site folder. Your driver should then be placed in a sub-directory of this folder, at: lib/java/db/<driverName>

    You can then either use the system property in in the DbDriverClasspath property (it will automatically resolved when the node is run) or you can manually enter the resolved path

    0
    Comment actions Permalink
  • Avatar
    Kevin Stanfield

    Thanks Adrian, will take a look on Monday. Have a great weekend.

    0
    Comment actions Permalink
  • Avatar
    Kevin Stanfield

    /opt/dataverse-3.2.0/Dataverse/site-7731/ is the path returned.

    So the driver should be installed at  /opt/dataverse-3.2.0/Dataverse/site-7731/lib/java/db/DB2i/jt400.jar 

    thanks

    0
    Comment actions Permalink
  • Avatar
    Adrian Williams

    Yes, and the DbDriverClasspath set to  /opt/dataverse-3.2.0/Dataverse/site-7731/lib/java/db/DB2i

     

    0
    Comment actions Permalink
  • Avatar
    Kevin Stanfield

    I'll try that Adrian - thanks

    0
    Comment actions Permalink

Please sign in to leave a comment.



Powered by Zendesk