file to db scenario not getting out put

[Former Member]

In file to db scenario not getting output(mysql db). giving error for receiver dat there is no action attribute in xml docment..

what could be da reason??

[prabhu_s2]

u can check with this blog:

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

[prabhu_s2]

The XML document must have the following schema in this case:

<root>
  <StatementName1>
<dbTableName action=”UPDATE” | “UPDATE_INSERT”>
    <table>realDbTableName</table>
<access>
<col1>val1</col1>
<col2>val2new</col2>
</access>
<key1>
<col2>val2old</col2>
<col4>val4</col4>
</key1>
<key2>
<col2>val2old2</col2>
</key2>
</dbTableName>
  </StatementName1>

[Former Member]

Shiva,

I think the error says you are missing an attribute in your receiver payload. Please add that and check.

See this weblog for your reference:

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

---Satish

[Former Member]

thanks 4 da links... and suggestions..

I rectified the error from ur links... and I see dat I'm not using attribute for action under catagory while creating datatype for receiver db..

thanks alot again its really helped me.