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

Popular posts from this blog

c - Mpirun hangs when mpi send and recieve is put in a loop -

python - Apply coupon to a customer's subscription based on non-stripe related actions on the site -

java - Unable to get JDBC connection in Spring application to MySQL -