JDBC Receiver - Multiple Inserts in one message type?!

[Former Member]

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

[prateek]

Ur JDBC structure is incorrect. U should have multiple STATEMENTNAME tags. See this

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Regards,

Prateek

[Former Member]

Well, u r right. Now it works!

I better rtfm

thx

[prateek]

Glad that it helped

Regards,

Prateek