Skip to Content
avatar image
Former Member

FTP to JDBC Error

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 02, 2008 at 03:46 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 01, 2008 at 02:34 PM

    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

    Add comment
    10|10000 characters needed characters exceeded