JIRA の HSQLDB への接続

2. Copy the HSQLDB Driver to Your Application Server (JIRA WAR Only)

Skip this step if you installed a 'Recommended' distribution of JIRA, which (unlike JIRA WAR) 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. HSQL データベースに接続するように JIRA サーバーを設定します

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

• Using the JIRA Configuration Tool (except JIRA WAR distributions) or
• 手動

注意:

• The JIRA Configuration Tool requires a Java platform to be installed and configured on your operating system. We recommend using a Java platform supported by JIRA — refer to JIRA Requirements for details.
• If you use the JIRA WAR distribution or have a console-only connection to your JIRA server, you will need to configure JIRA with HSQLDB manually.

4.1 Connecting JIRA to HSQLDB Using the JIRA Configuration Tool

The JIRA Configuration Tool is not available with JIRA WAR distributions.

• On Windows:
  Open a command prompt and run config.bat in the bin subdirectory of the JIRA Installation Directory.
• On Linux/Unix
  Open a console and execute config.sh in the bin subdirectory of the JIRA Installation Directory.

To connect JIRA to HSQLDB using the JIRA Configuration Tool:

1. Click the Database tab.
2. From the Database type drop-down, choose HSQL.
   jira-configuration-tool-hsqldb-config.png
3. 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 Connecting JIRA to HSQLDB Manually

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.

   注意:

   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.

   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:C:\Program Files\Atlassian\Application Data\JIRA/database/jiradb</url>
       <driver-class>org.hsqldb.jdbcDriver</driver-class>
       <username>sa</username>
       <password></password>
       <pool-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>
   

   注意:

   
   
   • 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.2 Next steps

You should now have JIRA configured to connect to your HSQL database.

• JIRA の『推奨』ディストリビューションを使用している場合は、起動後、エラーがないかどうかログを観察します。
• JIRA WAR ディストリビューションを使用している場合は、アプリケーションサーバーでウェブアプリケーションを再構築・再展開します。

インストールに際して

JIRA and HSQL を参照してください。