camel-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Carman <ja...@carmanconsulting.com>
Subject Re: Can I write a route that reads an arbitrary database table and stores it in a file?
Date Mon, 06 Jan 2014 16:06:20 GMT
Yeah, I don't think the SQL component will work for you, since it
requires a DataSource object up front.  Perhaps you can borrow from
it?  That would be overkill IMHO, though


On Mon, Jan 6, 2014 at 9:22 AM, Lothar Werzinger <lothar@tradescape.biz> wrote:
> I was afraid that I might have to implement that as Java code in a
> processor.
> I was hoping for some kind of dynamic route building that would allow me to
> use the jdbc or sql component.
>
> Thanks anyway
>
>
> On Fri, Jan 3, 2014 at 5:46 PM, James Carman <james@carmanconsulting.com>wrote:
>
>> It's possible, but probably not advisable. :)
>>
>> from("cxf:bean:foo").process(new Processor() {
>>                     @Override
>>                     public void process(Exchange exchange) throws
>> Exception {
>>                         // Query the database and build up the
>> JSONifiable data structure here...
>>                     }
>>                 }).marshal(new JsonDataFormat()).to("file:foo");
>>
>> On Fri, Jan 3, 2014 at 8:34 PM, Lothar Werzinger <lothar@tradescape.biz>
>> wrote:
>> > Hi,
>> >
>> > I have the requirement to write a route that listens on a web service
>> > endpoint and that is supposed to read a database table where the
>> connection
>> > information (host, port, ...) and the table name are passed in via the
>> web
>> > service call, convert the table data to JSON and write it to a file.
>> >
>> > Is such a route possible? If yes, can you please point me in the right
>> > direction?
>> >
>> > Thanks in advance!
>> > --
>> >
>> > Lothar Werzinger
>> >
>> > Principal Architect
>> >
>> > Tradescape, Inc. - Enabling Efficient Digital Marketplaces
>> >
>> > +1-650-931-6719 (direct)
>> >
>> > +1-800-697-6068 (main) Ext. 116
>> >
>> > lothar@tradescape.biz
>> >
>> > http://www.tradescape.biz
>> >
>> > --
>> >
>> >
>> > This message and any attachment (the "message") is intended solely for
>> the
>> > addressees and is confidential. If you receive this message by mistake,
>> > please delete it and notify the sender immediately. Any use not
>> > in accordance with its purpose, any out-spread or disclosure, either as a
>> > whole or partially, is prohibited except with formal approval. Internet
>> > cannot guarantee the integrity of this message, therefore Tradescape will
>> > not be liable for the message if modified.
>> >
>> > -
>>
>
>
>
> --
>
> Lothar Werzinger
>
> Principal Architect
>
> Tradescape, Inc. - Enabling Efficient Digital Marketplaces
>
> +1-650-931-6719 (direct)
>
> +1-800-697-6068 (main) Ext. 116
>
> lothar@tradescape.biz
>
> http://www.tradescape.biz
>
> --
>
>
> This message and any attachment (the "message") is intended solely for the
> addressees and is confidential. If you receive this message by mistake,
> please delete it and notify the sender immediately. Any use not
> in accordance with its purpose, any out-spread or disclosure, either as a
> whole or partially, is prohibited except with formal approval. Internet
> cannot guarantee the integrity of this message, therefore Tradescape will
> not be liable for the message if modified.
>
> -

Mime
View raw message