Active Objects: What is the correct way to install ,uninstall and upgrade a plugin which uses active objects

[Mizan]

Hi All,

I have created a plugin which uses active objects , the plugin works fine with HSQL db , however when i try to install it on a jira with Oracle as database

I get exceptions

ORA-000904 invalid identifier

ORA-000955 name is already being used by existing object

When the first time i installed the plugin with oracle as a database it worked fine but when i uninstalled it and reinstalled it gave the above exceptions

What is the correct way to install , uninstall , upgrade plugins using active objects ?

Can someone please help .

Thank you .

[Samuel Le Berrigaud · Accepted solution]

There are no specific ways to install, uninstall or upgrade AO plugins. It should work as for any other plugins.

However the AO version bundled in JIRA 4.4.x is known to have issues with Oracle. Note also that AO is not officially supported for external plugin on those versions.

Those Oracle issues should be fixed in later version, bundled with JIRA 5.x. If you still encounter issues with those version please raised an issue at http://studio.atlassian.com/browse/AO with as much details as possible so that we can help you and fix those bugs.

[Mizan]

Thanx Sam .

[Miko Rust]

I have similar problem with ORA-000904 in Oracle DB. It is because alter statement has keyword COLUMN after ADD.

My AO version 0.17.2.6

It is beta so bugs like this can occur. I found no way of change this alter statement... :|

[Mizan]

I was able to deal with ORA-000904 by changing the column name of the AO entity , it was aready according to to rule but still gave an exception but changing it helped and for ORA-000955 i had to change the plugin key.