This page last changed on Oct 05, 2009 by alui.

Atlassian highly recommends the following databases for use with your JIRA installation. You are welcome to use other databases with your JIRA installation, however the four databases below are the ones most commonly used by our customers and we are able to provide the best support for them. You may be able to find information on other databases in the documentation for older versions of JIRA.

Please note, although HSQLDB is bundled with JIRA Standalone we do not recommend it for production use. Please see Connecting JIRA to a Database for more information.

On this page:

PostgreSQL

Documentation
Official JIRA documentation
Supplementary documentation
PostgreSQL website
Recommended Versions
Database — PostgreSQL 8.2+
JDBCPostgreSQL Driver 8.4.x (for all versions of PostgreSQL)
Notes
  • Please see the official JIRA documentation for information on which versions of PostgreSQL are supported, which JDBC drivers to use and for instructions on connecting JIRA to PostgreSQL.
  • PostgreSQL is an open source database.
  • PostgreSQL defaults to Unicode.
  • Atlassian uses PostgreSQL for its web applications and websites.

MySQL

Documentation
Official JIRA documentation
Supplementary documentation
MySQL website
Recommended Versions
Database — MySQL 5.x
JDBCConnector/J 5.1 (for all versions of MySQL)
Notes
  • Please see the official JIRA documentation for information on which versions of MySQL are supported, which JDBC drivers to use and for instructions on connecting JIRA to MySQL.
  • MySQL is an open source database.
  • Unicode problems have been noted with MySQL 4.0 and earlier. This issue is fixed in MySQL 4.1 and later, however modern SQL (subselects) is only available MySQL 5.0 and later.

Microsoft SQL Server

Documentation
Official JIRA documentation — SQL Server 2005, SQL Server 2008
Supplementary documentation — JIRA and MS SQL Server 2005, JIRA and MS SQL Server 2008
SQL Server website
Recommended Versions
Database — SQL Server 2005, SQL Server 2008
JDBCJTDS 1.2.3 (for 2005 / 2008)
Notes
  • Please see the official JIRA documentation for information on which versions of SQL Server are supported, which JDBC drivers to use and for instructions on connecting JIRA to SQL Server.
  • SQL is a commercial database developed by the Microsoft corporation.
  • Problems have been noted when using the Microsoft JDBC driver for SQL Server with JIRA. Please refer to the official JIRA documentation for further details.

Oracle

Documentation
Official JIRA documentation
Supplementary documentation
Oracle website
Recommended Versions
Database — Oracle 10G, Oracle 11G
JDBCOracle 11.2.x (for all versions of Oracle)
Notes
  • Please see the official JIRA documentation for information on which versions of Oracle are supported, which JDBC drivers to use and for instructions on connecting JIRA to Oracle.
  • Oracle is a commercial database developed by the Oracle corporation.
  • Problems have been noted when using particular versions of the Oracle server and JDBC driver with JIRA. Please refer to the official JIRA documentation for further details.

database_breakup.png (image/png)
Document generated by Confluence on Oct 06, 2009 00:26