???? 整了老半天,發現用的自帶的那數據庫不穩定,只好把數據庫換成MSSQL2000
???? 問題也找不到文檔,只好摸索了,我先試著把server.xml的數據庫連接改為下面的值
?<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的驅動msbase.jar mssqlserver.jar msutil.jar放在了atlassian-jira-enterprise-3.6.5-standalone\common\lib
這個地方是過了,但是數據庫里面建的表全亂了,連SEQUENCE_VALUE_ITEM這樣的表里面的字段長度全是1位的,手工改動肯定不行的,用IE進入http//127.0.0.1:8080,居然提示entityengine.xml里面陪著的數據庫是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,一切順利
posted on 2007-02-16 09:54
還沒想好名 閱讀(823)
評論(0) 編輯 收藏 所屬分類:
技術