File to JDBC

[Former Member]

Hi,

I had configured XI successfullly to send EMPLOYEE data from File(EMPLOYEE.XML) to JDBC. But I can send only the first row not all the rows from XML to JDBC. Is there any way to configure to send all teh rows from XML to JDBC.

regards

Anand.M

[Former Member]

Hi,

Here is the JDBC XML

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

<xsd:schema targetNamespace="http://xidemo.com/datareceiver" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://xidemo.com/datareceiver">

<xsd:element name="MT_DB_RECEIVER" type="DT_DB_VENDOR" />

<xsd:complexType name="DT_DB_VENDOR">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">d49556703e5511daa7dc00300530002e</xsd:appinfo>

</xsd:annotation>

<xsd:sequence>

<xsd:element name="STATEMENT">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">b57372e03e3211dabde4ebc60a15ca63</xsd:appinfo>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

<xsd:element name="EMPLOYEE">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">b57372e13e3211da8e06ebc60a15ca63</xsd:appinfo>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

<xsd:element name="access">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">d17518903e3211dac44febc60a15ca63</xsd:appinfo>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

<xsd:element name="EMPID" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">d17518913e3211da804debc60a15ca63</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="NAME" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">d17518923e3211daca94ebc60a15ca63</xsd:appinfo>

<xsd:documentation xml:lang="EN">E</xsd:documentation>

</xsd:annotation>

</xsd:element>

<xsd:element name="AGE" type="xsd:integer">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">d17518933e3211dab732ebc60a15ca63</xsd:appinfo>

</xsd:annotation>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:element>

</xsd:sequence>

<xsd:attribute name="action" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">b57372e23e3211da94dcebc60a15ca63</xsd:appinfo>

</xsd:annotation>

</xsd:attribute>

</xsd:complexType>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:schema>

[Former Member]

After checking this, it looks like you are not using 0:unbounded occurance for access element. After changing that go to your message map and map the source <b>row</b> field to <b>access</b> field.

YOU DID NOT POST THE TARGET XML, go to SXMB_MONI there you can find the target payload.

Check the above mentioned link.

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

regards

Shravan

[Former Member]

Hi

here is my XML

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

<ns:MT_FILE_SENDER xmlns:ns="http://xidemo.com/datasender">

<row>

<EMPID>20016</EMPID>

<NAME>PRASAD</NAME>

<AGE>39</AGE>

</row>

<row>

<EMPID>20017</EMPID>

<NAME>RAMESH</NAME>

<AGE>39</AGE>

</row>

</ns:MT_FILE_SENDER>

regards

Anand.M

[Former Member]

Could you please post the input XML for JDBC receiver ? The one you posted looks like your source.

regards

Shravan

[Former Member]

I think you did not use occurance 0:unbounded for access element.

Check the following link for correct document format.

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

regards

Shravan

[Former Member]

Hi,

I used the access element. The first row it is copying not the second one

regards

Anand.M

[Former Member]

Can you post your XML ?

regards

Shravan

[udo_martens]

Hi Ananda,

plz use one access element for every row.

Regards,

Udo