How to do workaround for ActiveObjects Error in ORacle

[Kapil Bolli]

Hello All,

I am using JIRA 4.3.2 & active objects 0.15.4. jar & JIRA project Specific Jar 0.5.0.

This pluign is ued to create project specific customfields.

This plugin is working perfectly with HSQL DB, but when connecting to oracle , i am getting the following error:

caused by: net.java.ao.sql.ActiveObjectSqlE (error.log) xception: java.sql.SQLException: ORA-01400: cannot insert NULL into ("MIT_JIRA_DB"."AO_9661E7_SELECT_OPTION"."ID")


Please let me the workaround availabel for it.

[Samuel Le Berrigaud · Accepted solution]

It looks like the sequence + trigger to generate IDs for Oracle have not been created successfuly. You might want to check if you see anything in the logs before that error.

Also make sure that the user you access your JIRA database has sufficient privileges, in this case "create sequence" and "create trigger".