JDBC to JDBC scenario

Hi All,

I have one scenario in which I have to select data from one database (say D1) & insert into another database (say D2). Based on success or failure of insertion, I have to update the status message back in Sender database (D1).

Now, when message is inserted in D2, I get back the insert count but if msg doesnt get inserted due to erros like invalid data record, i wont be getting any response, instead my receiver adapter will throw any exception.

I need to use BPM to configure this scenario but I am not getting how to capture the exceptions here or How to achieve the success or failure of receiver insertion in XI.

Any help is highly appreciated.

PS: I have mapped my source records with access of Receiver structure so if error occurs , it will be a case of All or None insertion.

Regards

Sushil