Skip to Content
avatar image
Former Member

HI XI Aspirents,

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 08, 2011 at 08:23 AM

    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,

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 08, 2011 at 08:23 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 08, 2011 at 08:24 AM

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

    Regards

    Pothana

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 08, 2011 at 08:29 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 08, 2011 at 09:51 AM

    thanks to all

    Add comment
    10|10000 characters needed characters exceeded