Skip to Content
author's profile photo Former Member
Former Member

JDBC adapter and message split

Hello, does anybody know how I can make a split of a document created by the JDBC adapter and that should look like

<resultset>

<row>

<column-name1>column-value</ column-name1>

<column-name2>column-value</ column-name2>

<column-name3>column-value</ column-name3>

</row>

<row>

<column-name1>column-value</ column-name1>

<column-name2>column-value</ column-name2>

<column-name3>column-value</ column-name3>

</row>

</resultset>

into several's independent documents of type:

<row>

<column-name1>column-value</ column-name1>

<column-name2>column-value</ column-name2>

<column-name3>column-value</ column-name3>

</row>

May I create the messages in the dispatcher?

Thank you

Ernesto Duran

Add comment
10|10000 characters needed characters exceeded

2 Answers

  • Posted on Jul 28, 2004 at 05:53 AM

    Hallo Ernesto,

    you can use a Business Process with a Multi-Mapping. The Business Process receives the resultset document and the Multi-Mapping splits it into several rows.

    Regards Franz

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Prasad Illapani

      Hello, isn't it possible to create an inbound abap Proxy in XI that wait for the message then this inbound proxy loops into the message and call and outbound proxy for each entry(row).

      The outbound proxy is working well for me but I'm having problems routing the message back to XI... I get the problem "SAP:Code p1="No inbound interface found for sender" But when I route the message to a business systems everything is ok.????

      Anyway what I want to do is:

      jdbc adapter --> XI --> inbound proxy --> XI --> outbound proxy --> XI --> Idoc adapter --> R3

      And the steps inbound proxy --> XI --> outbound proxy --> XI are used only to split the message.

      The reason why I try to use this approach is that I don't understand how I can split a message in java or XSLT maybe someone know???

      Thank you

      Ernesto Duran

  • author's profile photo Former Member
    Former Member
    Posted on Aug 04, 2004 at 11:10 AM

    Hi,

    I'm using XI 2.0 and try to split a message created from an JDBC inbound adapter into several files. The message from the JDBC adapter looks like:

    <resultset>

    <row>

    <column1></column1>

    <column2></column2>

    </row>

    <row>

    <column1></column1>

    <column2></column2>

    </row>

    ...

    </resultset>

    Now I want to create an extra file (written to disk by a file adapter) for each <row> tag. Up to now I didn't find a possibility to do that. Any ideas? I read about the dispatcher, but don't really know how this can be used. Can anybody tell me wheather the dispatcher would help me?

    Thanks,

    Martin.

    Add comment
    10|10000 characters needed characters exceeded