JDBC Receiver action Select

[Former Member]

Hello together

I have some Problem with a JDBC Receiver Adapter. I want make a synchrony Process form a Web service to TeraData Database. The deployed driver are working and i can get Data with JDBC Sender Adapter.

No I get the Error no action :

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

- <!-- Aufruf eines Adapters

-->

- <SAP:Error xmlns:SAP="http://sap.com/xi/XI/Message/30" xmlns:SOAP="http://schemas.xmlsoap.org/soap/envelope/" SOAP:mustUnderstand="1">

<SAP:Category>XIAdapterFramework</SAP:Category>

<SAP:Code area="MESSAGE">GENERAL</SAP:Code>

<SAP:P1 />

<SAP:P2 />

<SAP:P3 />

<SAP:P4 />

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

<SAP:ApplicationFaultMessage namespace="" />

<SAP:Stack />

<SAP:Retry>M</SAP:Retry>

</SAP:Error>

But the structure are the same as on the sap help

<M_VerlagSelect>

<verlag action="SELECT">

<table>verlag</table>

<access>

<Objekt />

<Objekt_Bezeichnung />

<Level />

</access>

<key1>

<Verlag>10000</Verlag>

<Level>O</Level>

</key1>

</pvg_usrObjekt>

</M_VerlagSelect>

<a href="http://help.sap.com/saphelp_nw2004s/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm">JDBC Adapter Receiver</a>

Can some body help me?

Best Regards Tom

[bhavesh_kantilal · Accepted solution]

Hi,

The problem is you have missed the STATEMENT tag,

<M_VerlagSelect>

<b><STATEMENT></b>

<verlag action="SELECT">

<table>verlag</table>

<access>

<Objekt />

<Objekt_Bezeichnung />

<Level />

</access>

<key1>

<Verlag>10000</Verlag>

<Level>O</Level>

</key1>

</pvg_usrObjekt>

<b></STATEMENT></b>

</M_VerlagSelect>

I am assuming here that M_VerlagSelect is the ROOT tag of the strucutre.

Also take a look at my blog,

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

Regards,

Bhavesh

[bhavesh_kantilal · Accepted solution]

Also notice something else,

you have a tag <b></pvg_usrObjekt></b>.. Am not sure what this is for? please check this.. it should be either inside KEY 1 or KEY2 and so on.

Regards,

Bhavesh

[Former Member]

Hi Thomas:

Dokumentenformate für den JDBC-Empfänger-Adapter

http://sapdoku/netweaver4sp9/helpdata/DE/2e/96fd3f2d14e869e10000000a155106/content.htm

Grüße, Mario