Chapter 10. Dealing with a Database

In this chapter, we will cover:

• Extending JIRA DB with custom schema

• Accessing DB entities from plugins

• Persisting plugin information in JIRA DB

• Using Active Objects to store data

• Accessing JIRA configuration properties

• Getting 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