Connecting Jira applications to Azure SQL

These instructions will help you connect Jira Server or Jira Data Center to an Azure SQL database.

はじめる前に

1. Create an Azure SQL database

Create an Azure SQL database. See Quickstart: Create a single database in Azure.

要件

  • Collation: When creating the database, make sure to set the right collation in Additional settings, as you won't be able to change it later. Collation types supported by Jira are SQL_Latin1_General_CP437_CI_AI and Latin1_General_CI_AI.


2. Allow Jira to connect to the database

You need to add the IP address of your Jira server to the database's firewall rules to allow Jira to connect to your Azure SQL database. See Azure SQL database firewall rules.


3. Jira を構成してデータベースに接続する

There are two ways to configure your Jira server to connect to your Azure SQL database.

tip/resting Created with Sketch.

Finding connection strings

When connecting Jira to the database, you’ll need to provide connection details, such as hostname, port number, and database name. You can find them in the Azure portal by opening your deployed database and going to Connection strings.


データベース接続フィールド

The sections below describe the fields you'll need to fill out when connecting Jira to your database. 


In Setup Wizard/Configuration tool...
フィールド Description / Example
ホスト名

The name or IP address of the Azure SQL server. 

Example: sqlserver.database.windows.net

ポート

The TCP/IP port that the Azure SQL server is listening on. You can leave this blank to use the default port.

Default: 1433

データベース

The name of your Azure SQL database (into which Jira will save its data).

Example: jiradb

ユーザ名

The user that Jira uses to connect to the SQL Server server.

Example: jiradbuser@sqlserver

パスワード The user's password — used to authenticate with the Azure SQL server.
スキーマ

The name of the schema that your Azure SQL database uses. 

Default: dbo

In dbconfig.xml...
フィールド Description / Example
ホスト名

The name or IP address of the Azure SQL server. 

-

<url>jdbc:sqlserver://;serverName=sqlserver.database.windows.net;

portNumber=1433;databaseName=jiradb</url>

ポート

The TCP/IP port that the Azure SQL server is listening on. You can leave this blank to use the default port.

-

<url>jdbc:sqlserver://;serverName=sqlserver.database.windows.net;

portNumber=1433;databaseName=jiradb</url>


データベース

The name of your Azure SQL database (into which Jira will save its data).

-

<url>jdbc:sqlserver://;serverName=sqlserver.database.windows.net;

portNumber=1433;databaseName=jiradb</url>

ユーザ名

The user that Jira uses to connect to the SQL Server server.

-

<username>jiradbuser</username>

パスワード

The user's password — used to authenticate with the Azure SQL server.

-

<password>yourpassword</password>

スキーマ

The name of the schema that your Azure SQL database uses.

-

<schema-name> dbo </schema-name>

dbconfig.xml ファイルのサンプル

For more information about the child elements of <jdbc-datasource/> beginning with pool in the dbconfig.xml file above, see Tuning database connections.

<jira-database-config>
  <name>defaultDS</name>
  <delegator-name>default</delegator-name>
  <database-type>mssql</database-type>
  <schema-name>dbo</schema-name>
  <jdbc-datasource>
    <url>jdbc:sqlserver://;serverName=sqlserver.database.windows.net;portNumber=1433;databaseName=jiradb</url>
    <driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
    <username>adminsql@sqlserver</username>
    <password>T3ddybear</password>
    <pool-min-size>20</pool-min-size>
    <pool-max-size>20</pool-max-size>
    <pool-max-wait>30000</pool-max-wait>
    <validation-query>select 1</validation-query>
    <min-evictable-idle-time-millis>60000</min-evictable-idle-time-millis>
    <time-between-eviction-runs-millis>300000</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>
    <pool-test-on-borrow>false</pool-test-on-borrow>
    <pool-test-while-idle>true</pool-test-while-idle>
  </jdbc-datasource>
</jira-database-config>
最終更新日 2019 年 9 月 8 日

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.