JDBC Response not coming back

[Former Member]

Hi,

I have developed a scenario of synchronous JDBC but the response is not coming back to PI. Please let me know if anything needs to be done at PI or JDBC side to capture Response back from JDBC.

[nabendu_sen · Accepted solution]

Hi Nayan,

This is the trickiest part of the configuration and where most of us go wrong. The JDBC adapter when sending its response back will create a Message Type of the same name as the request message with a  "_response" appended to it.

So, if your Request message type is going to have the name, MT_JDBC_SELECT_JDBC_REQUEST then, the message type for the response that is to be created will have to be MT_JDBC_SELECT_JDBC_REQUEST_response .

[Former Member]

Hi Nabendu, Gabriel,

Thanks for the replies. Yes, it was due to the wrong message type naming convention.

[GabrielSagaya]

Please go through the below links as the JDBC response message must be jdbc_req_response

http://scn.sap.com/thread/974570

http://scn.sap.com/people/luis.melgar/blog/2008/05/13/synchronous-soap-to-jdbc--end-to-end-walkthrou...

[Former Member]

what u r getting error .and once you check stp by step whaever u created for synchronous scenario (responce mapping, waht is pattern in Service interface....)

and refer below link for example of Jdbc Sync scenario:

http://www.saptechnical.com/Tutorials/XI/SOAP2JDBC/Page1.htm