Details
-
Suggestion
-
Resolution: Fixed
-
None
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&useUnicode=true&characterEncoding=UTF8"/>