Skip to Content
avatar image
Former Member

JDBC Synchronous ?

Hi

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jul 03, 2009 at 06:51 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 03, 2009 at 06:58 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 03, 2009 at 07:19 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded