Skip to Content
0
Former Member
May 29, 2008 at 09:51 AM

JDBC receiver multiple records UPDATE

448 Views

Hi All,

In my file to JDBC scenario :

update_insert works! BUT ONLY for the first record of the payload.

The second record is not updated!

E.g. If I post the message via JDBC:

<Statement_TABLES>

<dbTableName_action="update_insert">

_<table>MyTable</table>

-_<access>

__<CRM_GP_NR>1234567893</CRM_GP_NR>_

__<BUSINESS_UNIT>1308</BUSINESS_UNIT>_

__</access>

-_<key1>

__<CRM_GP_NR>1234567893</CRM_GP_NR>_

__</key1>

__</dbTableName>

-_<dbTableName_action="update_insert">

_<table>MyTable</table>

-_<access>

__<CRM_GP_NR>1234567894</CRM_GP_NR>_

__<BUSINESS_UNIT>1308</BUSINESS_UNIT>_

__</access>

-_<key1>

__<CRM_GP_NR>1234567894</CRM_GP_NR>_

__</key1>

__</dbTableName>

__</Statement_TABLES>

Only 1234567893 is updated, 1234567894 is not

Any ideas?

Regards,

Praveen Kumar