Details

    • Customer Case:
    • PDI Sub-component:
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.
    • QA Validation Status:
      Validated by QA
    • CI Build:
      October 5 build.

      Description

      The current pre configured Vertica database connection type is set to use the JDBC driver class "com.vertica.Driver" for older versions of Vertica's driver. However, Vertica 5.1 JDBC driver class has now changed to "com.vertica.jdbc.Driver" so using the pre configured connection type no longer works for the new version. The obvious workaround would be to use the "Generic database" connection type and manually specify the correct driver class name.

        Issue Links

          Activity

          Hide
          Jens Bleuel added a comment -

          Discussed with Matt: it would probably be easier just to create a new Database type "Vertica 5+". That way there would be no compatibility issues.

          Show
          Jens Bleuel added a comment - Discussed with Matt: it would probably be easier just to create a new Database type "Vertica 5+". That way there would be no compatibility issues.
          Hide
          Jake Cornelius added a comment -

          we should validate this with version 6 as well once implemented

          Show
          Jake Cornelius added a comment - we should validate this with version 6 as well once implemented
          Hide
          Jens Bleuel added a comment -

          Implemented in rev. 17232 (4.4.0) and rev. 17233 (trunk).
          I validated that it loads the vertica-jdk5-6.0.0-0.jar with the "Vertica 5+" database type (using "com.vertica.jdbc.Driver").

          Show
          Jens Bleuel added a comment - Implemented in rev. 17232 (4.4.0) and rev. 17233 (trunk). I validated that it loads the vertica-jdk5-6.0.0-0.jar with the "Vertica 5+" database type (using "com.vertica.jdbc.Driver").
          Hide
          Sean Flatley added a comment -

          Validating.

          Show
          Sean Flatley added a comment - Validating.
          Hide
          Sean Flatley added a comment -

          Validated using my Vertica 6.0.0 for ESX VM as the databse and the vertica-jdk5-6.0.0-0.jar.

          I ran the attached transformation and performed Database Explorer functions. Rowcounts, etc....

          Show
          Sean Flatley added a comment - Validated using my Vertica 6.0.0 for ESX VM as the databse and the vertica-jdk5-6.0.0-0.jar. I ran the attached transformation and performed Database Explorer functions. Rowcounts, etc....

            People

            • Assignee:
              Sean Flatley
              Reporter:
              Christopher Morehouse
            • Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: