Skip to Content
0

JDBC Call in Synchronous Call

Nov 23, 2017 at 07:12 AM

42

avatar image

Hi Experts,

We are creating a scenario from REST to SOAP synchronous call. We will get request of 5 fields which we need to send to SOAP Receiver and get response. But while sending request, we will have to use JDBC Lookup and get a value from Database which we have to send to SOAP Receiver. And after receiving the response, we will have to again call JDBC Database and update the response in Database and have to get a reference ID which we will have to update response back to REST adapter .. Please let us know if the same is possible. As its a synchronous scenario, we are doubtful about the response time as well. Please suggest if there is other way to achieve the requirement.


Thanks and Regards,

Karthik

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Evgeniy Kolmakov Nov 23, 2017 at 12:02 PM
1

Hi Karthik!

And what action is performed at SOAP receiver side? Is it request operation or any data is updated by any way?

If it's just a request, your scenario could be easily transformed to synchronous operation REST - JDBC(update) with two lookups inside request mapping.

Regards, Evgeniy.

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi Evgeniy,

Thank you for the suggestion, I am executing an action at SOAP receiver end, with the response received from SOAP, I will have to update response in Database and then send back the response to REST with Reference ID generated from Database.. I was checking if there is a LOOPUP where I can execute a Stored Procedure in response mapping and found below blog, As it is synchronous scenario, please let me know if it is possible to execute an action by using UDF in mapping for SOAP or JDBC.

https://blogs.sap.com/2015/07/14/database-insert-update-and-execute-with-lookup-option/

Thanks and Regards,

Karthik

0

Hi Karthik!

Yes, it's possible to perform both JDBC and SOAP lookups using UDF. But you shouldn't use it for changing data state in target systems, only for requesting data.

Regards, Evgeniy.

1