安裝環(huán)境:
JIRA 3.5.3 Enterprise EAR/WAR + TOMCAT5.5 + MSSQL2000
步驟:
JIRA 3.5.3 Enterprise EAR/WAR + TOMCAT5.5 + MSSQL2000
步驟:
- 下載企業(yè)版,地址http://www.atlassian.com/software/jira/JIRADownloadCenter.jspa
- 解壓到文件加%JIRA_HOME%
- 修改%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> - 下載jtds-1.2-dist.zip,用微軟的jdbc,會(huì)出錯(cuò)
- 新建數(shù)據(jù)庫(kù)jiradb,用戶(hù):jiradbuser,密碼:**
- 修改%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? - 運(yùn)行%JIRA_HOME%\build.bat
- 將%JIRA_HOME%\dist-tomcat\tomcat-5.5\jira.xml拷貝到%TOMCAT_HOME%\conf\Catalina\localhost
- 運(yùn)行%TOMCAT_HOME%\bin\startup.bat
- 網(wǎng)上有keygen.class用它生成license key。可惜有效期只有一年