error in http-jdbc

[Former Member]

with reference to blog

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

i completed http to jdbc scenerio

but in moni i got this error

com.sap.aii.af.ra.ms.api.DeliveryException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'pra' (structure 'recordset'): java.sql.SQLException: FATAL ERROR document format: structure 'recordset', no key element found</SAP:AdditionalText>

can any body post suggestions,

thanks & regards

sandeep

[bhavesh_kantilal]

Sandeep,

What is the Select Querry you are trying? Does it have no Where CLause?

If yes, in the receiver JDBC adapter deselect option,<b> XML Schema Interpreter -->Key Tags Mandatory</b>

Regards

Bhavesh

[Former Member]

hai bhavesh, with reference to u r mesage , i uncheck the key mandatory in jdbc receiver adapter.

now i got some different error i.e

com.sap.aii.af.ra.ms.api.DeliveryException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'pra' (structure 'recordset'): java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1

my jdbc request data type is as follows.

<?xml version="1.0" encoding="ISO-8859-1"?>

<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="urn://http2db" targetNamespace="urn://http2db">

<xsd:element name="jdbc_req_mt" type="jdbc_req_dt" />

<xsd:complexType name="jdbc_req_dt">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

40e3cd4020b611dcb6da0014221c4454

</xsd:appinfo>

</xsd:annotation>

<xsd:sequence>

<xsd:element name="recordset" maxOccurs="unbounded">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

726c80600b4311dcc762fe4aac121c42

</xsd:appinfo>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

<xsd:element name="pra">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

726c80610b4311dca1c0fe4aac121c42

</xsd:appinfo>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

<xsd:element name="access">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

726c80630b4311dc8cccfe4aac121c42

</xsd:appinfo>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

<xsd:element name="lifnr" type="xsd:string" minOccurs="0">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

726c80640b4311dc9f7bfe4aac121c42

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="name1" type="xsd:string" minOccurs="0">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

726c80650b4311dcb353fe4aac121c42

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="ort01" type="xsd:string" minOccurs="0">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

726c80660b4311dcb603fe4aac121c42

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="key">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

09a635201e4011dcb3cafa21ac121c48

</xsd:appinfo>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

<xsd:element name="lifnr" type="xsd:string" minOccurs="0">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

09a635211e4011dccfa0fa21ac121c48

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:element>

</xsd:sequence>

<xsd:attribute name="action" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

83dac9b01f2f11dcc0f7ee74ac121b94

</xsd:appinfo>

</xsd:annotation>

</xsd:attribute>

</xsd:complexType>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:schema>

plz help me regarding this.

[bhavesh_kantilal]

You have provided the XSD.

Can you provide the Expected Select Query and the output XML

regards

Bhavesh

[Former Member]

Dear bhavesh ,

in action we use olny select ,

my jdbc res dt is

<?xml version="1.0" encoding="ISO-8859-1"?>

<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="urn://http2db" targetNamespace="urn://http2db">

<xsd:complexType name="jdbc_res_dt">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

84c41690253511dcaad90014221c4454

</xsd:appinfo>

</xsd:annotation>

<xsd:sequence>

<xsd:element name="recordset_response" maxOccurs="unbounded">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

a5489be01f0c11dc88eeee74ac121b94

</xsd:appinfo>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

<xsd:element name="row" minOccurs="0" maxOccurs="unbounded">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

a5489be11f0c11dc8f10ee74ac121b94

</xsd:appinfo>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

<xsd:element name="lifnr" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

a5489be21f0c11dcc0caee74ac121b94

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="ort01" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

a5489be31f0c11dca9b9ee74ac121b94

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="name1" type="xsd:string">

<xsd:annotation>

<xsd:appinfo source="http://sap.com/xi/TextID">

a5489be41f0c11dc8462ee74ac121b94

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:element>

</xsd:sequence>

</xsd:complexType>

</xsd:schema>

but now we got another error

as far as i conserned all my objects are activated.

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

- <!-- Request Message Mapping

-->

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

<SAP:Category>XIServer</SAP:Category>

<SAP:Code area="MAPPING">NO_MAPPINGPROGRAM_FOUND</SAP:Code>

<SAP:P1>Object ID B497F41941DD3C63A9AA910F27171153 Software Component 46C89420364211D6B5A6EFE50A1145A5</SAP:P1>

<SAP:P2 />

<SAP:P3 />

<SAP:P4 />

<SAP:AdditionalText />

<SAP:ApplicationFaultMessage namespace="" />

<SAP:Stack>Unable to determine name of mapping program</SAP:Stack>

<SAP:Retry>N</SAP:Retry>

</SAP:Error>

help me in this issue

regards

sandeep.

[Former Member]

Hi

I believe you can fix this issue by doing a complete sxi_cache refresh

regards

krishna

[Former Member]

hi krishnamurthy,

there is no problem with my cache.

its is showing green colour.

regards,

sandeep

[Former Member]

also

refresh you CPA cache

regards

krishna