In contrast to your first route (which consumes from the FTP endpoint) this second route of yours does *not* own a polling consumer:
http://camel.apache.org/polling-consumer.html So in this case you have to invoke your route (synchronously), through a producer template or another route, etc.. So that the JVM keeps running until this call returns at which point a row has been already inserted into your db. Babak kalber wrote > ok, i understand > > but i use camelContext with start so for sql component e.g. > > from("direct:infor.insert.ipnl_passages") > .to("sql:insert into cust_ipnl_passages > (ID,DT_CRT,FLAG_TO_DUPLICAT,FLAG_TO_REDIRECT,LINE_CODE,RUN_CODE,COM_CODE,COMPANY_CODE,DT_SCHED,DT_DEL,SII_CODE,SOLARI_CODE,HOSTNAME,LOCATION,DEV_TYPE,DEV_GROUP,TERMINUS_SII_CODE,TERMINUS_SII_CODE_DEST,TERMINUS_PROVIDER_DEST,DESTINATION,PASSAGE_COUNT,DIRECTION,DESTINATION_SOURCE,TIME_TABLE_ID,DT_START,DT_TERM,SII_CODE_START, > FLAG_IN_SERVICE, COM_CODE_NORMALIZED, DT_PROCESS) values (sys_guid(), > sysdate,#,#,#,#,#,#,to_date(#,'yyyy-mm-dd > hh24:mi-ss'),to_date(#,'yyyy-mm-dd > hh24:mi-ss'),#,#,#,#,#,#,#,#,#,#,#,#,#,#,to_date(#,'yyyy-mm-dd > hh24:mi-ss'),to_date(#,'yyyy-mm-dd > hh24:mi-ss'),#,#,#,to_date(#,'yyyy-mm-dd > hh24:mi-ss'))?dataSource=#dataSource.infor&batch=true"); > > and it works fine. > > So it depends on the component whether will executed sequentially ? -- View this message in context: http://camel.465427.n5.nabble.com/ftp-component-no-download-tp5737232p5737241.html Sent from the Camel - Users mailing list archive at Nabble.com.
