CODEWITHSUNDEEP
mysqldatabasevalidationconnectionmule
danw
danw

Reputation: 1648

Mule - stop all flows from shutting down where MySQL connection in single flow fails

I have a Mule application with a number of flows all performing various operations. One of these flows connects to an external MySQL database to retrieve information. If the connection to this database fails, my Mule application fails to start and none of my other, non-erroneous, flows start.

Is there a way I can configure Mule to revert to the exception strategy of the flow connecting to the external DB in the event that the connection fails or there is some other error so that all other flows will run as normal?

Upvotes: 1

Views: 709

Answers (1)

Ryan Carter
Ryan Carter

Reputation: 11606

On your global jdbc connector, set a reconnection strategy and configure the blocking attribute to false. Example:

<jdbc:connector name="mysql">
   <reconnect-forever blocking="false" />
</jdbc:connector>

This will stop the connection exceptions from blocking your Mule app and should allow you other flows that don't rely on the connector to work as normal.

More on reconnection strategies here: http://www.mulesoft.org/documentation/display/current/Configuring+Reconnection+Strategies

Upvotes: 5

Related Questions