Setting sql parameters for the reader

[springforever]

Reader is reading data from the database. In the xml file, value for the property "sql" is set for this reader. I want to include "where id=?" in the sql.

How to set the value for this "id" in the where clause during runtime?

I am using "JdbcCursorItemReader". Do you have any example of using "DrivingQueryItemReader"?

[n.lakshmanan]

Why donot you use JdbcDaoSupport which will enable you for preparedStatements.

then by using setObject(1,value)..
you can set the values...

Regards
Laks

[lucasward]

That's the approach I went for on the JdbcCursorItemReader, which you can use because a PreparedStatementSetter is exposed. However, there were too many api issues for me to get it done in time for 1.0 for the DrivingQuery readers. You will need to implement your own KeyCollectors for that. It should be a pretty similar pattern to what was done for the cursor though.

[springforever]

That's the approach I went for on the JdbcCursorItemReader, which you can use because a PreparedStatementSetter is exposed.

I am using JdbcCursorItemReader. I have a class A implementing PreparedStatementSetter. The value to be set is with the JobParameters. How do i get the value from the JobParameters in the class A?

[lucasward]

There's already a class that does that: StepExecutionPreparedStatementSetter

You just need to register it as a StepListener as well as passing it to the item reader.

[springforever]

There's already a class that does that: StepExecutionPreparedStatementSetter

You just need to register it as a StepListener as well as passing it to the item reader.

Thanks, Lucas!
One more questions.... If i need to retrieve the value from the executionContext then do i need to implement (creating a class)StepExecutionPreparedStatementSetter?

[jaenswart]

You just need to register it as a StepListener as well as passing it to the item reader.

Can you please explain how I register this as a StepListener in 2.0.0 RC1