<?xml version="1.0" encoding="UTF-8"?>
<beans:beans xmlns="http://www.springframework.org/schema/integration/jdbc"
			 xmlns:beans="http://www.springframework.org/schema/beans"
			 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
			 xsi:schemaLocation="http://www.springframework.org/schema/beans
			https://www.springframework.org/schema/beans/spring-beans.xsd
			http://www.springframework.org/schema/integration/jdbc
			https://www.springframework.org/schema/integration/jdbc/spring-integration-jdbc.xsd">

	<beans:import resource="jdbcInboundChannelAdapterCommonConfig.xml"/>

	<beans:bean id="sqlParameterSourceFactory"
				class="org.springframework.integration.jdbc.ExpressionEvaluatingSqlParameterSourceFactory">
		<beans:property name="parameterExpressions">
			<beans:map>
				<beans:entry key="name" value="'bar'.toUpperCase()"/>
			</beans:map>
		</beans:property>
		<beans:property name="staticParameters">
			<beans:map>
				<beans:entry key="foo" value="bar"/>
			</beans:map>
		</beans:property>
	</beans:bean>

	<inbound-channel-adapter query="select * from item where status=2" channel="target"
							 update="update item set status=1, name=:name where id in (:id)"
							 jdbc-operations="jdbcTemplate"
							 update-sql-parameter-source-factory="sqlParameterSourceFactory"/>

</beans:beans>
