Maximum Concurrency in JDBC Receiver Adapter

[Former Member]

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

[sunilchandra007]

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

[Former Member]

> 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..