Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-16207

The "Surviving Connection Closures" page on Confluence still includes autoReconnect=true in the example MySQL configuration

    XMLWordPrintable

Details

    • We collect Jira feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

    Description

      Surviving Connection Closures includes using autoReconnect=true in the connection URL.
      This is not recommended to be used, we should just use the validationQuery (which is already included).

      The sample URL should look like:

      <Resource name="jdbc/JiraDS" auth="Container" type="javax.sql.DataSource"
          driverClassName="com.mysql.jdbc.Driver"
          url="jdbc:mysql://localhost/jiradb?useUnicode=true&amp;characterEncoding=UTF8"
          username="jirauser"
          password="jirapassword"
          maxActive="20"
          validationQuery="select 1" />
      

      Note that I changed the order of properties and added some indenting. This is not necessary, but I think it aids readability.

      Attachments

        Activity

          People

            alui Andrew
            mlassau Mark Lassau (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: