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>