Skip to Content
0
Former Member
Jan 05, 2012 at 04:30 PM

JDBC Receiver: update

29 Views

Hello,

could you please let me know how to update the records (assigned Primary Key) at DB table from SAP PI

Scenario: JDBC Sender to JDBC receiver

Mapping:

sender Message Type: field1, field2, field3, field4

receiver Message Type: field1<primaryKey>, field2, field3, field4

Action: tried with UPDATE and UPDATE_INSERT

Business Logic: in DB1 we have 100 records and same records are inserted to DB2.

on next day out of 100 records, 5 records are updated in DB1. So same 5 records i need to send again to DB2.

Issue: the update query from sender channel will get the updated 5 records from DB1 and try to insert at DB2, it is failing with PK issue (java.sql.SQLException: ORA-00001: unique constraint (DATA.TABLE1_PK) violated)

Best Regards,SARAN