JDBC - No 'action' attribute found in XML document - error

[Former Member]

Hi,

I'm trying to write to SQL Server form File

I successfully read from file, but fail to write.

<b>My XML is :</b>

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

<ns0:SD_NEZIGA_OUT_MT xmlns:ns0="ssss.co.il:SD:Office_core_Neziga"><statement2 action="INSERT"><table>Employees</table><access><ID>000009</ID><Name>&#1497;&#1493;&#1504;&#1505;&#1497; &#1512;&#1493;&#1514;&#1497;</Name><Phone>972528288840</Phone><Manager>001037</Manager><DistManager>001037</DistManager><Password>D</Password><UserType>0</UserType><miskalID>0000</miskalID></access></statement2></ns0:SD_NEZIGA_OUT_MT>

<b>Error from JDBC adapter:</b>

TransformException error in xml processor class: Error processing request in sax parser: No 'action' attribute found in XML document (attribute "action" missing or wrong XML structure)

Help me please.

Best regards, Natalia.

[Former Member · Accepted solution]

Hey

u dont have action attribute in ur receiver Data structure,make sure u create one and hard code it with "INSERT"

make ur data type same as the one in this blog

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

also make sure ur mapping is correct

thanx

ahmad

[Former Member · Accepted solution]

Hi,

There is action attribute in XML string:

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

<ns0:SD_NEZIGA_OUT_MT xmlns:ns0="ssse.co.il:SD:Office_core_Neziga"><b><statement2 action="INSERT"></b><table>Employees</table><access><ID>000009</ID><Name>&#1497;&#1493;&#1504;&#1505;&#1497; &#1512;&#1493;&#1514;&#1497;</Name><Phone>972528288840</Phone><Manager>001037</Manager><DistManager>001037</DistManager><Password>D</Password><UserType>0</UserType><miskalID>0000</miskalID></access></statement2></ns0:SD_NEZIGA_OUT_MT>

Thanks, Natalia.

[Former Member · Accepted solution]

hey

the action attribute has to be defined on the receiver side(inbound side) ,the SD_NEZIGA_OUT_MT gives me an impression that u have defined it on the outbound side,am i right?

thanx

ahmad

[Former Member · Accepted solution]

Hi,

SD_NEZIGA_OUT_MT - it is the inbound side with name "OUT".

I'm trying to DELETE records from the table Employees and

to INSERT new records.

I success to DELETE records, but failed to INSERT.

To check INSERT statement I did DELETE enabled and now I'm cheking only INSERT statement.

Thank you, Natalia.

[Former Member · Accepted solution]

Hey

Ur XML is not correct,it must be something like this

<root>

<StatementName1>

<dbTableName action=”UPDATE” | “UPDATE_INSERT”>

<table>realDbTableName</table>.....

......

......

</StatementName1>

if u look at the receiver structure of /people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30 this blog,action is an attribute of TEST and not STATEMENTNAME,for ur structure its an attribute of Statement2

can u send ur receiver structure?

thanx

ahmad

Message was edited by:

Ahmad

[Former Member · Accepted solution]

Hi,

Thank you very very much!!!!!!

It works greate.

Best regards, Natalia.

[Former Member]

hey

this will solve ur problem

thanx

ahmad