Synchronous JDBC scenario

[abhay_rajhans2]

Hi All,

The scenario is

SAP Portal will send data to XI using web service(SOAP Adapter) and then XI will post data in Database using JDBC adapter.

When above scenario executes it is automatically creating response (Synchronous) once it post data in Database (New message in SXI_MONITOR). I have checked message interface both inbound and outbound are asynchronous. When I ran the same scenario using file adapter instead of SAP portal it is not creating new message.

Please guide how to avoid creating new message in case of SAP Portal .

[former_member181985 · Accepted solution]

I guess the interfaces are asynchronous and you are calling the interface from portal as Synchronous using SOAP Adapter (QOS = BestEffort). Change Quality of service to ExactlyOnce.

Regards,

Praveen

[abhay_rajhans2 · Accepted solution]

Thanks Praveen,

The issue has been resolved as per your suggestion.

[deepak_shah]

Hi,

The jdbc response is generated in synchronous cases.

Make sure the webservice call that you are making is asynchronous.

In case of file adapter the call you made was asynchronous, hence no response was generated.

Check this blog for configuration for Capturing response message.

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

- Deepak

[abhay_rajhans2]

Hi Deepak,

Thanks for the reply.

Can you please guide further on below point ? And how to check it.

Make sure the webservice call that you are making is asynchronous.

[rajasekhar_reddy14]

Hi,

JDBC Receiver adapter we can use as Synchronous,that means you have to select inbound interface as Synch,then only you will response back from DB.

i think required some small chage in Devlopment,change accrdingly.

Regards,

Raj

[abhay_rajhans2]

Hi Raj,

Our requirement is that we do not want Synchronous scenario we want it as asynchronous. System is automatically creating it as synchronous as mentioned in question. Pls guide how to suppress the Synchronous scenario.

[rajasekhar_reddy14]

Hi,

Its really suprised how come the async scernario giving response respose ,,..??

as per my knowledge its not possbile.

Regards,

Raj