kylin-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF subversion and git services (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (KYLIN-3798) SQL Server cannot list databases
Date Mon, 11 Feb 2019 05:54:00 GMT

    [ https://issues.apache.org/jira/browse/KYLIN-3798?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16764678#comment-16764678
] 

ASF subversion and git services commented on KYLIN-3798:
--------------------------------------------------------

Commit 5e9d53311637efcb04fc8529f6682d17a6f08968 in kylin's branch refs/heads/master from hit-lacus
[ https://gitbox.apache.org/repos/asf?p=kylin.git;h=5e9d533 ]

KYLIN-3798 SQL Server cannot show databases


> 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
>         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)

Mime
View raw message