Spring Batch JdbcPagingItemReader not fetching all records from DB.
As in Our database we dont have primary key. so it not fetching all records. Without primary we are losing data. So we are trying to sort column with combination of 3 columns to make it primary..
// Here X, Y, Z are column name for reference.
JdbcPagingItemReader<Student> jdbcPagingItemReader=new JdbcPagingItemReader<>();
jdbcPagingItemReader.setDataSource(dataSource);
Map<String, Order> map = new HashMap<>();
map.put("x", Order.ASCENDING);
map.put("y", Order.ASCENDING);
map.put("z", Order.ASCENDING);
final SqlPagingQueryProviderFactoryBean queryProvider = new SqlPagingQueryProviderFactoryBean();
queryProvider.setDataSource(dataSource);
queryProvider.setSelectClause("SELECT * ");
queryProvider.setFromClause("FROM Student");
By that way its taking time to run that query. and inserting records as well.
Suggest if we have any alternate for same.
