MQSeries.net :: View topic - Looping in Mapping

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Looping in Mapping

Looping in Mapping

« View previous topic :: View next topic »

Author

Message

RaviKrG

Posted: Thu Sep 18, 2008 3:02 am Post subject: Looping in Mapping

Master

Joined: 07 Sep 2008
Posts: 240

Can somebody tell me how can I put the for loop in on the database insert node as i need to process the whole input data. The flow works well with one input data. My flow is MQINPUT NODE ----> DATABASE INSERT NODE

for example

<details>
<name>asd</name>
<address>
<city>djd</city>
<zip>767</zip>
</address>
</details>

works fine but for
<details>
<name>asd</name>
<address>
<city>djd</city>
<zip>767</zip>
</address>
</details>
<details>
<name>sdddsd</name>
<address>
<city>dddvvjd</city>
<zip>76744</zip>
</address>
</details> it takes only the first xml data.

When I put the for loop in the map then I get the error as " "FOR" has no source path expression. Provide a source path or delete the "FOR".

Can you please tell what I am missing in this as it clearl says that source is missing but I have given the source.

fjb_saper

Posted: Thu Sep 18, 2008 3:04 am Post subject:

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY

I believe it means you need to specify something like
For $source/sourcepath/details

Enjoy

_________________
MQ & Broker admin

RaviKrG

Posted: Thu Sep 18, 2008 3:23 am Post subject:

Master

Joined: 07 Sep 2008
Posts: 240

Thanks saper for your reply , I did what you have given and the error is gone now, but still the database shows only the first XML data and no other data.

CAn you tell what need to be done so that the whole of the XML data is stored in the database

I am using WMBv6.0 on windows and the flow is just MQINPUT node ---> DATAINSERT node.

Thanks in advance.

RaviKrG

Posted: Thu Sep 18, 2008 7:36 am Post subject:

Master

Joined: 07 Sep 2008
Posts: 240

Can somebody tell whats the problem here ?

I have created the flow as MQINPUT node ---> DATABASEINSERT node

I am putting xml data to the queue but only the first data is updated in the database and not all

my xml data is like

<details>
<name>qqasd</name>
<address>
<city>djd</city>
<zip>764447</zip>
</address>
</details>
<details>
<name>asdff</name>
<address>
<city>djddff</city>
<zip>76722</zip>
</address>
</details>
<details>
<name>asdcdv</name>
<address>
<city>djd</city>
<zip>767</zip>
</address>
</details>

I have put the for loop also int the mapping part then also only the first xml data is updated in the database

Thanks

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Looping in Mapping

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP