安裝環境：
JIRA 3.5.3 Enterprise EAR/WAR + TOMCAT5.5 + MSSQL2000

步驟：
  1. 下載企業版，地址http://www.atlassian.com/software/jira/JIRADownloadCenter.jspa
  2. 解壓到文件加%JIRA_HOME%
  3. 修改%JIRA_HOME%\edit-webapp\WEB-INF\classes\entityengine.xml
    ??1?<?xml?version="1.0"?encoding="UTF-8"??>
    ??2?<!DOCTYPE?entity-config?PUBLIC?"-//OFBiz//DTD?Entity?Engine?Config//EN"?"http://www.ofbiz.org/dtds/entity-config.dtd">
    ??3?<!--
    ??4?This?file?configures?the?OFBiz?Entity?Engine?which?JIRA?uses?to?store?persist?data?in?a?datasource.
    ??5?
    ??6?For?detailed?configuration?help?see:
    ??7?
    ??8????http://www.atlassian.com/software/jira/docs/latest/entityengine.html
    ??9?
    ?10?Or?our?server?specific?setup?guides?(these?take?you?through?the?setup?process?for?each?server):
    ?11?
    ?12????http://www.atlassian.com/software/jira/docs/latest/servers/
    ?13?
    ?14?Normally,?you?will?only?need?to?edit?the?'field-type-name'?attribute?of?the?<datasource>?tag,?near?the?bottom?of?this
    ?15?file.
    ?16?
    ?17?Less?commonly,?you?may?wish?to?change?then?JNDI?lookup?paths?for:
    ?18??-?the?Transaction?Manager?(<transaction-factory>?element)
    ?19??-??Database?connection?(<jndi-jdbc>?element).
    ?20?
    ?21?If?you?not?using?the?12?preconfigured?DBs,?you?may?also?need?to?add?your?own?field?type?definition
    ?22?-->
    ?23?<entity-config>
    ?24?????<resource-loader?name="maincp"?class="org.ofbiz.core.config.ClasspathLoader"/>
    ?25?
    ?26?????<!--?TRANSACTION?FACTORY?-?This?configures?how?JIRA?finds?the?application?server's?transaction?management.
    ?27?????The?default?('java:comp/UserTransaction')?is?fine?except?for?Tomcat?5.5?('java:comp/env/UserTransaction')?and?JBoss
    ?28?????-?see:
    ?29?????????http://www.atlassian.com/software/jira/docs/latest/entityengine.html#transactionfactory
    ?30?????-->
    ?31?????<transaction-factory?class="org.ofbiz.core.entity.transaction.JNDIFactory">
    ?32???????<user-transaction-jndi?jndi-server-name="default"?jndi-name="java:comp/env/UserTransaction"/>
    ?33???????<transaction-manager-jndi?jndi-server-name="default"?jndi-name="java:comp/env/UserTransaction"/>
    ?34?????</transaction-factory>
    ?35?
    ?36?????<delegator?name="default"?entity-model-reader="main"?entity-group-reader="main">
    ?37?????????<group-map?group-name="default"?datasource-name="defaultDS"/>
    ?38?????</delegator>
    ?39?
    ?40?????<entity-model-reader?name="main">
    ?41?????????<resource?loader="maincp"?location="entitydefs/entitymodel.xml"/>
    ?42?????</entity-model-reader>
    ?43?
    ?44?????<entity-group-reader?name="main"?loader="maincp"?location="entitydefs/entitygroup.xml"/>
    ?45?
    ?46?????<field-type?name="cloudscape"?loader="maincp"?location="entitydefs/fieldtype-cloudscape.xml"/>
    ?47?????<field-type?name="firebird"?loader="maincp"?location="entitydefs/fieldtype-firebird.xml"/>
    ?48?????<!--
    ?49???????JRA-3657:?HSQLDB?>=?1.7.2?(not?the?version?in?Standalone)?has?'position'?as?a?reserved?word?so?make?the?following?changes?the?entitymodel.xml
    ?50???????<field?name="position"?type="integer"/>?to?<field?name="position"?col-name="positionsequence"?type="integer"/>
    ?51?????-->
    ?52?????<field-type?name="hsql"?loader="maincp"?location="entitydefs/fieldtype-hsql.xml"/>
    ?53?????<field-type?name="mckoidb"?loader="maincp"?location="entitydefs/fieldtype-mckoidb.xml"/>
    ?54?????<field-type?name="mysql"?loader="maincp"?location="entitydefs/fieldtype-mysql.xml"/>
    ?55?????<field-type?name="mssql"?loader="maincp"?location="entitydefs/fieldtype-mssql.xml"/>
    ?56?????<!--
    ?57?????????This?field?type?is?deprecated,?and?should?ONLY?be?used?with?Oracle?8i.
    ?58?????????If?you?are?using?Oracle?9i?or?10g?please?use?Oracle?10g?JDBC?drivers?and?the?'oracle10g'?field?type,?which?is?specified?below
    ?59?????-->
    ?60?????<field-type?name="oracle"?loader="maincp"?location="entitydefs/fieldtype-oracle.xml"/>
    ?61?????<!--
    ?62?????????Please?use?this?field?type?for?Oracle?9i?and?10g.?Please?ensure?that?you?are?using?Oracle?10g?JDBC?drivers?which?are?compatible?with?Oracle?9i.
    ?63?????????The?10g?JDBC?drivers?can?be?downloaded?from?here:?http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html
    ?64?????-->
    ?65?????<field-type?name="oracle10g"?loader="maincp"?location="entitydefs/fieldtype-oracle10g.xml"/>
    ?66?????<field-type?name="postgres"?loader="maincp"?location="entitydefs/fieldtype-postgres.xml"/>
    ?67?????<field-type?name="postgres72"?loader="maincp"?location="entitydefs/fieldtype-postgres72.xml"/>?<!--?use?for?postgres?7.2?and?above?-->
    ?68?????<field-type?name="sapdb"?loader="maincp"?location="entitydefs/fieldtype-sapdb.xml"/>
    ?69?????<field-type?name="sybase"?loader="maincp"?location="entitydefs/fieldtype-sybase.xml"/>
    ?70?????<field-type?name="db2"?loader="maincp"?location="entitydefs/fieldtype-db2.xml"/>
    ?71?????<!--
    ?72?????????JRA-4202:?FrontBase?has?'type'?and?'position'?as?reserved?words?so?make?the?following?changes?the?entitymodel.xml
    ?73?????????<field?name="type"?type="short-varchar"/>?to?<field?name="type"?col-name="TYPE_"?type="short-varchar"/>
    ?74?????????<field?name="type"?type="long-varchar"/>?to?<field?name="type"?col-name="TYPE_"?type="long-varchar"/>
    ?75?????????<field?name="position"?type="integer"/>?to?<field?name="position"?col-name="POSITION_"?type="integer"/>
    ?76?????-->
    ?77?????<field-type?name="frontbase"?loader="maincp"?location="entitydefs/fieldtype-frontbase.xml"/>
    ?78?
    ?79?
    ?80?????<!--?DATASOURCE?-?You?will?need?to?update?this?tag?for?your?installation.
    ?81?
    ?82?????????1.?Update?field-type-name?attribute?to?match?your?database.
    ?83?????????Possible?values?include:?cloudscape,?db2,?firebird,?frontbase,?hsql,?mckoidb,?mysql,?mssql,?oracle10g,?oracle,?postgres,?postgres72,?sapdb,?sybase
    ?84?????????2.?If?using?Orion,?JBoss?or?Jetty?you?will?need?to?customize?the?<jndi-jdbc>?tag.
    ?85???????????See?http://www.atlassian.com/software/jira/docs/latest/servers/
    ?86?????????3.?If?using?Postgres?7.3+?(schema-aware),?add:
    ?87?????????????schema-name="public"
    ?88???????????to?the?datasource?attribute?list?below.
    ?89??????????If?using?DB2,?add:
    ?90?????????????constraint-name-clip-length="15"
    ?91???????????to?the?datasource?attribute?list?below,?and?an?appropriate?schema-name?attribute,?eg:
    ?92?????????????schema-name="DB2INST1"
    ?93??????-->
    ?94?????<datasource?name="defaultDS"?field-type-name="mssql"
    ?95?????????helper-class="org.ofbiz.core.entity.GenericHelperDAO"
    ?96???????check-on-start="true"
    ?97???????use-foreign-keys="false"
    ?98???????use-foreign-key-indices="false"
    ?99???????check-fks-on-start="false"
    100???????check-fk-indices-on-start="false"
    101???????add-missing-on-start="true"
    102???????check-indices-on-start="true">
    103?????????<jndi-jdbc?jndi-server-name="default"?jndi-name="java:comp/env/jdbc/JiraDS"/>
    104?<!--?Orion?format:?<jndi-jdbc?jndi-server-name="default"?jndi-name="jdbc/JiraDS"/>?-->
    105?<!--?JBoss?format:?<jndi-jdbc?jndi-server-name="default"?jndi-name="java:/DefaultDS"/>?-->
    106?<!--?Weblogic?format:?<jndi-jdbc?jndi-server-name="default"?jndi-name="JiraDS"/>?-->
    107?<!--?Jetty?format:?<inline-jdbc?jdbc-driver="org.hsqldb.jdbcDriver"?jdbc-uri="jdbc:hsqldb:path/to/jiradb"?jdbc-username="sa"?jdbc-password=""?isolation-level="ReadUncommitted"?/>?-->
    108?????</datasource>
    109?</entity-config>
  4. 下載jtds-1.2-dist.zip,用微軟的jdbc，會出錯
  5. 新建數據庫jiradb,用戶:jiradbuser,密碼:**
  6. 修改%JIRA_HOME%\etc\tomcat-5.5-jira.xml
    ?1?<!--
    ?2?A?sample?configuration?file?for?Tomcat?5.5
    ?3?Customize?the?docBase?attribute,?drop?in?your?$CATALINA_HOME/conf/Catalina/localhost/jira.xml
    ?4?Note?the?JOTM?dependencies;?you'll?need?to?copy?various?jars?to?Tomcat's?common/lib/?directory.
    ?5?-->
    ?6?<Context?path="/jira"?docBase="E:\Software\SCM\atlassian-jira-enterprise-3.5.3\dist-tomcat\atlassian-jira-3.5.3.war"?debug="0">
    ?7?
    ?8?????<!--?NOTE:?If?you?use?a?database?other?than?hsqldb:
    ?9?????*?delete?the?minEvictableIdleTimeMillis?and?timeBetweenEvictionRunsMillis?attributes
    10?????*?change?the?database?type?in?atlassian-jira/WEB-INF/classes/entityengine.xml
    11?????-->
    12?????<Resource?name="jdbc/JiraDS"?auth="Container"?type="javax.sql.DataSource"
    13?????????????username="jirauser"
    14?????????????password="jira"
    15?????????????driverClassName="net.sourceforge.jtds.jdbc.Driver"
    16?????????????url="jdbc:jtds:sqlserver://localhost:1433/jiradb"/>
    17?
    18?????<Resource?name="UserTransaction"?auth="Container"?type="javax.transaction.UserTransaction"
    19?????factory="org.objectweb.jotm.UserTransactionFactory"?jotm.timeout="60"/>
    20?????<Manager?className="org.apache.catalina.session.PersistentManager"?saveOnRestart="false"/>
    21?
    22?</Context>
    23?
  7. 運行%JIRA_HOME%\build.bat
  8. 將%JIRA_HOME%\dist-tomcat\tomcat-5.5\jira.xml拷貝到%TOMCAT_HOME%\conf\Catalina\localhost
  9. 運行%TOMCAT_HOME%\bin\startup.bat
  10. 網上有keygen.class用它生成license key。可惜有效期只有一年