Skip to Content
avatar image
Former Member

Maximum Concurrency in JDBC Receiver Adapter

Hi,

We are using JDBC look ups in our Synchronous Interface. (WS Adapter->PI->RFC Adapter)

The number of Parallel calls is very high for this Synch Interface.

I want to know if the following will help to speed up the Synch Interface execution.

1) Unchecking the "Disconnect after Each Message Proceesing" in JDBC receiver communication channel used for look up, so that we dont create new JDBC connections for every message.

2) Increasing the Maximum Concurrency of the JDBC receiver channel.

Are there any side effects associated with these options.

Thanks in advance.

Regards,

Sudharshan N A

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Oct 24, 2009 at 09:17 PM

    > 1) Unchecking the "Disconnect after Each Message Proceesing" in JDBC receiver communication channel used for look up, so that we dont create new JDBC connections for every message.

    >

    You should do it.

    > 2) Increasing the Maximum Concurrency of the JDBC receiver channel.

    See both replies in this thread..

    JDBC Receiver Adapter with many deadlocks

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 24, 2009 at 09:37 PM

    Hi,

    > 1) Unchecking the "Disconnect after Each Message Proceesing" in JDBC receiver communication channel used for look up, so that we dont create new JDBC connections for every message.

    Yes, it seems to be helpful in your case. It becomes a concern in case of unreliable network connection, that is broken frequently. Have a look at point - 7 Network-Level Connection Problems in sap note 831162

    > 2) Increasing the Maximum Concurrency of the JDBC receiver channel.

    While incresing maximum concurrency, the factor poolWaitingTime must be set properly. Also have a look at point - 28 Effect of setting Maximum Concurrency and poolWaitingTime in sap note 831162.

    Regards,

    Sunil Chandra

    Add comment
    10|10000 characters needed characters exceeded