This page last changed on Nov 14, 2006 by rosie@atlassian.com.
Update Note
THIS PAGE IS NOT APPLICABLE FOR JIRA 3.7 and up.

JIRA on FireBird

In order to run JIRA with the Firebird DB, the entitymodel.xml needs to be modified to adhere to the following Firebird constraints:

  1. TYPE, POSITION and PARAMETER are reserved keywords in Firebird
  2. Firebird index keys can not be greater than 250 in size

The attached entitymodel files have been modified to reflect these restrictions:

  1. JIRA 3.1.x entitymodel.xml
  2. JIRA 3.2.x entitymodel.xml
  3. JIRA 3.2.x entitymodel.xml
  4. JIRA 3.3.x entitymodel.xml
  5. JIRA 3.4.x entitymodel.xml

For other releases, here is a diff of the changes made:

Performance Note
Due to the index key restriction, the performance of JIRA is greatly reduced as various elements cannot be indexed.

Testing was conducted with Firebird 1.5.2.



Document generated by Confluence on Oct 06, 2009 00:31