SQL component - comparing consumer against database

2017-07-07 Thread onders
Hello, I want to ask you question about a design choice. (maybe there is an existing EIP / composite EIPS together out of box, which i am not already familiar ) Think of you have X number of rows in a table. (which will continuosly get new rows) And you want to consume every row in that table an

Re: SQL component - comparing consumer against database

2017-07-07 Thread Zoran Regvart
Hi Önder, do you consult any other sources of data, or is this all in the same database? If it's all in the same database I would just use SQL triggers or views (possibly materialised). Otherwise I think aggregation is probably something you need to add to your list, zoran On Fri, Jul 7, 2017 at

enrich EIP with sql component

2017-07-07 Thread onders
Hi, I have a route as below; from("seda:A?concurrentConsumers=2") .enrich("sql:select X from test_table where id = :#${body.getId}?outputClass=" + MyX.class.getName()", new AggregationStrategy() { @Override public Exchange agg

Re: SQL component - comparing consumer against database

2017-07-07 Thread Onder SEZGIN
Thanks Zoran. I will go with aggregation because i need to be at the application layer. DBA policies do not allow with triggers and views. On Fri, Jul 7, 2017 at 12:48 PM, Zoran Regvart wrote: > Hi Önder, > do you consult any other sources of data, or is this all in the same > database? If it's

Re: enrich EIP with sql component

2017-07-07 Thread onders
This route is working correctly. There is a datatype issue for date fields for sql component. but i am sure there is not an easy way to fix it. because sql component may be running for different vendor. for keeping simple i converted date datatype to string representation by using sql features. fo

Permission denied during camel routing

2017-07-07 Thread Bhavani Gowda
Below error is thrown while file transfer Can't begin processing file [/home/cmcsftp/INBOUND/outboundDialler/abc.csv] due to permission denied.Caused by Permission Denied[IO.exception] ...CreateNewFile... ...MarkerFile exception.acquireexclusivelock... Kindly help resolve this.

Re: Permission denied during camel routing

2017-07-07 Thread RavinderReddy k
can you check change mode on that file, i think you are deploying the code in linux env ? Thanks & regds Ravinder On Fri, Jul 7, 2017 at 1:55 PM, Bhavani Gowda wrote: > Below error is thrown while file transfer > > Can't begin processing file [/home/cmcsftp/INBOUND/ > outboundDialler/abc.csv]