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.
