on 01-31-2019 9:45 AM
Dear Experts,
While i am trying to insert two records in JDBC receiver Using below XML
But for me first record only inserting.
Please help me to insert two or three records in JDBC receiver.
Regards,
Naveen
<root>
<stmt>
<dbTableName action="INSERT">
<table>table</table>
<access>
<col1>1951</col1>
<col2>Naveen</col2>
<col3>Abc</col3>
</access>
<access>
<col1>1952</col1>
<col2>Raj</col2>
<col3>xyz</col3>
</access>
</dbTableName>
</stmt>
</root>
Dear Naveen,
Why don't you use a split er and make sure that the data pushed to JDBC receiver would receive 1 XML at a time so the XML would look like
XML 1 :
<root>
<stmt>
<dbTableName action="INSERT">
<table>table</table>
<access>
<col1>1951</col1>
<col2>Naveen</col2>
<col3>Abc</col3>
</access>
</dbTableName>
</stmt>
</root>
XML 2 :
<root>
<stmt>
<dbTableName action="INSERT">
<table>table</table>
<access>
<col1>1952</col1>
<col2>Raj</col2>
<col3>xyz</col3>
</access>
</dbTableName>
</stmt>
</root>
I hope this should help you 🙂
Regards
Akash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Peter,
Thanks for Replying.
I have tried the same 1 to unbound but still i am able to insert only one record in the table:
Please help to insert many records.
Please find below payloads:
<root>
<stmt>
<dbTableName action="INSERT">
<table>table1</table>
<access>
<col1>12882</col1>
<col2>User546</col2>
<col3>ThouheedMohamed</col3>
</access>
</dbTableName>
</stmt>
<stmt>
<dbTableName action="INSERT">
<table>table1</table>
<access>
<col1>12883</col1>
<col2>User516</col2>
<col3>NaveenRaj</col3>
</access>
</dbTableName>
</stmt>
<stmt>
<dbTableName action="INSERT">
<table>table1</table>
<access>
<col1>12884</col1>
<col2>User596</col2>
<col3>Sujeet</col3>
</access>
</dbTableName>
</stmt>
</root>
Regards,
Naveen
Hi Naveen, I had a look at my settings and there is a <stmt><dbTableName action="INSERT"><table>table</table><access> for each record.
So it should work if the XML looks like:
<root>
<stmt>
<dbTableName action="INSERT">
<table>table</table>
<access>
<col1>1951</col1>
<col2>Naveen</col2>
<col3>Abc</col3>
</access>
</dbTableName>
</stmt>
<stmt>
<dbTableName action="INSERT">
<table>table</table>
<access>
<col1>1952</col1>
<col2>Test</col2>
<col3>Abc</col3>
</access>
</dbTableName>
</stmt>
</root>
Regards Peter
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
9 | |
8 | |
6 | |
6 | |
6 | |
5 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.