Hi Vadim!
Maybe you already started your work, but you can take a look at sql
component that is similar to jdbc, but the main difference is that it
allows you to use sql in your endpoint name.
Roman
2008/7/24 Vadim Chekan <[EMAIL PROTECTED]>:
> Hi all,
>
> I think it is worthwhile to implement MS Sql Servers's Service Broker
> endpoint in Camel. The endpoint can be achieved using Timer and Jdbc
> endpoints but is is hairy.
>
> As part of this work I'm going to implement a Producer endpoint for Jdbc
> component. Something like this:
> from("jdbc:mybean?sql=select Name, Description from
> table1&format=xml&multirowset=true").
> xquery("datasets/dataset/rows/row/@[EMAIL PROTECTED]'Electrician']")
>
> As you see I want to implement:
> - xml output (optional, not default)
> - support for multiple rowset. Perhaps it should be the default and not the
> parameter.
> - sql as a parameter.
>
> Any comments/objections?
>
> Vadim.
>
