I have couple of long running sql that I need to execute for generating response of a request. I am using SQL Binding. I need to get result from all of them, apply data massaging and send response back.
Can I run the sql parallely. Can I use a Composed Message Processor pattern to get the all the arraylist returned before further processing?
Thanks a lot in advance.
One way to do that would be to parallelize the invocations in a camel routing service and then aggregate the results. For example:
You could also split the parallel invocations out into separate routes with a seda consumer inside your routing service (you can have multiple routes per service).