camel-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jtoepfer <>
Subject Re: CSV file from SQL no headers?
Date Tue, 09 Feb 2016 19:37:26 GMT

   Follow-up to what you proposed. 
Claus Ibsen-2 wrote
> You can essentially add the headers to the message body before the
> <marshal>
>  as the first row in the list, then they ought to be in the
> csv output.

  <log message="Start export buildings." loggingLevel="INFO"
  <setHeader headerName="CamelFileName"> 
  <to uri="file:{{bkd.output.folder}}"/> 
  <to uri="sql:{{bkd.bldg.sql}}"/> 
  <to uri="file:{{bkd.output.folder}}"/> 
  <log message="End export buildings." loggingLevel="INFO"

But now I'm getting an error message.

09 Feb 2016 12:58:25 [Camel (camel-bkd) thread #2 -
JmsConsumer[run-batch-route]] [org.apache.camel.processor.Pipeline] DEBUG |
Message exchange has failed: so breaking out of pipeline for exchange:
Exchange[Message: "[{BLDGID=BLDGID,BLDGNAME=BLDGNAME}]"] Exception:
org.apache.camel.component.file.GenericFileOperationFailedException: Cannot
store file: C:\Tools\apache-activemq\outgoing\building.csv?fileExist=Append
| Camel (camel-bkd) thread #2 - JmsConsumer[run-batch-route]

Any thoughts?  Thanks again for all your help.

Josh Toepfer
View this message in context:
Sent from the Camel - Users mailing list archive at

View raw message