Chapter 10. Dealing with the JIRA Database

In this chapter, we will cover:

• Extending the JIRA database with a custom schema

• Accessing database entities from plugins

• Persisting plugin information in the JIRA database

• Using Active Objects to store data

• Accessing the JIRA configuration properties

• Getting a database connection for JDBC calls

• Migrating a custom field from one type to another

• Retrieving issue information from a database

• Retrieving custom field details from a database

• Retrieving permissions on issues from a database

• Retrieving workflow details from a database

• Updating issue status in a database

• Retrieving users and groups from a database

• Dealing with change history in a database