Reg: JDBC<-->RFC Sync call

[Former Member]

Hi All,

I have created a scenario between JDBC and SAP, which is a synchronous communication. In SXMB_MONI and in communication channel monitoring it is successful. JDBC synchronous communication channel is able to fetch the data, However it is not able to push the data to AS400 DB2 database. Can anybody suggest regarding the same. (I want to avoid BPM)

Regards,

Venu V

[prateek]

JDBC sender as such doesn't support sync scenario. However, it supports modules. You may use RequestResponseBean as shown below with file adapter with your JDBC adpater too.

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/xi/file-rfc-file(Without%2bBPM)

Regards,

Prateek

[dharamveer_gaur2]

Hi

Are you using JDBC sender Adapter as Sync?. JDBC Sender can not be used as Sync.

[Former Member]

Hi,

What is the technical reason for not supporting the synch call?

Regards,

Venu V

[prateek]

Thats the way SAP has implemented JDBC adapter.

May be the reason could be that opening a JDBC connection and waiting for a response would increase the performance overhead highly. To avoid this JDBC connection are made async so that once the message is sent, the database connection is closed and table could be used for other transactions maintaining the integrity of data.

Regards,

Prateek

[VijayKonam]

JDBC sender simply provides dataset. It is not a function call or SP call on the sender side. That process is asynchronous. JDBC receiver channel supports syn as you can call a SP there which takes data and also returns data.

VJ