Best method for a Synchronous call - Http/webservice or JDBC

[Former Member]

Hi ,

Is there a doc or a blog that compares the best way to make a Synchronous call - specifically comparing the merits of a Http ,a webservice and a JDBC(stored procedure) call?

Specifically - > are there any known issues while using a JDBC(stored procedure) call for a high frequecy interface??

regards,

Arvind R

[prateek · Accepted solution]

There is no such blog available.

JDBC adapters are widely used for interfaces involving huge loads. There is no limitations as such. However, you need to take care that your server configurations are appropriate.

Regards,

Prateek

[Former Member]

Hi Arvind,

As others mentioned you will not have a blog or an article on this. But you see some performance parameters in question 14 and 28 in sap notes: Note 831162 - FAQ: XI 3.0 / PI 7.0 / PI 7.1 JDBC Adapter.

Regards,

---Satish

[former_member206760]

it depends on the target depending on data format it expects...SOAP messages/ JDBC call or HTTP

[abhay_rajhans2]

Hi Arvind,

If you are using JDBC adapter in synchronous call then in JDBC Receiver Adapter can get how many records updated and if The transaction is successfully execute or not. On the other hand Webservice can give you more information than this.

Search on synchronous call for each adapter so you can get more clarity on this.