cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC receiver, continue processing after an error

0 Kudos
308

I have SOAP to JDBC async scenario.

One source message has multiple line items, each line item converted to separate record and inserted in database table (Using graphical mapping and INSERT command). Receiver database table has composite unique primary key constraint. Due to this, in case of any duplicate record, whole message gets error out in receiver communication channel.

Is there any way, in case of any error due to 'Primary key violation', just ignore that record and continue with next record to insert in database.

View Entire Topic
roger_alluivall
Participant
0 Kudos

Hello,

probably this issue was solved long time ago, but I guess the best solution is to use statement UPDATE_INSERT instead of INSERT.

Using this statement, all the existing records get updated and the new ones inserted.

Regards!