Documentation for SQL Server should include setting the autoCommit parameter in JDBC URL

XMLWordPrintable

    • Type: Suggestion
    • Resolution: Fixed
    • Component/s: Documentation
    • None

      NOTE: This suggestion is for JIRA Cloud. Using JIRA Server? See the corresponding suggestion.

      Problem Definition

      The "connecting JIRA to SQL Server" documentations do not mention the autoCommit parameter in the JDBC URLs. This parameter is needed to prevent deadlocks as per https://confluence.atlassian.com/jirakb/deadlock-when-running-jira-with-sql-server-283640022.html and so it should be a required configuration in JIRA's dbconfig.xml.

      Suggested Solution

      Modify the documentation to include autoCommit=false parameter by default:
      https://confluence.atlassian.com/jira063/connecting-jira-to-sql-server-2012-683541742.html
      https://confluence.atlassian.com/display/JIRA064/Connecting+JIRA+to+SQL+Server+2008

            Assignee:
            iceman
            Reporter:
            Daniel Leng (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: