本人对表Customerproject设置个insert 行级 触发器create or replace trigger biud_BM_Customer_project
after INSERT on BM_CUSTOMER_PROJECT
for each row
DECLARE
r_newid NUMBER;
begin
case
when INSERTING then
select S_BM_RETURNVISIT.NEXTVAL into r_newid from DUAL;
INSERT into BM_RETURNVISIT
(BM_RETURNVISIT.CUSTOMER_ID,
PROJECT_ID,
RETURN_VISIT_TIME,
ISEXIST,
VISITED_MAN,
PHONE,
POSITION,
ID)
values
(:new.CUSTOMER_ID,
:new.PROJECT_ID,
'0001-01-01',
0,
'无',
'无',
'无',
r_newid);
end case;
end;
但是,在Customer表的hibernate配置中 有这样的配置
<bag name="custProjList" table="S_BM_CUSTOMER_PROJECT"
inverse="true" cascade="save-update" lazy="false">
<key column="CUSTOMER_ID" />
<one-to-many
class="com.oarage.crm.business.entity.CustomerProject" />
</bag>
导致每次Customer 进行更新的时候 一样触发
请问 在hibernate的 配置中执行了怎样的操作导致 触发器被触发这个问题怎么解决?
after INSERT on BM_CUSTOMER_PROJECT
for each row
DECLARE
r_newid NUMBER;
begin
case
when INSERTING then
select S_BM_RETURNVISIT.NEXTVAL into r_newid from DUAL;
INSERT into BM_RETURNVISIT
(BM_RETURNVISIT.CUSTOMER_ID,
PROJECT_ID,
RETURN_VISIT_TIME,
ISEXIST,
VISITED_MAN,
PHONE,
POSITION,
ID)
values
(:new.CUSTOMER_ID,
:new.PROJECT_ID,
'0001-01-01',
0,
'无',
'无',
'无',
r_newid);
end case;
end;
但是,在Customer表的hibernate配置中 有这样的配置
<bag name="custProjList" table="S_BM_CUSTOMER_PROJECT"
inverse="true" cascade="save-update" lazy="false">
<key column="CUSTOMER_ID" />
<one-to-many
class="com.oarage.crm.business.entity.CustomerProject" />
</bag>
导致每次Customer 进行更新的时候 一样触发
请问 在hibernate的 配置中执行了怎样的操作导致 触发器被触发这个问题怎么解决?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货