Uploaded image for project: 'Bitbucket Data Center'
  1. Bitbucket Data Center
  2. BSERV-3108

SQL Server URLs with instance names don't reload correctly

    XMLWordPrintable

Details

    Description

      Stash 2.1 replaced the jTDS JDBC driver with Microsoft's own, for accessing SQL Server. Microsoft's JDBC URL allows for the following layout:

      jdbc:sqlserver://hostname\instanceName:port;databaseName=database;
      

      When using Stash's in-app screens for configuring a database, "hostname\instanceName" can be put into the hostname text box. Migration will complete successfully, and the system will connect to the desired instance.

      However, when the JDBC URL is written into stash-config.properties, the \ between the hostname and instance name is not escaped (since the system does not actually support this usage). As a result, the first time the server is restarted the value becomes "hostnameinstanceName", because the \ is stripped as an invalid escape, and the database connection fails.

      Attachments

        Activity

          People

            bturner Bryan Turner (Inactive)
            bturner Bryan Turner (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: