Skip to Content
avatar image
Former Member

How many records does JDBC adapter can obtain in one polling?

Hello everybody,

I need to do an interface between legacy system and SAP ECC, the legacy systems have a DB so i use the jdbc adapter (sender) and receive the information to SAP ECC with proxy, so i need to activate the polling option from my jdbc adapter working as a sender, i read a table with lot of records, and i need to know how many records does jdbc adapter support when the polling is executed, because is necessary read all records from the table and change the status of the processed field.

Is possible to get all the records from that table in one polling interval (50,000 records aprox)?, or i need to do the polling by blocks of records until finish all records from the table?, the second option, i dont have idea how can i do it.

Regards,

Vicman

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Aug 20, 2009 at 09:54 PM

    Hi Vicman,

    The direct answer would be there is no limit. So it all depends upon your hardware, network etc. When you poll it tries to read all the records in the database, the time to reach in sxmb_moni and to process them will depend upon all the above factors.

    But for safety we always read them in chunks because the processing might be fast with this. If you try to read a million records at one shot all other interfaces behind this interface is in queue until it completes that transaction.`

    Regards,

    ---Satish

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 20, 2009 at 09:57 PM

    Hi Vicman,

    Whats the message size and whats the value you have given in EO_MSG_SIZE_LIMIT?

    You can also write a query which will pick smaller chunks of records from the DB, say 10,000-15,000.

    Hope this is helpful.

    Regards,

    Neetesh

    Add comment
    10|10000 characters needed characters exceeded