In one of my interface i am using JDBC as sender ..and the pollling intervell is abt 30secs...problem is sometimes one record is picking multiple times and in the target system it is creating problem,,
How to avoid this...any ideas..
PT Rao replied
Thanks for your responce.
I found the problem,,,after JDBC poll ..record is entering into IE and there because of some delays(DBQUEUE DB_SPLITTER_QUEUING)...it is taking time to executing mapping( from the mapping we calling a stored procedure(DB lookup) to get some data from DB at the same time we updating the status of the flag)..
Meanwhile JDBC adapter still polling and picking the same record many time( because of the delay in IE flag status is still new in DB)
this interface was working fine..
but now it is giving some probs because of the above issues.
Now i want to update the flag from adapter level..
if i use the update option is it still update the same record what ever picking or someother record according to update condition..
give me some inputs how to update the same record with JDBC sender adapter.