MQSeries.net :: View topic - Message with Encoding after top level tag

schroederms · Posted: Tue Sep 08, 2009 10:42 am Post subject:

We are in the process of recovering messages stored as clobs from our database. We are able to do it, however not without putting a parent tag around everyting, in this case <RECOVERED>

Now we are trying to strip that tag off and get the to the <REQUEST> tag, but no matter what we try we get a parser error.

Any ideas on what the coding would look like to do that? Here is the message. All I want is the message, that actaull starts with <REQUEST>

Thanks in advance.

<RECOVERED>
<?xml version="1.0"?>
<REQUEST>
<CONTROL>
<ORIGINATOR>EAI_NFIS_PUB_SUB_NAME_ADDRESS Flow</ORIGINATOR>
<ORIGIN_DATETIME>2009-09-05 08:49:13.901052</ORIGIN_DATETIME>
<SERVICE>NFIS</SERVICE>
<FUNCTION>PUBLICATION</FUNCTION>
<DESTINATION>
<INSTANCE>PR</INSTANCE>
<CLIENT>999</CLIENT>
</DESTINATION>
<VERSION>1.0</VERSION>
<PERSISTENCE>Y</PERSISTENCE>
<REALTIME>Y</REALTIME>
<AUDIT_LOG>Y</AUDIT_LOG>
<MY_LOOP_COUNT>104</MY_LOOP_COUNT>
<NFIS>
<RELATIONSHIP_FLAG>N</RELATIONSHIP_FLAG>
</NFIS>
<ROUTER_MSGTIMES>
<GMTMSGSTART>2009-09-05 13:49:16.850970</GMTMSGSTART>
<GMTMSGCOMPLETION>2009-09-05 13:49:16.851118</GMTMSGCOMPLETION>
</ROUTER_MSGTIMES>
</CONTROL>
<APP>
<PUBSUB>
<TOPICNAME>NFIS/PARTNER/NA/ROLE_ID/5</TOPICNAME>
</PUBSUB>
<USER>
<FIS_ID>17020118</FIS_ID>
<ROLE_ID>5</ROLE_ID>
<ROLE_DESCRIPTION>Business Partner</ROLE_DESCRIPTION>
<ROLE_TYPE_ID/>
<ROLE_TYPE_NAME/>
<PARTNER_ROLE_TYPE_ID/>
<FIRST_NAME>Sam</FIRST_NAME>
<LAST_NAME>Witte</LAST_NAME>
<MIDDLE_NAME/>
<PREFERRED_NAME/>
<BUSINESS_NAME/>
<PREFIX/>
<SUFFIX/>
<WEBSITE_ADDRESS/>
<LANGUAGE_ID>1</LANGUAGE_ID>
<LANGUAGE>English</LANGUAGE>
<PARTNER_TYPE_ID>1</PARTNER_TYPE_ID>
<PARTNER_TYPE_NAME>Individual</PARTNER_TYPE_NAME>
<BEGIN_DATE>19991219 </BEGIN_DATE>
<END_DATE/>
<INACTIVATION_REASON_ID/>
<INACTIVATION_REASON_NAME/>
<ADDRESS>
<ADDRESS_TYPE>Mailing</ADDRESS_TYPE>
<IS_PRIMARY>TRUE</IS_PRIMARY>
<STREET1>51 Nw 80 Ave</STREET1>
<STREET2/>
<CITY>Great Bend</CITY>
<REGION_ABBR>KS</REGION_ABBR>
<REGION_NAME>Kansas</REGION_NAME>
<POSTALCODE>67530</POSTALCODE>
<COUNTY_NAME>Barton</COUNTY_NAME>
<FIPS_CODE>20009</FIPS_CODE>
<COUNTRY_CODE>US</COUNTRY_CODE>
<COUNTRY_NAME>United States</COUNTRY_NAME>
</ADDRESS>
<ADDRESS>
<ADDRESS_TYPE>Shipping</ADDRESS_TYPE>
<IS_PRIMARY>TRUE</IS_PRIMARY>
<STREET1>51 Nw 80 Ave</STREET1>
<STREET2/>
<CITY>Great Bend</CITY>
<REGION_ABBR>KS</REGION_ABBR>
<REGION_NAME>Kansas</REGION_NAME>
<POSTALCODE>67530</POSTALCODE>
<COUNTY_NAME>Barton</COUNTY_NAME>
<FIPS_CODE>20009</FIPS_CODE>
<COUNTRY_CODE>US</COUNTRY_CODE>
<COUNTRY_NAME>United States</COUNTRY_NAME>
</ADDRESS>
<PHONE>
<PHONE_TYPE>Work</PHONE_TYPE>
<NUMBER>(620) 792-3476</NUMBER>
<EXTENSION/>
<PHONE_NUMBER_TYPEID>2</PHONE_NUMBER_TYPEID>
</PHONE>
<PHONE>
<PHONE_TYPE>Alternate</PHONE_TYPE>
<NUMBER>(620) 792-3476</NUMBER>
<EXTENSION/>
<PHONE_NUMBER_TYPEID>5</PHONE_NUMBER_TYPEID>
</PHONE>
<RETURN_CODE>0</RETURN_CODE>
<DESCRIPTION>Complete</DESCRIPTION>
<OPERATION_CD>I</OPERATION_CD>
</USER>
</APP>
<STATUS>
<CODE>0</CODE>
<DESCRIPTION>SUCCESSFUL</DESCRIPTION>
</STATUS>
</REQUEST>
</RECOVERED>