Improvement on Tomcat 6.x, 5.5 documents

XMLWordPrintable

      In the documentations regarding setting up JIRA on Tomcat on the following pages:

      We give example of connecting JIRA to a MySQL database.

      <Context path="/jira" docBase="path/to/atlassian-jira-3.12.2.war">
        <Resource name="jdbc/JiraDS" auth="Container" type="javax.sql.DataSource"
          username="jirauser"
          password="mypassword"
          driverClassName="com.mysql.jdbc.Driver"
          url="jdbc:mysql://localhost/jiradb?autoReconnect=true"/>
        <Resource name="UserTransaction" auth="Container" type="javax.transaction.UserTransaction"
          factory="org.objectweb.jotm.UserTransactionFactory"
          jotm.timeout="60"/>
        <Manager pathname=""/>
      </Context>
      

      the URL parameter should be constructed

      url="jdbc:mysql://localhost/jiradb?autoReconnect=true&amp;useUnicode=true&amp;characterEncoding=UTF8"
      

      There is a significant number of the cases in SAC where customers have problems with encoding if the character encoding is not specified in the URL. Additionally, it would keep our documentation consistent across all pages referring to Mysql; e.g. http://www.atlassian.com/software/jira/docs/latest/databases/mysql.html

      Basically, people don't intend to navigate to the MySQL configuration page since we provide the example on the Tomcat integration pages.

              Assignee:
              Andrew
              Reporter:
              Bogdan Dziedzic [Atlassian]
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: