JDBC Synchronous ?

[Former Member]

Hi

Is it possible to use JDBC adapter synchronous mode ? If so, how do we use it ?

[former_member200962]

If you want to use JDBC sender in Synchronous mode then you have to follow either of the below two approaches:

1) Make use of RequestResponseBean as shown in this wiki

[https://wiki.sdn.sap.com/wiki/display/XI/File-RFC-File(WithoutBPM) |https://wiki.sdn.sap.com/wiki/display/XI/File-RFC-File(WithoutBPM)]

2) Make use of BPM

If you want to use JDBC receiver in Synchronous mode then you can directly make a sync call....no need of any Bean/ BPM in this case......

Regards,

Abhishek.

[prateek]

JDBC receiver can be used for sync scenarios.e.g. It may return the number of rows updated.

JDBC sender don't support sync behavior unless BPM or adapter modules are used.

Regards,

Prateek

[Former Member]

Hi

Nope u cannot use JDBC Adapter in Syn mode.

U have to Use Sender / receiver JDBC Adapter for Syn communication along with Simple BPM Design

u can also use a Bean method elimating BPM , but u need Seperate JDBC Channel for two way communications.

Kindly search in SDN for sample scenarios in blogs

rgds

srini