cancel
Showing results for 
Search instead for 
Did you mean: 

HI XI Aspirents,

Former Member
0 Kudos

Present My scenerio is JDBC to File in sender jdbc adpater side in the sql statement the data is picking again and again can u resolve the problem?

Regards,

MAllikarjunareddy

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi mallikarjunareddy,

Check the Update SQL statement, that is not updating the flag status of the records properly. So, the same records are picked again and again.

Thanks,

Answers (4)

Answers (4)

Former Member
0 Kudos

thanks to all

Former Member
0 Kudos

Hi Mallikarjunareddy,

Present My scenerio is JDBC to File in sender jdbc adpater side in the sql statement the data is picking again and again can u resolve the problem? Yes, you need to take a look into your SELECT query whcih is used in Sender Jdbc channel. Try to use WHERE clause in your SELECT query and used flag field.

SELECT * (or) fieldnames,f1,f2 From Table_Name where Flag = 'New' and also use UPDATE query to update the fFalg field value from 'New' to 'Processed'.

Check with your DB to use UPDATE query. So that you can avoid picking of the same data muliple times.

Use appropriate Subject line and search SDN before posting your query. You will get lot of suggestions and blogs on your query. Refer them and then post the question if your query remained unresolved.

former_member472138
Active Contributor
0 Kudos

What did you set for Quality Of Service? -- Set as Exactly Once.

Regards

Pothana

Former Member
0 Kudos

ya

regards.

mallikarjun

rajasekhar_reddy14
Active Contributor
0 Kudos

You have to wite Update stapement in JDBC sender channel to stop picking up old data, for this you should have one flag field in DB Table.

Former Member
0 Kudos

thanks for your help

regards,

mallikarjuna