JDBC Adapter - One Connection prior to SP20

[Former Member]

From my understanding a JDBC adapter can only establish one connection prior to SP20. Given the above, does this mean that in can only process one message at a time?

Thanks in advance.

Duke

[justin_santhanam · Accepted solution]

Duke,

-The Max concurrency is not for receiver JDBC alone its applicable to File receiver also.

- Based on my readings & understandings the max concurrency is used fo connection pooling. For example if multiple interfaces are using the same comm.channel(ex.JDBC-receiver) then till SP20 <b>I think</b> only one message is processed at a time, to improve the performance they have given the option of max.concurrency(Read -New Features link below).

- Also I request you to refer William's weblog (Method 3) in the weblog

/people/william.li/blog/2007/03/30/using-jdbc-connection-pool-in-xi-message-mapping

New Features & Function enhncements

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/4042611d-04e5-2910-bd9d-f97627b1...

JDBC adapter - Max concurrency

http://help.sap.com/saphelp_nw70/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

File adapter - Max concurrency

http://help.sap.com/saphelp_nw70/helpdata/en/bc/bb79d6061007419a081e58cbeaaf28/content.htm

I hope it helps!!!

If i'm wrong kindly revert back with your thoughts.

Best regards,

raj.

[prateek]

<i>does this mean that in can only process one message at a time</i>

Yes. It would mean that if u have configured more than one channel, then if these channels r active at the same time then only one channel could perform the database operation at a time.

Regards,

Prateek

[justin_santhanam]

Prateek,

Could you please clarify me? Why u want to create same comm.channel multiple times for the same receiver destination!!!

As you said <i>It would mean that if u have configured more than one channel, then if these channels r active at the same time then only one channel could perform the database operation at a time.</i>

I think the statement must be if more than one interfaces use the same comm.channel then only one request can be process at a time, am I right?

Please correct me if i'm wrong....

Best regards,

raj.