Org.springframework.dao.EmptyResultDataAccessException: неправильный размер результата: ожидаемый 1, фактический 0 ⇐ JAVA

[Anonymous]

Когда я отправляю данные на копирование, возникает следующая ошибка. Вот код.

public String deleteExistingRecordWeekWise(String monthOrWeek) throws ApplicationException {

try {

setMonthAndArea();

String[] stringValues = selectedMonthAndYear.split("-");
int year=Integer.parseInt(stringValues[0]);
int month=Integer.parseInt(stringValues[1]);

String timePrd = null;
String wk = null;

if(null==timePeriod || timePeriod.isEmpty()){
timePeriod= new ArrayList ();
timePeriod.add("2");
}
if(null==weekWise || weekWise.isEmpty()){
weekWise= new ArrayList ();
weekWise.add("1");
}
if(Integer.parseInt(timePeriod.get(0))==2){
timePrd="W";
if(null==weekWiseSelection){
if(Integer.parseInt(weekWise.get(0))==1){
wk="W1";
}else if(Integer.parseInt(weekWise.get(0))==2){
wk="W2";
}else {
wk="W3";
}
}else{
wk=weekWiseSelection;
}
}

ReportsBO.deleteProjectStatusWeekWise(wk,month,year,selectedArea);

} catch (ApplicationException ex) {
addActionError(ex.getMessage());
fetchFields();
return ERROR;
}

if(null!=weekWiseSelection || !weekWiseSelection.equalsIgnoreCase("month")){
addActionMessage("Existing records are deleted and copied data from previous month.");
}else{
addActionMessage("Existing records are deleted and copied data from previous bi weekly.");
}
return SUCCESS;


и класс DAO.

public void deleteProjectStatusWeekWise (String неделя, int месяц, int год, строковая область ) выдает ApplicationException {
int areaId=Integer.parseInt(area);

JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);

try {
int projId = jdbcTemplate.queryForInt(ProjectStatus.FETCH_PROJECT_STATUS_WEEKWISE,new Object[] {week,month,year,areaId});
jdbcTemplate.update(ProjectStatus.DELETE_PROJECT_DET_STATUS_MONTH,new Object[] {projId});
jdbcTemplate.update(ProjectStatus.DELETE_PROJECT_STATUS_WEEKWISE,new Object[] {week,month,year,areaId});
} catch (Exception e) {
LOG.error("Exception occurred in dashboard.performance.gmu.dao.ProjectStatusDAO.fetchProjectStatusTypeList(int)",e);
throw new ApplicationException("Failed to fetch project type list. Please contact System Administrator.");
}




появляется эта ошибка. Может кто-нибудь помочь решить эту проблему.
}


Подробнее здесь: https://stackoverflow.com/questions/286 ... ult-size-e