Sender JDBC adapter: duplicate data sent

[Former Member]

Hi experts,

The scenerio is XI is polling the Data from source system using JDBC sender adapter. But the duplicate data is being sent to target system. I have check the chaneel configuaration and it is as follows:

Polling Intervals(secs) = 3600

and schedulling for the channel in RWB is set as: Daily at ......AM for 2 hours

as per my understanding the here the adpater is polling the data for one hour and again it starts polling for another one hour which is set in secheduling.

If I set the Availability planing as Daily at ......AM for 1 hour then problem can be resolved.

Please advise.

thanks,

Regards,

Mohan

[Former Member]

This could be resolved if you can add a field in the DB table like 'ReadFlag'.And your sql statement should have a check on this field.

You can ask someone(who can actually make changes in the Database) to add the field in the Table.

Please refer this blog for more understanding

/people/yining.mao/blog/2006/09/13/tips-and-tutorial-for-sender-jdbc-adapter

[Former Member]

Hi,

Implement a flag on DB side and Try to update the flag in update statement so that the previous wont come again.

Regards

Som

[Former Member]

Hi som,

thanks for the response.

I dont have acess to DB system.

Please suggest on my undertanding on this which I have described.

thanks,