You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@gobblin.apache.org by "Abhishek Tiwari (JIRA)" <ji...@apache.org> on 2017/07/25 00:22:00 UTC

[jira] [Updated] (GOBBLIN-27) SQL Server - incomplete JDBC URL

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

Abhishek Tiwari updated GOBBLIN-27:
-----------------------------------
    Sprint: Apache Gobblin 170724

> SQL Server - incomplete JDBC URL
> --------------------------------
>
>                 Key: GOBBLIN-27
>                 URL: https://issues.apache.org/jira/browse/GOBBLIN-27
>             Project: Apache Gobblin
>          Issue Type: Bug
>            Reporter: Abhishek Tiwari
>            Assignee: Arjun Singh Bora
>
> The connection URL lacks the database name. The URL returned by getConnectionUrl() (in SqlServerExtractor.java) looks like this `jdbc:sqlserver://sql_server_host:1433` but should be `jdbc:sqlserver://sql_server_host:1433;databaseName=myDb` (similar to what is done for MySQL).
> I propose the following fix
> `String database = this.workUnitState.getProp(ConfigurationKeys.SOURCE_QUERYBASED_SCHEMA);
>     String url = jdbc:sqlserver:// + host.trim() + : + port + ;databaseName= + database.trim();`
>  
> *Github Url* : https://github.com/linkedin/gobblin/issues/1867 
> *Github Reporter* : *debelyoo* 
> *Github Created At* : 2017-05-15T12:35:44Z 
> *Github Updated At* : 2017-05-16T05:58:33Z



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)