Modifications to entitymodel.xml for Firebird

Added by Keith, last edited by Rosie Jameson on Nov 14, 2006  (view change)
JIRA Documentation

Index
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.

Labels:

database database Delete
firebird firebird Delete
Enter labels to add to this page:
Wait Image 
Looking for a label? Just start typing.