on 09-20-2007 11:41 PM
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!!!
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.