[KYLIN-3798] SQL Server cannot list databases

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: v2.6.1
• Component/s: RDBMS Source
• Assignee: Xiaoxiang Yu
• Reporter: Xiaoxiang Yu
• Created: 30/Jan/19 03:15
• Updated: 08/Mar/19 01:19
• Resolved: 22/Feb/19 10:31

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>

 

 

 

 

 

 

   

Issue Links

• links to: GitHub Pull Request #459