spring - JdbcPagingItemReader endless loop -
Why is it receiving an endless loop? Always return ten records and do not continue with the next one
& lt; Bean id = "pagingItemReader1" class = "org.springframework.batch.item.database.JdbcPagingItemReader" scope = "step" & gt; & Lt; Property Name = "Data Source" Reference = "Data Source 1" /> & Lt; Property Name = "Query Provider" & gt; & Lt; Bean class = "org.springframework.batch.item.database.support.SqlPagingQueryProviderFactoryBean" & gt; & Lt; Property Name = "Data Source" Reference = "Data Source 1" /> & Lt; Property Name = "Select" "Value =" Select ID, Image "/> gt; Property Name =" to "Classes" = "From Squares" /> & Lt; Property name = "whereClause" value = "where image: value 1 or like image: value2" /> & Lt; Property name = "sort key" value = "id" /> & Lt; / Bean & gt; & Lt; / Property & gt; & Lt; Property Name = "Parameter Valve" & gt; & Lt; Map & gt; & Lt; Entry key = "value1" value = "% / image /%" /> & Lt; Entry key = "value 2" value = "% / refresh /%" /> & Lt; / Map & gt; & Lt; / Property & gt; & Lt; Property Name = "Page Size" Value = "10" /> & Lt; Property name = "rowmapper" & gt; & Lt; Bean class = "test.batch.ImagesRowMapper" /> & Lt; / Property & gt; & Lt; / Bean & gt; Using MySQL 5.1
Parentses are missing.
"where" as the image: value 2) "where" as the image: value 1 or image like: value2 "
Comments
Post a Comment