Receiver side JDBC - Problem with DELETE statement

[Former Member]

Hi,

I have a scenario where in I need to delete legacy system data every time I run the interface before inserting new rows.

I tried with stored procedure, by writing statement:

Truncate <table>.

Insert <records> into <table>.

But problem is stored procedure is called every time so when run for the second time it deletes the 1st entry before placing 2nd. This way only last record is being fetched :(.

Any suggestions?

Thanks in Advance,

Rohan.

[Former Member]

answered

[Former Member]

hi rohan,

check the below blog , i think it solves your issue

JDBC Adapter execution mode Chained or Unchained

reward points if helpfull

regards

kummari