JIRA Deployment Fails with MySQL 4.1.x on Ubuntu
症状
JIRA fails to create MySQL tables on Ubuntu. The following appears in the atlassian-jira.log
:
org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:OSPropertyEntry][propertyKey,jira.i18n.language.index][type,5][id,10000][entityName,jira.properties][entityId,1] (SQL Exception while executing the following:INSERT INTO propertyentry (ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, propertytype) VALUES (?, ?, ?, ?, ?) (Incorrect arguments to mysql_stmt_execute))
原因
This is due to an Ubuntu/Debian packaging problem. It's also discussed on Atlassian's forums.
ソリューション
Edit the following section in your server.xml:
<Context docBase="${catalina.home}/atlassian-jira" path="" reloadable="false"> <Resource auth="Container" driverClassName="com.mysql.jdbc.Driver" maxActive="20" name="jdbc/JiraDS" password="Eet4Vape" type="javax.sql.DataSource" url="jdbc:mysql://localhost/jiradb?useUnicode=true&characterEncoding=UTF8" username="jirauser"/>
Edit the section that starts with "url=" and append 'useServerPrepStmts=false' So that the JDBC URL looks like the following:
url"jdbc:mysql://localhost/jiradb?useServerPrepStmts=false"
Restart of JIRA for the changes to take effect.
最終更新日 2016 年 4 月 7 日
Powered by Confluence and Scroll Viewport.