cancel
Showing results for 
Search instead for 
Did you mean: 

Multiple Selects in receiver JDBC

Former Member
0 Kudos

Hello All,

I have a scenario - Web Service (async) -> PI -> JDBC (Sync).

I have 2 different SELECT statements to run. Is it possible to do that in the message mapping? If yes, what will be the data structure format?

Also, in case it is possible to execute 2 different SELECTs, what will happen for the response? As you have noticed, I will be getting back response. I am using BPM for A-S bridge.

Any help will be highly appreciated.

Thanks,

Abhi

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Yes you can have multiple statements with in the single message.

Q: I have 2 different SELECT statements to run. Is it possible to do that in the message mapping?

A: Yes you can have multiple statements with in the single message.

Q: If yes, what will be the data structure format?

A: Please refer the structure mentioned in the link... you have to create multiple statement structures

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

for example:

<Message>

<StatementName1>

<dbTableName action=u201DSELECTu201D>

<table>realDbTableName1</table>

<access>

<col1/>

<col2/>

<col3/>

</access>

<key1>

<col2>val2old</col2>

<col4>val4</col4>

</key1>

<key2>

<col2>val2old2</col2>

</key2>

</dbTableName>

</StatementName1>

<StatementName2>

<dbTableName action=u201DSELECTu201D>

<table>realDbTableName2</table>

<access>

<col1/>

<col2/>

<col3/>

</access>

<key1>

<col2>val2old</col2>

<col4>val4</col4>

</key1>

<key2>

<col2>val2old2</col2>

</key2>

</dbTableName>

</StatementName2>

</Message>

Q:Also, in case it is possible to execute 2 different SELECTs, what will happen for the response? As you have noticed, I will be getting back response. I am using BPM for A-S bridg

A: Response will come in single message

As for the above request ...the reponse will be like the ...

<Message_response>

<StatementName1_repoonse>

<col1/>

<col2/>

<col3/>

</StatementName1_response>

<StatementName2_repoonse>

<col1/>

<col2/>

<col3/>

</StatementName2_response>

</Message_response>

Regards

Sunil.

Former Member
0 Kudos

Hello Sunil,

Thanks for your reply.

I am happy to know that this can be achieved

I am not closing this thread, will do once I run this test successfully.

Once again, thanks for your time.

--Abhi

Former Member
0 Kudos

Closing this thread. More queries, opening a new thread.

Thanks everyone.

Abhi

Answers (0)