JDBCItemReader whitn where clause

[goyinho]

Hi!!

Is it possible to configure de Jdbc itemRedader for accessing JobExecution context or stepExecution context.. Perhaps somatingh like this:

<bean id="Paso1_Reader"
		class="org.springframework.batch.item.database.JdbcCursorItemReader">
		<property name="dataSource" ref="zzzDataSource" />
		<property name="sql" value="select * FROM USUARIOS_AUDIT where USUARIO_AUDITADO='#{stepExecutionContext[userName]}'" />
		<property name="rowMapper">
			<bean class="es.bde.aps.zzz.ias.batch.basedatos.Paso1_Reader_Mapper">
				<property name="mappers">
					<util:map>
						<entry key="ID_APLICACION" value="idAplicacion" />
						<entry key="USUARIO_AUDITADO" value="usuarioAuditado" />
					</util:map>
				</property>
			</bean>
		</property>
	</bean>

I tried it but it doesn't run...

Any help??

[DHGarrette]

You need to add scope="step" in order for the late-binding to be resolved:

<bean id="Paso1_Reader"
      class="org.springframework.batch.item.database.JdbcCursorItemReader">
      scope="step">
...

[goyinho]

Thank you very much!!