dynamic filename endpoint

I am using Apache Camel 2.7 with ActiveMQ 5.5.1. I am trying to setup an endpoint filename with dynamic date, can someone help. I keep getting an error with the following... ftp://a...@ftp.sample.com/OUT/Test?fileName=file-${date:now:MMdd}.xml"; /> If I take off ${date:now:MMdd} the da

Re: dynamic filename endpoint

Claus, I was actually looking at the http://camel.apache.org/file2.html File2 reference of creating a filename. I thought I should be able to do the same with FTP, is that not correct? This was the File Language example given: mydata-${date:now:MMdd}.txt Thanks again for your help.

Re: dynamic filename endpoint

Claus, No not using spring property placeholders. I'll try using the and see how it goes. Thanks for your help. - Josh -- View this message in context: http://camel.465427.n5.nabble.com/dynamic-filename-endpoint-tp5715076p5715113.html Sent from the Camel - Users mailing list archive at Na

Re: dynamic filename endpoint

Claus, I just performed the test of using the uri of the and *it work*. So to clarify what I was doing and what does work. So instead of using: ftp://a...@ftp.sample.com/OUT/Test?fileName=file-${date:now:MMdd}.xml"; /> I changed it per your suggestion and it works. ftp://a...@ftp.sa

Active Mq 5.7.0 and Quartz not playing nice...

We currently have 5.5.1 and trying to upgrade to ActiveMq 5.7.0. When I move over my camel cron endpoint i get an error message saying: No component found with scheme: quartz. my endpoint i have is : quartz://ftpOutputTimer?cron=0+0+7+%3f+*+* Thanks in advance for your help. Josh Toepfer

Re: Camel and Quartz not playing nice...

I am willing to share any more configuration details, if that help fix this issue. Thanks in advance. - Josh Toepfer -- View this message in context: http://camel.465427.n5.nabble.com/Camel-and-Quartz-not-playing-nice-tp5742726p5742790.html Sent from the Camel - Users mailing list archive

CSV file from SQL no headers?

Env. ActiveMQ v5.9.1, Camel 2.13.1 I am currently generating CSV files from a custom SQL. This works fine, but they want the headers to be added to the CSV file. I've included my route below, is there currently any way of doing this? building.csv Thanks in advance fo

Re: CSV file from SQL no headers?

Claus, Thanks for the info. Regarding your question: Should the column name from the SQL result set be used or can you set the headers hardcoded? I would say you could either use the columns from the resulting SQL or have them hardcoded. I would say that if they were hardcoded only those ma

Re: CSV file from SQL no headers?

Claus, Follow-up to what you proposed. Claus Ibsen-2 wrote > You can essentially add the headers to the message body before the > > as the first row in the list, then they ought to be in the > csv output. building.csv?fileExists=Append "[{BLDGID=BLDGID,BLDGNAME=BLDG

Re: CSV file from SQL no headers?

So I found the problem. I was adding the property of "fileExist" to the header file name not the actual Producer. That seemed to clean my errors. - Josh Toepfer -- View this message in context: http://camel.465427.n5.nabble.com/CSV-file-from-SQL-no-headers-tp5777379p5777550.html Sent fro

Multicast to Aggregation not working

I'm running: Apache ActiveMQ 5.9.1 Apache Camel 2.15. I've have a timer that kicks off a stored proc, which receives a unique batch id. That batch id is then passed through a multicast to several processes. After all those processes are finished they aggregate back to file aggregation, which

Re: Multiple Datasource in sql or JDBC component

fxthomas, I'm actually doing something similar. I am using the sql component to call my sql, which uses oracle database links to get to other data in another database. I believe if you can write a sql statement in something like Squirrel SQL client, you should be able to use it in the sql com

Multicast to Aggregation not working

I'm running: Apache ActiveMQ 5.9.1 Apache Camel 2.15. I've have a timer that kicks off a stored proc, which receives a unique batch id. That batch id is then passed through a multicast to several processes. After all those processes are finished they aggregate back to file aggregation, which

Re: Having issues with Multicast to Aggregation ...

So I've tried a couple things, include adding a timeout, but that did not seem to work. Anyone have any other suggestions? - Josh Toepfer -- View this message in context: http://camel.465427.n5.nabble.com/Having-issues-with-Multicast-to-Aggregation-tp5774688p5774823.html Sent from the Ca

Re: Having issues with Multicast to Aggregation ...

So after digging into the documentation for the last 2 days. There is a parameter called routeEmptyResultSet, and it's set to false. This could be the problem, but I'm not aware to set this? Looking at the code doesn't seem really obvious. Some direction would be helpful if i'm on the right trac

Re: Having issues with Multicast to Aggregation ...

Ok. I found where to add the routeEmptyResultSet, which since i'm using injected SQL I had to append it to the sql in the properties file. select * from dual?consumer.routeEmptyResultSet=true but this does not work This fixed my problem of the zip aggregation working. I'm not sure if this

Re: Having issues with Multicast to Aggregation ...

Sorry for the long delay, I got pulled onto another problem and am just getting back to this issue. @Jakub, The problem I'm encountering is upon aggregation, the file aggregation either times out or is stuck in a wait pattern until all multiplex routes have completed. I can see in the logs whe