[jira] [Updated] (KYLIN-3798) SQL Server cannot list databases

["Shaofeng SHI (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/KYLIN-3798?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Shaofeng SHI updated KYLIN-3798:
--------------------------------
    Fix Version/s: v2.6.1

> SQL Server cannot list databases
> --------------------------------
>
>                 Key: KYLIN-3798
>                 URL: https://issues.apache.org/jira/browse/KYLIN-3798
>             Project: Kylin
>          Issue Type: Bug
>          Components: RDBMS Source
>            Reporter: XiaoXiang Yu
>            Assignee: XiaoXiang Yu
>            Priority: Major
>             Fix For: v2.6.1
>
>         Attachments: image-2019-01-30-11-14-11-939.png, image-2019-01-30-11-16-16-975.png, image-2019-01-30-11-16-41-320.png, image-2019-01-30-11-25-47-946.png
>
>
> User report sqlserver as data source didn't show databases. Following is his email:
>  
> {quote}Hi,
> {quote}
> {quote}    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:
>   
> {quote}
> {quote}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
> {quote}
> 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 
> {quote}<dependency>
>  <groupId>com.microsoft.sqlserver</groupId>
>  <artifactId>mssql-jdbc</artifactId>
>  <version>6.4.0.jre8</version>
> </dependency>
> {quote}
>  
>  
>   !image-2019-01-30-11-14-11-939.png!
>  
>  
> !image-2019-01-30-11-16-41-320.png!
>  
>    



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)