Currently, we have a field "org name" that users fill out when creating an issue. This field references names that are pulled from an external data source. The current solution is that we use ScriptRunner's Resources to establish a JDBC connection to the data base and make real-time queries to populate the drop down list for this particular field. This means that issues cannot be created if there is resource exhaustion or the connection fails. Instead, we want to store a reference table that we incrementally sync and store in Jira. Is the best approach to use ActiveObjects or is there a simpler solution for storing data across the entire Jira instance that we can query instead of relying on a constant connection to an external source?
