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