I've been looking around and I haven't found a way to feed parameters into the query in JdbcCursorItemReader. The idea would be to have some SQL query like:
Assuming a, b and number are fields in table myTab, I would like my step to have an ItemReader that only processes the rows in a range set by two parameters. And I would like to set those parameters at run time, not specify them in the XML description of the job.Code:SELECT a, b FROM myTab WHERE number BETWEEN ? AND ?
Is it possible to do it? If so, am I all wrong trying to use JdbcCursorItemReader? Furthermore, where (which method in with class) should I set the list of parameters?
Thanks in advance.