Uploaded image for project: 'Karaf'
  1. Karaf
  2. KARAF-3959

make jdbc:create work better with MS SQL Server

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 3.0.5, 2.4.4
    • None
    • None

    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

      Attachments

        Activity

          People

            ffang Freeman Yue Fang
            ffang Freeman Yue Fang
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: