Description
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
jdbc:create -t MSSQL -i -u user -p pass -url mssql.server.name datasourceName
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