???? 整了老半天,發(fā)現(xiàn)用的自帶的那數(shù)據(jù)庫不穩(wěn)定,只好把數(shù)據(jù)庫換成MSSQL2000
???? 問題也找不到文檔,只好摸索了,我先試著把server.xml的數(shù)據(jù)庫連接改為下面的值
?<Resource name="jdbc/JiraDS" auth="Container" type="javax.sql.DataSource"
??????????? username="sa"
??????????? password="sa"
??????????? driverClassName="com.microsoft.jdbc.sqlserver.SQLServerDriver"
??????????? url="jdbc:microsoft:sqlserver://127.0.0.1:1433;SelectMethod=cursor;DatabaseName=jiradb"
???????????? />

啟動,找不到com.microsoft.jdbc.sqlserver.SQLServerDriver,把SQL2000的驅(qū)動msbase.jar mssqlserver.jar msutil.jar放在了atlassian-jira-enterprise-3.6.5-standalone\common\lib

這個地方是過了,但是數(shù)據(jù)庫里面建的表全亂了,連SEQUENCE_VALUE_ITEM這樣的表里面的字段長度全是1位的,手工改動肯定不行的,用IE進入http//127.0.0.1:8080,居然提示entityengine.xml里面陪著的數(shù)據(jù)庫是HSQL,不能用SQL2000,于是我真于找到原因了,打開atlassian-jira-enterprise-3.6.5-standalone\atlassian-jira\WEB-INF\classes下的entityengine.xml,把
<datasource name="defaultDS" field-type-name="hsql"
??????? helper-class="org.ofbiz.core.entity.GenericHelperDAO"
????? check-on-start="true"
????? use-foreign-keys="false"
????? use-foreign-key-indices="false"
????? check-fks-on-start="false"
????? check-fk-indices-on-start="false"
????? add-missing-on-start="true"
????? check-indices-on-start="true">

改為

<datasource name="defaultDS" field-type-name="mssql"
??????? helper-class="org.ofbiz.core.entity.GenericHelperDAO"
????? check-on-start="true"
????? use-foreign-keys="false"
????? use-foreign-key-indices="false"
????? check-fks-on-start="false"
????? check-fk-indices-on-start="false"
????? add-missing-on-start="true"
????? check-indices-on-start="true">


啟動TOMCAT,一切順利