on 05-04-2010 7:10 AM
Hi everyone,
I have a question regarding my business scenario. My scenario seems simple.
RFC -> PI -> JDBC
The RFC call is synchronous. When the data comes from the RFC PI will execute a stored procedure using JDBC. The stored procedure doesn't return any value. But my RFC waits for an result code. xx or yy.
Is it possible to do this without using BPM? I am not sure how I should return a response to the RFC without using BPM.
If the RFC has to be operated in SYNC mode and if you are not receiving any details back from JDBC, then a BPM has to be used.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You will have to use a Sync-Async Bridge in your BPM:
Receive (Open S/A Bridge) --> Transformation --> Async_Send (JDBC) --> Transformation (for RFC_response) --> Send(Close S/A bridge)
Ensure that the RFC call does not time-out before the Last send of BPM is executed.
I am assuming that only after sending the data to JDBC you have to respond to the RFC!
Regards,
Abhishek.
Hi,
If you make a synchronous RFC call than JDBC adapter will send a response messages which will need to be handled in Pi.
The JDBC adapter when sending its response back will create a Message Type of the same name as the request message with a u201C_responseu201D appended to it.
Please refer to following blogs on SDN on how to configure response JDBC messages:
/people/siva.maranani/blog/2005/09/16/xi-how-to-on-jdbc-receiver-response
/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step
Regards,
Deepak.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
> The stored procedure doesn't return any value. But my RFC waits for an result code. xx or yy.
Why you do not simply change the SP to return the requested value?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Chris,
Are you saying it is alright for your bapi response to contain a constant value?
If that is that case, try using a synchronous interface as your inbound (to the JDBC) then attach constant values in the response message mapping.
Regards,
Glenn
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.