[jira] [Resolved] (KARAF-3959) make jdbc:create work better with MS SQL Server

["Freeman Fang (JIRA)" <ji...@apache.org>]

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

Freeman Fang resolved KARAF-3959.
---------------------------------
       Resolution: Fixed
    Fix Version/s: 2.4.4
                   3.0.5

commit fix
http://git-wip-us.apache.org/repos/asf/karaf/commit/7e332da6 for karaf-2.x branch
http://git-wip-us.apache.org/repos/asf/karaf/commit/0c7e0f47 for karaf-3.0.x branch

> make jdbc:create work better with MS SQL Server
> -----------------------------------------------
>
>                 Key: KARAF-3959
>                 URL: https://issues.apache.org/jira/browse/KARAF-3959
>             Project: Karaf
>          Issue Type: Improvement
>            Reporter: Freeman Fang
>            Assignee: Freeman Fang
>             Fix For: 3.0.5, 2.4.4
>
>
> We use net.sourceforge.jtds.jdbcx.JtdsDataSource to generate the datasource for MS SQL Server, however, to configure the datasource this is no url JtdsDataSource, it just need specify the serverName, databaseName, portNumber, user, password separately.
> Though we can map the url to serverName with command like
> {code}
> jdbc:create -t MSSQL -i -u user -p pass -url mssql.server.name datasourceName
> {code}
> to create the datasource successfully, we still have isssues like
> 1. User have to use same name for datasource as db name.
> 2. User couldn't set server port (so only standard 1433 is applicable).
> which IMO is important to configure the datasource and so we should enable it



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)