Inserting record in db mule esb using file endpoint

Question

I have one query regarding inserting record in database using file endpoint. I want to insert json type record in db. I create json file and all those file data i inserted into database. My query is i can insert all those data in database successfully but that is continuously inserted data and error occurred Duplicate entry '1' for key 'PRIMARY'
How can i solve this error?I don't want to insert data recursively.How can i do this only once? I used following flow

**File->Json to Object->Splitter->Database**

please help me

Nuno Nuno · Accepted Answer · 2014-12-30T09:41:25

You can use an Idempotent Message Filter (after the Splitter) to ensure that duplicate entries are discarded. If you json representation has an unique identifier, use the Idempotent Message Filter

<idempotent-message-filter idExpression="#[entry.id]">
    <simple-text-file-store directory="./idempotent"/>
 </idempotent-message-filter>

Otherwise, use the Idempotent Secure Hash Message Filter (which will filter messages based on their hash value)

<idempotent-secure-hash-filter messageDigestAlgorithm="SHA26">
    <simple-text-file-store directory="./idempotent"/>
</idempotent-secure-hash-message-filter>

Please check the following reference for more info.

Inserting record in db mule esb using file endpoint

3 Answers