I am developing a jira plugin where I would like to query a external Oracle database (create, update, get, delete). The host jira instance will still be connected to our postgres database for all jira functionalities. I just need to query the external database for one specific functionality built in the addon. My plugin would never access both postgress and external oracle database at the same time.
Is it possible to configure another database in the dbconfig.xml or some other db files and make database queries through a JDBC connection using the oracle drivers. I plan to wrap all the external queries in a jira-plugin-rest module, so my plugin’s client side can perform ajax request using that rest api and in return it will hit the external database.
Is this possible? Any guidance is appreciated.