Nov 2nd, 2011, 02:03 PM
jdbc:outbound-gateway query only
I have a use-case where a trigger message (containing id) comes through an inbound channel, and then I need to use jdbc:outbound-gateway to execute a query and pass the result to an outbound channel.
Is it possible to supply just the query property of the gateway without the update property ?
<jdbc:outbound-gateway query="select * from foo where id = : payload.id"
Nov 3rd, 2011, 12:22 AM
Good use-case and something we don't handle handle well, yet. At this point, unfortunately, you have to provide the update query. What you could do is to provide a dummy-update query. This is not ideal but it works. I have created a sample-project that illustrates this.
Please check it out at:
We are aware that this is a very valid use-case. We are still debating how to cleanly solve it (Outbound Gateway versus using an Inbound Gateway). Expect a Jira to be created sometime tomorrow. I will update this thread accordingly.
Tags for this Thread