JDBC-JDBC Sending 100 records at a one interval?

[former_member306381]

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

[PavanKumar]

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

[Andrzej_Filusz]

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

[PriyankaAnagani]

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

[former_member306381]

yes sure it works thanks