Uploaded image for project: 'Apache Hop (Retired)'
  1. Apache Hop (Retired)
  2. HOP-3964

MSSQL "Generic database" Connection with native JDBC Driver doesn't work

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Invalid
    • None
    • Not applicable
    • None
    • None
    • hop 1.2, jdk11 (Temurin), SQL Server 2016, mssql-jdbc-10.2.1.jre11.jar

    Description

      Hi,

      tried to connect to MSSQL Server 2016 via "Generic database" connection.

      With the jtds JDBC Driver it works, with the native mssql-jdbc driver it doesn't.

      Tried the same on PDI, there it works. So sems to be right url and driver class.

      Also tried using the URL in hop using the "MS SQL Server (Native)" connection typ.

      It worked, but i had to add an Databasename though when you enter an url the field "Database Name" is disabled and it doesn't matter what is enterd in "Database Name" [ |https://sourceforge.net/projects/jtds/files/jtds/]

      Attachments

        Activity

          tohrke Tobias Kuhrke added a comment -

          Wrong jdk during testing, sorry (HOP_JAVA_HOME) was gone

          tohrke Tobias Kuhrke added a comment - Wrong jdk during testing, sorry (HOP_JAVA_HOME) was gone

          People

            Unassigned Unassigned
            tohrke Tobias Kuhrke
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: