Skip to Content

JDBC-JDBC Sending 100 records at a one interval?

Hi folks,

How to send 100 records at one interval instead of sending entire data at once i want to send partially .can you please give me an idea thanks?

is additional parameter works for this req?

Regards,

Bhaskar

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Feb 07 at 10:24 AM

    Hi Bhaskar,

    I think you could write the select statement that reads up to 100 records only. How to do it? It depends on your source database. Please check your DB documentation or google "how to select up to n rows" with your DB name.

    Best Regards,

    Andrzej Filusz

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 07 at 11:53 AM

    Hi Bhaskar,

    you can write sql select statement in below format in jdbc sender channel.

    select * from tablename where rownum<=100

    Note: Get the table name from DB team.

    Regards

    Pavan

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 07 at 10:20 AM

    There are 2 ways to achieve this.

    1. Select only first 100 records that matches your query at a time and update them. You need to mention that in the SELECT statement in JDBC sender channel.

    2. Pick all records and then split them into multiple messages in mapping so that each will have 100 records.

    I would suggest the first one as selecting all of them at once might cause performance impact.

    ---Priyanka

    Add comment
    10|10000 characters needed characters exceeded