0 Replies Latest reply on Feb 3, 2016 1:40 AM by sudhagar12

    Hi

    sudhagar12

      Please suggest on the below issue,

           Expected Scenario :     System has to fetch data from db using sql.selectOrder of sql:component and then it need to be write in file and then FTP it.

           Problem:      The route is getting triggered continuously, even after, our system fetched the value in the first call itself.

       

      sql.properties

      sql.selectOrder = select * from table_nm;

       

      we are using this in blueprint.xml

      <camelContext xmlns="http://camel.apache.org/schema/blueprint">

        <propertyPlaceholder id="placeholder" location="classpath:sql.properties" />

        <route id="myRoute">

        <from uri="sql:{{sql.selectOrder}}" />

        <bean ref="orderBean" method="processOrder" />

        <to uri="ftp://testuser@10.12.8.88?password=ftp@129"/>

        </route>

        </camelContext>