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

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

Freeman Fang created KARAF-3959:
-----------------------------------

             Summary: 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


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)