Configuring sync lookup scenario without receiver

[Former Member]

Hi experts,

I want to do the following scenario and I'm not sure, if this is possible:

I have a sync SOAP call to SAP PI. The request message is mapped to the response message of the sync call. Inside the message mapping, I'm executing a JDBC Lookup, which retrieves all necessary data and puts it into the response structure.

The response should be posted back to the caller. My difficulties are in configuring such a scenario, because there is no actual receiver.

Is there a way to do this in SAP PI? I can't use sync JDBC receiver channel, due to necessary JOIN statements in SELECT (I would have to use XML SQL and JOINS are not possible with that as far as I know).

Best Regards

Sven

[rajasekhar_reddy14]

Avoid lookup and use standard JDBC receiver adapter to connect data base and get response back for you request .

JDBC receiver supports sync calls so no need to worry at all.

you required two mapings(request/response).

very simple scneario SOAP-PI--JDBC(Sync).

Regards,

Raj

[baskar_gopalakrishnan2]

>I can't use sync JDBC receiver channel, due to necessary JOIN statements in SELECT (I would have to use XML SQL and JOINS are not possible with that as far as I know).

It is possible to use SELECT QUERY in the receiver channel. You can do JDBC lookup during sync message mapping.

Example:

<StatementName>

<anyName action=u201D SQL_QUERYu201D>

<access>Place your sql string here</access>

<key>

<placeholder1>value1</placeholder1>

<placeholder2>value2<placeholder2>

</key>

</anyName >

</StatementName>

refer this

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

Note: You have to create a separate JDBC reciever comm channel for your jdbc lookup. Hope you know that.