JDBC response mapping

[Former Member]

Hello,

I have two sql statements (union ) selecting data from multiple tables and I have the sql XML as follows. The response structure is also given bellow. Do I need a response for STEMENT_TWO also? How do I map the result to single target ?

Can I have a generic resultset for both of the statements so that I can map to single target?

appreciated an urgent reply.

<xsd:element name="STATEMENT_ONE">

<xsd:element name="GTSDB">

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

<xsd:element name="KEY">

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

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

<xsd:attribute name="ACTION" type="xsd:string" use="required">

<xsd:element name="STATEMENT_TWO">

<xsd:element name="GTSDB">

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

<xsd:element name="KEY">

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

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

<xsd:attribute name="ACTION" type="xsd:string" use="required">

<xsd:annotation>

Response type

xsd:element name="STATEMENT_ONE_response" maxOccurs="unbounded">

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

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

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

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

Thanks

Sindhu

[bhavesh_kantilal]

Hi,

Yes you need the Response Strucutre for both the STATEMENTs.

Please refer to my blog to understand how the response strucutre will look,

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

Regards

Bhavesh

[Former Member]

Hi Bhavesh,

Thanks for your reply. I had already seen your Weblog and accordingly created two response . Now the target is an RFC structure .The response1 and resoponse2 date should be mapped to a table parameter of RFC . I did duplicate the table structure and mapped both the response . While testing the mapping I am getting the response .

Can I duplicate the table structure of RFC being it is imported form SAP .

It created an additional node ,so whether it will transfer the data correctly to RFC .

While I am doing the actual integration ,the RFC is not being called ,though there is no error.

Regards

Sindhu

[Former Member]

Hi Sindhu,

>>>Do I need a response for STEMENT_TWO also<<<

-->

just <b>test</b> your REQUEST message. Than you will see the reponse in SXMB-MONI.

Take the payload and design your REPONSE-Datatype.

Regards Mario