I have some insert statement like the follwoing...

<insert id="idInsert" parameterClass="java.util.Map">
   <isNotEmpty property="p_share">
    INSERT INTO TMLBC060 (
     USER_ID, RIGHT_CODE, SERVICE_CODE, SERVICE_SHARE
    ) VALUES (
     #p_user_id#, #p_share_right_code#, #p_share_service_code#, #p_share#
    )
   </isNotEmpty>
  </insert>

When p_share property is empty, IdInsert has no statement in it. This
statement runs in a batch.
In this condition, iBatis throws an exception.

Is there any way of preventing throwing an excetion?

Because of some complicated reasons, It's very difficult to check
p_share property in Java.
Also, I could make an dummy insert statement(like "insert into dummy
select 'x' from dual where 1=0;"), but I hope I could avoid that kind
solution.

Thanks,
KwonNam.

Reply via email to