UPDATE_INSERT in JDBC Receiver Scenario

[Former Member]

Hi All,

In my jdbc receiver scenario I want to insert some records. I have a field which is key in my recver jdbc document format.

My target JDBC recvr document:

<?xml version="1.0" encoding="UTF-8" ?>

- <ns0:Date xmlns:ns0="http://IS00000005/100">

- <STATEMENTNAME>

- <TEST action="UPDATE_INSERT">

<TABLE>dbtable</TABLE>

- <access>

<PR1>2.0</PR1>

<PR2>1000000002</PR2>

<DATE>1007/11/08</DATE>

<PRUPDTTIME>152640</PRUPDTTIME>

</access>

- <key>

<PR2>1000000002</PR2>

</key>

</TEST>

- <TEST action="UPDATE_INSERT">

<TABLE>dbtable</TABLE>

- <PR1>3.0</PR1>

<PR2>1000000003</PR2>

<DATE>1007/11/08</DATE>

<PRUPDTTIME>152640</PRUPDTTIME>

</access>

- <key>

<PR2>1000000003</PR2>

</TEST>

PR2 field is key,so if PR2 value is there in table then it should update that record otherwise it should insert in the table.

I am getting checkered flag in MONI ,but when I check in the database it is updating only first record and second record which is new is not getting inserted.

Please Help!!!

[justin_santhanam]

Shweta,

You need to duplicate the statement node. But you duplicated the <Test action> node. Can u duplicate the Statement node and try the same.

I mean each statement node contains single Update_Insert statement.

raj.