sqlRouterAction_4.xml

<action name="sqlRouter" class="org.jboss.soa.esb.actions.routing.sql.SQLRouter">
    <property name="driver-class" value="com.mysql.jdbc.Driver" />
    <property name="connection-url" value="jdbc:mysql://localhost/sqlRouterDemo" />
    <property name="user-name" value="root" />
    <property name="password" value="root" />
    <property name="table-name" value="TAB_CLIENTE" />
    <property name="operation-type" value="UPDATE" />
    <property name="show-sql" value="true" />
    <property name="columns">
        <column name="ATIVO" value="true" update="true" />
        <column name="PRIMEIRO_NOME" operator="LIKE" value="'Ricardo%'" />
        <column name="CPF" operator=">" value="0" />
    </property>
</action>