Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

A question on error handling capability of MULE framework

 
Andres Delrotti
Ranch Hand
Posts: 178
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator


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!
 
Claude Moore
Ranch Hand
Posts: 829
7
IBM DB2 Java Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic