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

Error in Tomcat 6 Mysql documentation

    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

      The above example assumes you are using hsql (an in-memory database — a good choice for a first attempt). Here is an example using MySQL:

      <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&useUnicode=true&characterEncoding=UTF8"/>
      <Resource name="UserTransaction" auth="Container" type="javax.transaction.UserTransaction"
      factory="org.objectweb.jotm.UserTransactionFactory"
      jotm.timeout="60"/>
      <Manager pathname=""/>
      </Context>

      Notice the lack of minEvictableIdleTimeMillis and timeBetweenEvictionRunsMillis parameters - those should only be used with hsql. If using a different database than hsql, remember to update the field-type-name (see above) and copy the JDBC driver jar to lib/ (see the database configuration guide).

      This line

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

      should read:

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

      Attachments

        Activity

          People

            alui Andrew
            twong Tim Wong (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: