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