By default, JIRA runs in Tomcat, so the following example applies to Tomcat only. To learn how to define data source, refer to the application server manual.
- Ensure that you have the SQL driver in JIRA_HOME/lib directory. The driver should be proper for the type of the (external to JIRA) database in use.
Open the JIRA_HOME/conf/context.xml file in a text editor. Enter your data source there, for instance, between the existing tags <Context> </Context>:
- Restart your Jira. You should be now ready to use the data source you just defined.
Check the settings in the Resource tag:
- name: Appears in the general parameters as Database(JNDI name)
- username: Username for connecting to the database
- password: Password for connecting to the database
- driverClassName: Name of the class from the driver. The driver should be a proper jar archive for the type of the database used.
In our example the type of the database used is hsqldb
- url: The url used to connect to the database
Settings for other databases
If you want to use a column alias in a select sql and use that alias instead of a column name you should add "?useOldAliasMetadataBehavior=true" as a configuration parameter in your JDBC url. This is due to a change in My SQL JDBC driver implementation starting with version 5.1.
You can find more details here.
If you use this parameter in combination with other parameters please also see this.
MS SQL Server
For MS Sql Server 2000 the instance name should be omitted from the url even if you are connecting to a named instance. Thus, the url attribute should be: url="jdbc:jtds:sqlserver://localhost:1433/somedb".
If want to connect to Jira database, you can see its configuration in the dbconfig.xml file from Jira's home directory.
After you configure the data sources, see User Guide for details on how to use database custom fields.