cancel
Showing results for 
Search instead for 
Did you mean: 

igonoreRecordsetName in JMS possible?

Former Member
0 Kudos

Hi All,

Reopening the below thread

I am having complex header and item structure in source and using the paramater xml.conversionType = StrcutPlain2XML

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi All,

I have done detial analysis on these and below is the outcome.

the concept is

when u have multiple structures, you have to use

xml.conversionType = StrcutPlain2XML

and when JMS sender pull messages from Queue, by default RecordSet tag will be populated ( under which ur multiple structure will as subelement)

So, you have to addrecordSet in data type

when u have only one structure , u have to use

xml.conversionType = SimplePlain2XML

No need to addrecordSet in Data type and JMS will will not any Recordset structure at the root of the xml.

former_member854360
Active Contributor
0 Kudos

Hi Biplab,

It is not possible to ignore recordsetname using any standard module.

only FCC in file adapter supports this.

if can remove the recordset by using a simple XSLT mapping.Please give me your source file sample , i will give you the XSLT code.

===============================================

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

 <!--

This XSLT Mapping will delete the RecordSet node from input xml Payload  
            Author: Debashish Roy -->

   <xsl:template match="Recordset"> 
    <xsl:apply-templates select="YourNode"/>  
 </xsl:template>  
 <xsl:template match="*">   
 <xsl:copy>
<xsl:apply-templates/>
</xsl:copy>   
</xsl:template> 
</xsl:stylesheet>

=======================================

Add this XSLT mapping in Operation mapping before your actual graphical mapping.

Edited by: Debashish on Jun 29, 2011 1:36 PM