Receiver jdbc (error - missing or incorrect action attribute )

[former_member187437]

Hi all

In jdbc-jdbc scenario, I am getting the error message, <i>No "action" attribute found in XML document </i>

and this is my payload message.

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

- <ns0:insert_statement xmlns:ns0="http://abc.com/jdbc2jdbc">

- <dbtablename action="INSERT">

<table>table2-emp</table>

- <access>

<filename>a2</filename>

<filetype>txt</filetype>

<empname>priya</empname>

<empage>23</empage>

</access>

</dbtablename>

</ns0:insert_statement>

Could someone tell me the mistake I have done?

[Former Member · Accepted solution]

Hi Aarthi

Hope thsese links can help you out.

***********Reward points if usefull***********

[Former Member · Accepted solution]

no T and N will not matter..as it is not the real tabel name..

refer this link :

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

Insert shold be in this format:

<StatementName2>

<dbTableName action=”INSERT”>

<table>realDbTableName</table>

<access>

<col1>val1</col1>

<col2>val2</col2>

</access>

<access>

<col1>val11</col1>

</access>

</dbTableName>

</StatementName2>

Thanks

Farooq.

*Rewards Points if you find it useful*

[Former Member · Accepted solution]

Try this....just change the dbTableName with the Real database table name.

<<b>table2-emp</b> action="INSERT">

<table>table2-emp</table>

Thanks

Farooq.

[former_member187437]

Hi all

Thanks for your suggestions and responses.

The problem is solved now.

It works if there are two parent nodes before the <dbtablename> tag.

[Former Member]

Hi

You have to make action field as an attribute of the receiver structure.

The problem is clear

Thanks

[Former Member]

I am not 100% sure but can you try by changing the

<dbtablename action="INSERT"> to <db<b>T</b>able<b>N</b>ame action=”INSERT”>

make "T" and "N" capital in dbtablename tag.

Cheer's