Spring Batch Admin - Paging error

[sky33]

Runing into a problem in Spring Batch Admin when I am trying to look at a step execution. It appears be using SQL generated by the Db2PagingQueryProvider to determine a SORT_KEY. It uses the ROW_NUMBER() and OVER() functions which are not currently supported by the version of DB2 we are using. Is there any way to work around this?

[sky33]

OK, I think I am going to make an attempt at writing a Db2PagingQueryProvider that uses doesn't use the SqlWindowingPagingQueryProvider and does something similiar to the MySqlPagingQueryProvider, but uses the correct DB2 paging keywords e.g. (FETCH FIRST 10 ROWS ONLY)

[Dave Syer]

That would work. As far as I know the implementation we have works for some (most recent at the time probably) version of DB2, but isn't expected to work for all versions. If you want to contribute your reader once it is tested please send a pull request to github.