Skip to Content

How many messsages can we insert using JDBC receiver adapter in to DB

Hi Friends,

We are having 30 JDBC receiver interfaces in my current implementation project; load of JDBC receiver interfaces was 50 k messages per day and Performing only INSERT operation on data base.

We have created individual communication channel for every JDBC receiver interface and max concurrency value set in CC was 5.

Now we are testing all interfaces in quality with all possible cases, but we found that JDBC receiver adapter unable to process 50 k messages per day, we are on PI 7.1 EHP1 SP7.

Please share your experiences with JDBC adapter receiver like per day how many messages we can transfer.

Thanks a Ton,


Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 21, 2011 at 09:17 AM

    Hi Raj,

    Please increase consumer threads for JDBC.

    Also set parameter "queueParallelism.maxReceivers". as you have increased concurrency to 5.

    You can refer SAP NOTE "SAP Note 1136790 - Blocking receiver channel may affect the whole adapter type".

    When you say you are inserting 50K records, does that mean you have 50K Messages in SAP PI?

    If single message is having multiple records, then have you tried BATCH Mode & SQL DML ??



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.