receiver JDBC structure:

[Former Member]

Hi All,

I have a requirement where i have 2 delete all the entries available in database table in DOT.NET server and the insert fresh records daily. I created the structure which has statement1 and statement2....action attribute under statement1 is mapped to 'DELETE' and action attribute under statement2 is mapped to 'INSERT'.....When the data is pushed for the first time...for example 300 records are inserted....next day from the sender side 290 records are pushed, only these 290 records are getting deleted and remaining 10 entries are left at the receiver end in the table....

Kindly suggest how to delete all the entries in the table first and insert new records....

Thanks,

Goutham

[Former Member · Accepted solution]

Check a couple of things...

1) See if ur using a Blanket delete statements with no where clauses...no conditions...

2) In the JDBC receiver CC - Adavanced mode there is an option called Database autocommit enabled...chk this box... it will ensure that the delete statement is commited before the insert statement is eecuted..that should help..

regards,

Arvind R

[Former Member · Accepted solution]

hi arvind,

issue resolved by using sql..... thanks for ur suggestions

Thanks