페이지 트리
메타 데이터의 끝으로 건너뛰기
메타 데이터의 시작으로 이동

These instructions will help you connect JIRA to a PostgreSQL database. A version of these instructions specific to Linux and JIRA is available.

시작하기 전에

Do not use HSQLDB in production

JIRA ships with a built-in HSQLDB (HyperSQL DataBase) database. While this database is suitable for evaluation purposes, it is susceptible to data loss during system crashes. Hence, for production environments we strongly recommend that you configure JIRA to use an external database. See our list of supported databases on Connecting JIRA to HSQLDB.

페이지목차:

 

1. HSQLDB 드라이버를 어플리케이션 서버에 복사하기

Skip this step if you are using JIRA Standalone, as JIRA Standalone includes the driver.

  1. Download the HSQLDB JDBC driver — hsqldb-1.8.0.5.jar for JIRA 3.7+, or hsqldb-1.7.1-patched.jar for JIRA 3.6.5 and earlier. We strongly recommend upgrading to 3.7 if you wish to use hsqldb, as hsqldb 1.7.x is prone to data corruption.
  2. Add the HSQLDB JDBC driver jar to the lib/ directory.

2. JIRA 설정툴 사용하기

To start the JIRA Configuration Tool:

  1. Click the 'Database' tab.
  2. From the 'Database type' drop-down, choose 'HSQL'.

    (정보) This is a built-in database and requires no further configuration.
  3. Click 'Save' to save your settings when you are done.
  4. Restart JIRA in order for your new settings to take effect.

Congratulations — you have finished!

3. 데이터베이스 연결설정 수동으로 하기

Skip this step if you used the JIRA Configuration Tool (see above).

3-1. JIRA 서버를 HSQLDB에 연결설정하기

(warning) Skip this step if you are using JIRA Standalone distribution. JIRA Standalone includes the HSQLDB JDBC driver.

  1. Download the HSQLDB JDBC driver — hsqldb-1.8.0.5.jar for JIRA 3.7+, or hsqldb-1.7.1-patched.jar for JIRA 3.6.5 and earlier. We strongly recommend upgrading to 3.7 if you wish to use hsqldb, as hsqldb 1.7.x is prone to data corruption.
  2. Add the HSQLDB JDBC driver jar to the lib/ directory.

4. JIRA 서버를 HSQL 데이터베이스에 연결하도록 설정하기

There are two ways to configure your JIRA server to connect to your HSQL database:

(정보) 참고사항:

4.1 JIRA Configuration Tool을 사용하여 JIRA를 HSQLDB에 연결

(정보) The JIRA Configuration Tool is only available with JIRA Standalone.

To start the JIRA Configuration Tool:

To connect JIRA to HSQLDB using the JIRA Configuration Tool:

  1. Click the 'Database' tab.
  2. From the 'Database type' drop-down, choose 'HSQL'.
  3. JIRA keeps a pool of database connections open to the database server. You can set the maximum size of this pool in the 'Pool Size' text field.
  4. Click 'Save' to save your settings when you are done.
    (정보) Please Note:
    • The JIRA Configuration Tool will save your database configuration to a dbconfig.xml file in your JIRA Home Directory. This tool also adds the following elements to this file, which are normally required when running JIRA with HSQLDB:
      <min-evictable-idle-time-millis>4000</min-evictable-idle-time-millis>
      <time-between-eviction-runs-millis>5000</time-between-eviction-runs-millis>
    • JIRA must be restarted for your new settings to take effect.

Congratulations — you have finished! Proceed to 'Next Steps' below.

4.2 수동으로 JIRA를 HSQLDB에 연결

  1. Edit the dbconfig.xml file at the root of your JIRA Home Directory.
    (정보)If this file does not exist, create the file, copy and paste the example XML code below into this file and edit the pasted XML as required.

    Please Note:

    Ensure that the <database-type/> element's content specifies your type of database, as shown below. If you forget to do this and you start JIRA, your database tables may be created incorrectly. Refer to our Incorrect database type specified documentation if this happens to you.

    (warning) When editing your dbconfig.xml file, escape any '&' characters by adding 'amp;' to the end of each one.

    <?xml version="1.0" encoding="UTF-8"?>
    
    <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:/path/to/jira/C:\Program Files\Atlassian\Application Data\JIRA/database/jiradb</url>
        <driver-class>org.hsqldb.jdbcDriver</driver-class>
        <username>sa</username>
        <password></password>
        <pool-size>15<min-size>20</pool-min-size>
        <pool-max-size>20</pool-max-size>
        <pool-max-wait>30000</pool-max-wait>
        <min-evictable-idle-time-millis>4000</min-evictable-idle-time-millis>
        <time-between-eviction-runs-millis>5000</time-between-eviction-runs-millis>
        <pool-max-idle>20</pool-max-idle>
        <pool-remove-abandoned>true</pool-remove-abandoned>
        <pool-remove-abandoned-timeout>300</pool-remove-abandoned-timeout>
      </jdbc-datasource>
    </jira-database-config>
    

    (빼기) Please Note:

    • The following child elements of the <jdbc-datasource/> element are normally required when running JIRA with HSQLDB:
      <min-evictable-idle-time-millis>4000</min-evictable-idle-time-millis>
      <time-between-eviction-runs-millis>5000</time-between-eviction-runs-millis>
      (정보) For more information about the child elements of <jdbc-datasource/> beginning with pool (in the dbconfig.xml file above), see Tuning Database Connections.
  2. Save your edited dbconfig.xml file (at the root of your JIRA Home Directory).
    (정보) JIRA must be restarted for your new settings to take effect.

4.3 다음단계

You should now have an application server configured to connect to a database, and JIRA configured to use the correct database type. If you are using JIRA Standalone, start it up and watch the logs for any errors. If you are using the JIRA WAR/EAR distribution, rebuild and redeploy the webapp in your application server.

설치노트

Please see JIRA and HSQL.

  • 레이블 없음