Multiple Items to Iterate in on jbctemplate batchupdate.

[Skanda Raman]

Hello - I have requirement to execute and insert around 2000 records. Hence I choose to execute through jdbctemplate batch template.

Problem: This is to insert insurance plans for my customer. As a requirement I have many Insurances and it has many plans. So getBatchSize() returns number of insurance available and while setting the values i will get Insurance plan object and insert the data. However, with this line getInsuranceList().get(i).getInsPlan(), I get only one plan.

Please advice, If i have to put all this method in a loop to run available insurances so that i can return the size of the plans available. Is this the correct approach to loop the method.

public int[] insertInsurancePlanDetails(final InsuranceModel insurancemodel)throws InsuranceException{
		int rowcount[] = {};
		try{
			rowcount = getJdbcTemplate().batchUpdate(sqlSaveInsuranceDetail, 
					new BatchPreparedStatementSetter(){
						@Override
						public int getBatchSize() { return insurancemodel.getInsuranceList().size(); }
						@Override
						public void setValues(PreparedStatement ps, int i) throws SQLException {
							InsurancePlan insplan = (InsurancePlan)insurancemodel.getInsuranceList().get(i).getInsPlan();
							ps.setInt(1, insurancemodel.getId());
							ps.setString(2, insurancemodel.getInsurnacePlanName());
						}
			});
		}catch (DataAccessException e) {
			throw new Exception("Insert Plans", "Error", e.getLocalizedMessage());
		}
		return rowcount;
	}

[Skanda Raman]

Adding below information would give some additional information to help.

InsurancePlan insplan = (InsurancePlan)insurancemodel.getInsuranceList().get(i).getInsPlanList().get(0);

Here getInsPlanList size is 10 and however getInsuranceList().size() is 2, I want to iterate and insert the record details of getInsPlanList.size().

So in this case do I need to loop this logic to getInsuranceList().size() so that my getBatchSize() can return of getInsPlanList.size().

public int getBatchSize() { return getInsPlanList.size()}

[Bill Gorder]

A batch operation by definition is executing the same SQL statement many times with different parameters. This does not sound like it's the case here. You could do it possibly in 2 batches, but you are only talking about 10 rows I would not even bother with batches.