JDBC Adapter

[former_member340212]

Hi,

In JDBC adopter it has picked data of 100 records from a particular table before Update statement is executed if 5 more records are inserted will adopter pick those newly inserted records or not.

Regards,

Vamshidhar

[rajasekhar_reddy14 · Accepted solution]

Hi ,

When JDBC sender channel connects to data base it pull records by using Select statement then follows update statement. The time gap between Select and Update staement is milli seconds. so once select done then there is no chance of picking uo new recors in the same call.

Next run(polling only it pulls newly inserted records in data base.

Regards,

Raj

[baskar_gopalakrishnan2]

I think you are using jdbc sender to select the records from a table. JDBC sender has first select query and followed by update statement. If the sender adapter already finished the select statement and executing update statement and during that time if there are new records inserted on that table it wont pick the newly inserted records on the table. it will pick those new records only next polling.

[former_member340212]

Hi Bhaskar,

Yes, I am using sender JDBC channel

Regards,

Vamshidhar