Delete and Insert problem with JDBC Receiver

HI Experts,

I need to delete the table (all records) first then need to insert records in the Sql Database.

after ececuting the Interface table is deleted and only first record is inserted in the database. I want to insert all the records which are from the outbound payload.

I am using 2 statements 1 is for DELETE and 2nd is INSERT

MT_IB

_STATEMENTDELETE

__EMP_QUALIFICATION

___ACTION(delete)

Table

____access (didnt mapped in the mapping)

Xyz

Mno

_STATEMENTINSERT

__EMP_QUALIFICATION

___ACTION(insert)

Table

____access (Mapped)

Xyz

Mno

I didnt found and errors in the comm channel, while checking the paylod in the comm channel i see only 1 record is inserted.

key tag mandatory is disabled in the comm channel.

is there any thing wrong in my structure?

Thanks in Advance

Vankadoath