HIbernate问题上发现的与Oracle触发器有关的响应,用于从序列中生成ID
我需要调整触发器以仅在未提供ID的情况下运行:
CREATE OR REPLACE TRIGGER A_TRGBEFORE INSERTON A REFERENCING NEW AS New OLD AS OldFOR EACH ROWWHEN (New.IDS is null) -- (1)BEGIN :new.IDS := A_SEQ.nextval;END A_TRG;/
(1)此行允许Hibernate手动调用A_SEQ.nextVal设置ID,然后绕过触发器,否则Hibernate将无用地获取nextval,因为触发器将始终重置ID,再次调用nextval



