Forums Register Login

A question on error handling capability of MULE framework

+Pie Number of slices to send: Send


Hello,

We are currently using the MULE framework to read a file dropped off in a certain folder and pass it to the business component to parse, process and insert its contents to the database. We all know that MULE removes the file in the folder where it listens to when it starts to process that file. The issue we are having is that at times, the database is down or there is a problem in the network. So if there is a problem in the network, the file that was
read in the folder would be lost forever because its contents will not be inserted in the database. It would be deleted in the drop off folder but its contents would not be saved in the database.

Is there a way to handle this in MULE?


thanks!
+Pie Number of slices to send: Send
As far as I know, Mule File Connection doesn't support transactions (only VM, JMS, JDBC transports support transactions ) but I think you may easily import the content of your input file in a DB temporary table (maybe, with a "Processed" flag column for your convenience) and then process transactionally such table, treating it as input endpoint.

By the way: may I ask you an opinion about Mule ? I'm just evaluating it and I'd love to get an opinion from somebody which has put his hands on it.
I'm doing laundry! Look how clean this tiny ad is:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 1906 times.
Similar Threads
Regarding mule esb and web application configuration
Modular Java: ESB
printing from MDB
Im a bit confused
testing an ant run application
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 29, 2024 08:33:55.