FTP to JDBC Error

[Former Member]

Hi All,

I am trying to post a xml a simple XML file to JDBC...

I have created a JDBC structure as ( my receiver is Oracle)

OUTPUT_MT

STATEMENT

EMPLOYEE --- my table name

action ( Value INSERT)

TABLE (value EMPLOYEE my table name)

access

ID

Name

Age

I have tested the mapping ad also tested the same in ID ( tools-> test configration)

When I am trying to update the table with below XML

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

<ns0:Input_MT xmlns:ns0="http://SAP/TEST/xi">

<ID>1</ID>

<Name>Dileep</Name>

<Age>10</Age>

</ns0:Input_MT>

I am getting error as

" Error: 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)"

Can any one please let me know best way to update the table

- Dileep

[Former Member · Accepted solution]

HI

Are you sending Action as a field or attribute. it should go as an attribute

<StatementName2>

<dbTableName action=u201DINSERTu201D>

<table>realDbTableName</table>

<access>

<col1>val1</col1>

<col2>val2</col2>

</access>

<access>

<col1>val11</col1>

</access>

</dbTableName>

</StatementName2>

Check all possible formats

http://help.sap.com/saphelp_nw70/helpdata/EN/2e/96fd3f2d14e869e10000000a155106/content.htm

Thanks

Gaurav

[Former Member]

Hi,

Here you have the possible formats needed to run querys.

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

Carlos

Edited by: Carlos Gonzalez on Oct 1, 2008 4:35 PM