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

SQL Server cannot list databases

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • v2.6.1
    • RDBMS Source
    • 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-25-47-946.png
          257 kB
          Xiaoxiang Yu
        2. image-2019-01-30-11-16-41-320.png
          562 kB
          Xiaoxiang Yu
        3. image-2019-01-30-11-16-16-975.png
          562 kB
          Xiaoxiang Yu
        4. image-2019-01-30-11-14-11-939.png
          201 kB
          Xiaoxiang Yu

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: