JDBC adapter: action attribute is missing

[milan_10]

This is my XML, could anyone please tell me what's wrong there???

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

<root>

<zzz ACTION="INSERT">

<access>

<a>PR00035371</Ia>

<b>555555</b>

<c>2006</c>

<d>76.50</d>

</access>

</zzz>

</root>

and the error message is:

<SAP:AdditionalText>com.sap.aii.af.ra.ms.api.DeliveryException: Error processing request in sax parser: No 'action' attribute found in XML document (attribute "action" missing or wrong XML structure)</SAP:AdditionalText>

I'm sending data to oracle 10.0.1.x and using ojdbc14.jar.

Many thanks,

Milan

[udo_martens · Accepted solution]

Hi Milan,

the action attribute has to be in the 3rd element of hierarchy:

<root>
  <StatementName1>
     <dbTableName action=”INSERT”>

Regards,

Udo

[milan_10]

Many thanks guys,

you should be here when I read your mails...

Milan

[prabhu_s2]

check for the strucutre as below:

<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>