日期:2014-05-16  浏览次数:20740 次

jira与mysql数据的整合

第一步:电脑上安装mysql数据库,不做多得解释,自己搞定

?

第二步; 在mysql数据库中建一个名为 jiradb的数据库,账号 root 密码? root? 编码格式? utf-8

?

第三步: 在jira默认数据库里面(就是安装的时间的第二个路径;也就是数据保存的地方)找到一个文件名为dbconfig.xml的文件,将

<jira-database-config>
? <name>defaultDS</name>
? <delegator-name>default</delegator-name>
? <database-type>hsql</database-type>
? <schema-name>PUBLIC</schema-name>
? <jdbc-datasource>
??? <url>jdbc:hsqldb:E:\jiraData/database/jiradb</url>
??? <driver-class>org.hsqldb.jdbcDriver</driver-class>
??? <username>sa</username>
??? <password></password>
??? <pool-size>20</pool-size>
??? <min-evictable-idle-time-millis>4000</min-evictable-idle-time-millis>
??? <time-between-eviction-runs-millis>5000</time-between-eviction-runs-millis>
? </jdbc-datasource>
</jira-database-config>

?

?

这段代码修改为

<jira-database-config>
? <name>defaultDS</name>
? <delegator-name>default</delegator-name>
? <database-type>mysql</database-type>
? <jdbc-datasource>
??? <url>jdbc:mysql://localhost:3306/jiradb?autoReconnect=true&amp;useUnicode=true&amp;characterEncoding=UTF8</url>
??? <driver-class>com.mysql.jdbc.Driver</driver-class>
??? <username>root</username>
??? <password>root</password>
??? <pool-size>20</pool-size>
??? <min-evictable-idle-time-millis>4000</min-evictable-idle-time-millis>
??? <time-between-eviction-runs-millis>5000</time-between-eviction-runs-millis>
? </jdbc-datasource>
</jira-database-config>

?

?

重新启动服务,与mysql整合成功

?

jira

?

AAABLQ0ODAoPeNptkFFrwjAQx9/zKQp7jiQRaRUCc20eutXqWt1g7CWLN81oU01b0X36pXYyHD4cH
Hf3//3v7u4V1l4EyiO+R8YTwiZ07IX50mOEUhRBrazeNboy/DHOpu8TTxxk0cqugkIL5ySSDfBuH
lOGSYDCyjRSNaksgR/bQgcBoWx0v98PVFWiL23lINEKTA1irc9skS5FtsjiXFzEYiZ1cUP9Z88b2
8IVbXnawdk0nM9mIgvjadL3HU8foBcU/ewL2LqDMOSMTANGGgXiuNP2dDnH3UIx8dHcbqTRdW/6v
a3MZtNWPThtyw+w889V7XAcU5SLlLvACR0GbMhcAewBbBzxh1FKcZKkAQ7fyBNe5c8++t3bdZM4u
pJd/nNzoUVr1VbW8P/vPz7IkyQwLQIVAIZHfW/i4a/4JRFLfRVJoCRqcOOzAhQrxf/vwHfO9bDsJ
bGHJAu+Ik1aYA==X02f7