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+ |
JDBC — PostgreSQL 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 |
JDBC — Connector/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 |
JDBC — JTDS 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 |
JDBC — Oracle 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.
|
|
|