spring integration dynamic sql in query property

Question

How can I inject a sql to query property in int-jdbc:outbound-gateway?

Background: I receive an amqp message with a where clause to query a table and do some logic. Where clause could be anything like state in ('ca','ma) or zipcode = '01760' Is there an example on using int-jdbc:outbound-gateway passing a query that can change based on the received message?

For example: we receive amqp message: 1: {"whereClause":"State in ('ca','ma')"} 2: {"whereClause":"id = 1"}

How can I inject to query prop in int-jdbc:outbound-gateway as below?

query="SELECT id FROM account where State in ('ca','ma')" query="SELECT id FROM account where id = 1"

Artem Bilan · Accepted Answer · 2016-08-22 21:20:15Z

2

No, you can't do that with out-of-the-box Spring Integration JDBC components.

The query property is final and can't be changed at runtime.

Consider to use <service-activator> with JdbcTemplate.query() direct usage.

answered Aug 22, 2016 at 21:20

Artem Bilan

123k11 gold badges103 silver badges130 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

spring integration dynamic sql in query property

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related