Uploaded image for project: 'Kylin'
  1. Kylin
  2. KYLIN-3798

SQL Server cannot list databases

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: v2.6.1
    • Component/s: RDBMS Source
    • Labels:
      None

      Description

      User report sqlserver as data source didn't show databases. Following is his email:

       

      Hi,

          I followed all the steps in this url http://kylin.apache.org/docs/tutorial/setup_jdbc_datasource.html , but when i click on Load table button or Load table from tree i don't seem to have any tables loaded from the SQL Server data source.There are no errors/exceptions in the logs too.
       
      kylin.properties:
       

      kylin.source.default=8
      kylin.source.jdbc.connection-url=jdbc:sqlserver://hostname:1433;database=sample
      kylin.source.jdbc.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
      kylin.source.jdbc.dialect=mssql
      kylin.source.jdbc.user=user
      kylin.source.jdbc.pass=pass
      kylin.source.jdbc.sqoop-home=sqoophome
      kylin.source.jdbc.filed-delimiter=|
      kylin.source.jdbc.sqoop-mapper-num=4

      I reproduce this bug in my dev env. And I find this question was caused by SQLServerJdbcMetadata. I have modified  SQLServerJdbcMetadata and databases could be showed.

       

      My env: SqlServer version is 2017, and JDBC Driver version is 

      <dependency>
      <groupId>com.microsoft.sqlserver</groupId>
      <artifactId>mssql-jdbc</artifactId>
      <version>6.4.0.jre8</version>
      </dependency>

       

       

       

       

       

       

         

        Attachments

        1. image-2019-01-30-11-14-11-939.png
          201 kB
          Xiaoxiang Yu
        2. image-2019-01-30-11-16-16-975.png
          562 kB
          Xiaoxiang Yu
        3. image-2019-01-30-11-16-41-320.png
          562 kB
          Xiaoxiang Yu
        4. image-2019-01-30-11-25-47-946.png
          257 kB
          Xiaoxiang Yu

          Issue Links

            Activity

              People

              • Assignee:
                hit_lacus Xiaoxiang Yu
                Reporter:
                hit_lacus Xiaoxiang Yu
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: