Insert JDBC operation With Duplicate record

[Former Member]

Dear All,

We have Proxy-> JDBC scenario. Here the Proxy will send some data to JDBC for INSERT action. There may be possibilty that proxy may send same Key Values for which the values are already exsist in the Oracle database. So records will not be inserted.

I want to for this message in SXMB_MONI what will be the status. Will it be Error or Sucess. Will the message will show as failed in XI.

[Former Member]

you can use JDBC look up before insert

[Former Member]

You can use JDBC look up before sending records for insert

[VijayKonam]

The above two replies are 100 percent the truth. Finally, how would you want to handle this? Do you want some error information to be sent to the users? You can make use of alerts getting triggered on Adapter Engine errors and you can forward these to the respective people.

Instead, you can write a stored procedure on the ORACLE DB and handle the unique key constraints there it self and there will be no errors on XI side.. so no need to delete any thing..!!

VJ

[Former Member]

in SXMB_MONI, the status will be success. But in RWB the message will have a failure (unique key constraint violated.. Error messge like this)..

[Former Member]

Nope, you will not see any error in MONI, some times it will give you that message is still processing. Database will throw a duplicate record error and will not process whole message. so the message will struck at adapter engine, so check the RWB for messages that were struck.

You have to manually cancel the failed messages, or else the next message will be blocked and so on...