I think hibernate takes care of this work the trigger is not required, I don't know if the code is using also pure insert statements (via jdbc) but if the code is using hibernate to persist entities the trigger is not required.
Steve Swinsburg July 19, 2016 at 4:03 AM
Unless the ID is manually set in code(?), the trigger is required for the auto increment.
I've found a typo error in Oracle script, the sequence here:
https://github.com/sakaiproject/sakai/blob/master/reference/docs/conversion/sakai_11_oracle_conversion.sql#L813
must match with the name here:
https://github.com/sakaiproject/sakai/blob/master/kernel/api/src/main/java/org/sakaiproject/config/api/HibernateConfigItem.hbm.xml#L33
Also the name here should be changed too:
https://github.com/sakaiproject/sakai/blob/master/kernel/kernel-impl/src/main/sql/oracle/sakai_config_item.sql#L30-L38
And the trigger is not needed.