You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "Shaofeng SHI (JIRA)" <ji...@apache.org> on 2019/02/22 10:32:00 UTC
[jira] [Resolved] (KYLIN-3798) SQL Server cannot list databases
[ https://issues.apache.org/jira/browse/KYLIN-3798?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Shaofeng SHI resolved KYLIN-3798.
---------------------------------
Resolution: Fixed
> 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)