MessageSplit from JDBC-Sender to JMS-Receiver

54 Views

Dear all,

we are getting data in a resultset from JDBC-Sender and have to process each row as a own message. When we use message-splitting we are not able to generate plainText for the receiving JMS-channel. So we thought that we first have to generate xml and afterwards in JMS-Receiver-Adapter we have to use MessageTransformBean Struct2XML, but it does not work.

Howcan we achieve this?

Here is our mapping:

<?xml version="1.0" encoding="utf-8"?>

<xsl:stylesheet version="1.0"

xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:output method="text" encoding="utf-8" />

<xsl:template match="//resultset">

<ns0:Messages xmlns:ns0=" http://sap.com/xi/XI/SplitAndMerge">>

<xsl:text disable-output-escaping="yes"><ns0:Message1></xsl:text>

<xsl:for-each select="row">

<xsl:value-of select="NODENAME" />

</xsl:for-each>

<xsl:text disable-output-escaping="yes"></ns0:Message1></xsl:text>

<xsl:text disable-output-escaping="yes"></ns0:Messages></xsl:text>

</xsl:template>

</xsl:stylesheet>