Multiple records update using JDBC (UPDATE_INSERT)

[Former Member]

Dear Experts,

I have configured the JDBC adapter as a receiver in PI 7.5 to execute ‘UPDATE_INSERT’ query. I am facing an issue while updating multiple records.

Below are the scenarios and results:

INSERT multiple new records - Success

UPDATE or INSERT a single record based on key - Sucess

UPDATE multiple records based on the different key values.

Please note that I also have tried a simple ‘UPDATE’ query for solely modifying the existing records which is also a failure. By reading the information in SAP Help portal, UPDATE multiple records is not possible.

https://help.sap.com/saphelp_nw70/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm?no_cache...

Can someone please check and suggest?

To be precise, JDBC will be a success in the case of Query 1 but not with Query 2.

Example, there is a DB Table with records as below.

Query 1:

UPDATE EMP Table SET Phone = 'aaaa' Where Country = 'IN'

Query 2: (both records sent together)

UPDATE EMP Table SET Phone = 'aaaa' Where Emp ID = '1111'

UPDATE EMP Table SET Phone = 'bbbb' Where Emp ID = '2222'

Thanks,

SC

[former_member190293]

Hi Somasekhar!

Wouldn't you please provide JDBC message example for your INSERT_UPDATE operations? Do you use separate statements for each of your update queries.

Regards, Evgeniy.