Skip to Content
0
Former Member
Nov 07, 2007 at 08:31 AM

JDBC Receiver - Multiple Inserts in one message type?!

14 Views

Hi, i have got an IDoc with one Header Segment and several child segments.

this i want to map to a JDBC-Message Type which looks like following:

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

<ns0:MT_ENDE_DB xmlns:ns0="owa.....">

<STATEMENTNAME>

<Test action="INSERT">

<TABLE>SAP_TO_DB1</TABLE>

<access> <i>[this field is mapped against the header segment of IDoc</i>

<ART/>

<DATA1/>

<DATA2/>

<DATA3/>

<DATA4/>

<DATA5/>

</access>

</Test>

<Test1 action="INSERT">

<TABLE>SAP_TO_DB1</TABLE>

<access><i>[this field is mapped against the child segment(s) of IDoc</i>

<ART/>

<DATA1/>

<DATA2/>

<DATA3/>

<DATA4/>

<DATA5/>

</access>

</Test1>

</STATEMENTNAME>

</ns0:MT_ENDE_DB>

Problem is that in mapping the values are transformed like it should be, like with several access segments which confirms that the rows should be filled.

But in case i have two Test segments in target MT there are no two inserts on the database!

What is the problem?!

br