Skip to Content
0
Jan 21, 2011 at 03:15 PM

JDBC receiver, continue processing after an error

228 Views

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.