Example usage for org.springframework.jdbc UncategorizedSQLException getMessage

Introduction

In this page you can find the example usage for org.springframework.jdbc UncategorizedSQLException getMessage.

Prototype

@Override
@Nullable
public String getMessage() 

Source Link

Document

Return the detail message, including the message from the nested exception if there is one.

Usage

From source file:om.edu.squ.squportal.portlet.dps.registration.dropw.db.DropWDBImpl.java

/**
 * //from w w  w.j  a v  a2 s  . c  o  m
 * method name  : getDropWForApprovers
 * @param roleType
 * @param employee
 * @param locale
 * @param studentNo
 * @return
 * DropWDBImpl
 * return type  : List<DropWDTO>
 * 
 * purpose      : Get List of student records for courses to be dropped 
 *
 * Date          :   Apr 17, 2017 8:24:28 PM
 */
public List<DropWDTO> getDropWForApprovers(String roleType, Employee employee, Locale locale, String studentNo)
        throws NoDBRecordException {
    String SQL_DROPW_SELECT_STUDENT_RECORDS_BY_EMPLOYEE = queryDropWProps
            .getProperty(Constants.CONST_SQL_DROPW_SELECT_STUDENT_RECORDS_BY_EMPLOYEE);

    RowMapper<DropWDTO> mapper = new RowMapper<DropWDTO>() {

        @Override
        public DropWDTO mapRow(ResultSet rs, int rowNum) throws SQLException {
            DropWDTO dropWDTO = new DropWDTO();
            Advisor advisor = new Advisor();
            Student student = new Student();
            AcademicDetail academicDetail = new AcademicDetail();

            academicDetail.setId(rs.getString(Constants.CONST_COLMN_STUDENT_ID));
            academicDetail.setStudentNo(rs.getString(Constants.CONST_COLMN_STUDENT_NO));
            academicDetail.setStdStatCode(rs.getString(Constants.CONST_COLMN_STDSTATCD));
            academicDetail.setStudentName(rs.getString(Constants.CONST_COLMN_STUDENT_NAME));
            academicDetail.setCohort(rs.getInt(Constants.CONST_COLMN_COHORT));
            academicDetail.setCollege(rs.getString(Constants.CONST_COLMN_COLLEGE_NAME));
            academicDetail.setDegree(rs.getString(Constants.CONST_COLMN_DEGREE_NAME));

            advisor.setRoleStatus(rs.getString(Constants.CONST_COLMN_ROLE_ADVISOR_STATUS));

            if (rs.getString(Constants.CONST_COLMN_ROLE_IS_APPROVER).equals("Y")) {
                dropWDTO.setApprover(true);
            } else {
                dropWDTO.setApprover(false);
            }

            student.setAcademicDetail(academicDetail);
            dropWDTO.setStudent(student);
            dropWDTO.setAdvisor(advisor);

            return dropWDTO;
        }
    };

    Map<String, String> namedParameterMap = new HashMap<String, String>();
    namedParameterMap.put("paramLocale", locale.getLanguage());
    namedParameterMap.put("paramStdNo", null);
    namedParameterMap.put("paramColCode", null);
    namedParameterMap.put("paramAdvisor", null);
    namedParameterMap.put("paramSupervisor", null);
    namedParameterMap.put("paramDeptCode", null);
    namedParameterMap.put("paramRoleName", roleType);
    namedParameterMap.put("paramFormName", Constants.CONST_FORM_NAME_DPS_EXTENSION_STUDY);
    namedParameterMap.put("paramEmpNo", employee.getEmpNumber());

    namedParameterMap.put("paramAdvisorRoleName", Constants.CONST_SQL_ROLE_NAME_ADVISOR);

    namedParameterMap.put("paramFormName", Constants.CONST_FORM_NAME_DPS_DROP_W);

    switch (roleType) {
    case Constants.CONST_ROLE_NAME_ADVISOR:
        namedParameterMap.put("paramAdvisor", employee.getEmpNumber());
        break;
    case Constants.CONST_ROLE_NAME_SUPERVISOR:
        namedParameterMap.put("paramSupervisor", employee.getEmpNumber());
        break;
    case Constants.CONST_ROLE_NAME_HOD:
        namedParameterMap.put("paramDeptCode", employee.getDepartment().getDeptCode());
        break;
    case Constants.CONST_ROLE_NAME_ASST_DEAN_P:
        namedParameterMap.put("paramColCode", employee.getBranch().getBranchCode());
        break;
    case Constants.CONST_ROLE_NAME_COL_DEAN:
        namedParameterMap.put("paramColCode", employee.getBranch().getBranchCode());
        break;
    default:
        break;
    }

    if (null != studentNo) {
        namedParameterMap.put("paramStdNo", studentNo);
    }

    try {
        return nPJdbcTemplDpsDropW.query(SQL_DROPW_SELECT_STUDENT_RECORDS_BY_EMPLOYEE, namedParameterMap,
                mapper);
    } catch (UncategorizedSQLException sqlEx) {
        logger.error("Error occur to find Approver");
        throw new NoDBRecordException(sqlEx.getMessage());
    }

}

---

From source file:om.edu.squ.squportal.portlet.dps.grade.incomplete.db.IncompleteGradeDBImpl.java

@Transactional
public int setIncompleteGradeNotifyApproval(GradeIncompleteDTO gradeIncompleteDTO) {

    String SQL_INCOMPLETE_GRADE_CHANGE_UPDATE_APPROVAL_TEMP = queryIncompleteGrade
            .getProperty(Constants.CONST_SQL_INCOMPLETE_GRADE_CHANGE_UPDATE_APPROVAL_TEMP);

    Map<String, String> namedParameterMap = new HashMap<String, String>();
    namedParameterMap.put("paramStatusCode", gradeIncompleteDTO.getlAbrStatusCode());
    namedParameterMap.put("paramUserName", gradeIncompleteDTO.getUserName());
    namedParameterMap.put("paramStdNo", gradeIncompleteDTO.getStudent().getAcademicDetail().getStudentNo());
    namedParameterMap.put("paramStdStatCode",
            gradeIncompleteDTO.getStudent().getAcademicDetail().getStdStatCode());
    namedParameterMap.put("paramSectCode", gradeIncompleteDTO.getCourse().getSectCode());
    namedParameterMap.put("paramYear", String.valueOf(gradeIncompleteDTO.getCourse().getCourseYear()));
    namedParameterMap.put("paramSem", String.valueOf(gradeIncompleteDTO.getCourse().getSemester()));
    namedParameterMap.put("paramCourseLAbrCode", gradeIncompleteDTO.getCourse().getlAbrCourseNo());
    namedParameterMap.put("paramSeqNo", gradeIncompleteDTO.getRecordSequence());

    try {/*from w  w w .  ja v  a  2 s .  c o  m*/
        return nPJdbcTemplDpsIncompleteGrade.update(SQL_INCOMPLETE_GRADE_CHANGE_UPDATE_APPROVAL_TEMP,
                namedParameterMap);
    } catch (UncategorizedSQLException exDB) {
        logger.error("Error in grade update. Details : " + exDB.getMessage());
        return -1;
    }

}

---

From source file:om.edu.squ.squportal.portlet.dps.grade.incomplete.db.IncompleteGradeDBImpl.java

@Override
public List<GradeIncompleteDTO> getIncompleteNotifyHistory(String recordSequence, Locale locale)
        throws NoDBRecordException {
    String SQL_INCOMPLETE_GRADE_SELECT_HISORY = queryIncompleteGrade
            .getProperty(Constants.CONST_SQL_INCOMPLETE_GRADE_SELECT_HISORY);
    YearSemester yearSemester = null;//from   w  w w  .j a v  a 2  s. c o m

    RowMapper<GradeIncompleteDTO> rowMapper = new RowMapper<GradeIncompleteDTO>() {

        @Override
        public GradeIncompleteDTO mapRow(ResultSet rs, int rowNum) throws SQLException {
            GradeIncompleteDTO dto = new GradeIncompleteDTO();
            Course course = new Course();
            HOD hod = new HOD();
            DPSAsstDean dpsAsstDean = new DPSAsstDean();
            DpsDean dpsDean = new DpsDean();

            course.setlAbrCourseNo(rs.getString(Constants.CONST_COLMN_L_ABR_CRSNO));
            course.setSectionNo(rs.getString(Constants.CONST_COLMN_SECTION_NO));

            dto.setCourse(course);

            dto.setStatusDesc(rs.getString(Constants.CONST_COLMN_STATUS_DESC));

            hod.setRoleStatus(rs.getString(Constants.CONST_COLMN_ROLE_HOD_STATUS));
            hod.setRoleStausIkon(
                    RoleTagGlyphicon.showIkon(rs.getString(Constants.CONST_COLMN_ROLE_HOD_STATUS)));
            hod.setComments(rs.getString(Constants.CONST_COLMN_ROLE_HOD_COMMENT));

            dpsAsstDean.setRoleStatus(rs.getString(Constants.CONST_COLMN_ROLE_DPS_ASST_DEAN_STATUS));
            dpsAsstDean.setRoleStausIkon(
                    RoleTagGlyphicon.showIkon(rs.getString(Constants.CONST_COLMN_ROLE_DPS_ASST_DEAN_STATUS)));
            dpsAsstDean.setComments(rs.getString(Constants.CONST_COLMN_ROLE_DPS_ASST_DEAN_COMMENT));

            dpsDean.setRoleStatus(rs.getString(Constants.CONST_COLMN_ROLE_DPS_DEAN_STATUS));
            dpsDean.setRoleStausIkon(
                    RoleTagGlyphicon.showIkon(rs.getString(Constants.CONST_COLMN_ROLE_DPS_DEAN_STATUS)));
            dpsDean.setComments(rs.getString(Constants.CONST_COLMN_ROLE_DPS_DEAN_COMMENT));

            dto.setHod(hod);
            dto.setDpsAsstDean(dpsAsstDean);
            dto.setDpsDean(dpsDean);

            return dto;
        }
    };

    Map<String, String> namedParameterMap = new HashMap<String, String>();

    namedParameterMap.put("paramSequenceNo", recordSequence);
    namedParameterMap.put("paramLocale", locale.getLanguage());
    namedParameterMap.put("paramFormName", Constants.CONST_FORM_NAME_DPS_INCOMPLETE_GRADE_NOTIFY);
    namedParameterMap.put("paramHodRoleName", Constants.CONST_SQL_ROLE_NAME_HOD);
    namedParameterMap.put("paramADeanPRoleName", Constants.CONST_SQL_ROLE_NAME_DPS_ASSISTANT_DEAN);
    namedParameterMap.put("paramDeanPRoleName", Constants.CONST_SQL_ROLE_NAME_DPS_DEAN);

    try {
        return nPJdbcTemplDpsIncompleteGrade.query(SQL_INCOMPLETE_GRADE_SELECT_HISORY, namedParameterMap,
                rowMapper);
    } catch (UncategorizedSQLException sqlEx) {
        logger.error("Error occur for sequence No :  ", recordSequence);
        throw new NoDBRecordException(sqlEx.getMessage());
    }
}

---

From source file:om.edu.squ.squportal.portlet.dps.registration.dropw.db.DropWDBImpl.java

/**
 * /*from www  .  ja  v a  2  s.c  o  m*/
 * method name  : setDropWCourseWithdrawProc
 * @param dropWDTO
 * @return
 * DropWDBImpl
 * return type  : int
 * 
 * purpose      :
 *
 * Date          :   May 7, 2017 10:36:17 AM
 */
@Transactional
private Map setDropWCourseWithdrawProc(DropWDTO dropWDTO) throws NotSuccessFulDBUpdate {
    Map resultProc = null;

    simpleJdbcCallDpsDropW.withProcedureName(Constants.CONST_PROC_DROPW_WITHDRAW_COURSE);
    simpleJdbcCallDpsDropW.withoutProcedureColumnMetaDataAccess();
    simpleJdbcCallDpsDropW.useInParameterNames(Constants.CONST_PROC_COL_NAME_P_STDNO,
            Constants.CONST_PROC_COL_NAME_P_SECTCD, Constants.CONST_PROC_COL_NAME_P_SECTNO,
            Constants.CONST_PROC_COL_NAME_P_USER);
    simpleJdbcCallDpsDropW.declareParameters(
            new SqlParameter(Constants.CONST_PROC_COL_NAME_P_STDNO, Types.NUMERIC),
            new SqlParameter(Constants.CONST_PROC_COL_NAME_P_SECTCD, Types.NUMERIC),
            new SqlParameter(Constants.CONST_PROC_COL_NAME_P_SECTNO, Types.NUMERIC),
            new SqlParameter(Constants.CONST_PROC_COL_NAME_P_USER, Types.VARCHAR)

    );
    Map<String, Object> paramMap = new HashMap<String, Object>();
    paramMap.put(Constants.CONST_PROC_COL_NAME_P_STDNO, dropWDTO.getStudentNo());
    paramMap.put(Constants.CONST_PROC_COL_NAME_P_SECTCD, dropWDTO.getSectCode());
    paramMap.put(Constants.CONST_PROC_COL_NAME_P_SECTNO, dropWDTO.getSectionNo());
    paramMap.put(Constants.CONST_PROC_COL_NAME_P_USER, dropWDTO.getUserName());

    try {
        resultProc = simpleJdbcCallDpsDropW.execute(paramMap);
    } catch (BadSqlGrammarException badGrException) {
        logger.error("Might be a grammatical issue in stored procedure");
        throw new NotSuccessFulDBUpdate(badGrException.getMessage());
    } catch (UncategorizedSQLException exception) {
        logger.error("Course drop not successful for student no : {}, course no {} . Details : {} - {}",
                dropWDTO.getStudentNo(), dropWDTO.getCourseNo(), exception.getSQLException().getErrorCode(),
                exception.getSQLException().getMessage());
        throw new NotSuccessFulDBUpdate(exception.getMessage());

    }

    return resultProc;
}

---

From source file:om.edu.squ.squportal.portlet.dps.grade.gradechange.db.GradeChangeDBImpl.java

/**
 * //from ww  w  . j a  va  2s.co  m
 * method name  : setGradeChangeApproval
 * @param gradeDTO
 * @return
 * GradeChangeDBImpl
 * return type  : int
 * 
 * purpose      : update the status / comment for approval process
 *
 * Date          :   Dec 11, 2017 8:27:04 AM
 */
@Transactional
public int setGradeChangeApproval(GradeDTO gradeDTO) {

    String SQL_GRADE_CHANGE_UPDATE_APPROVAL_TEMP = queryGradeChange
            .getProperty(Constants.CONST_SQL_GRADE_CHANGE_UPDATE_APPROVAL_TEMP);

    Map<String, String> namedParameterMap = new HashMap<String, String>();
    namedParameterMap.put("paramStatusCode", gradeDTO.getStatusCode());
    namedParameterMap.put("paramUserName", gradeDTO.getUserName());
    namedParameterMap.put("paramStdNo", gradeDTO.getStudentNo());
    namedParameterMap.put("paramStdStatCode", gradeDTO.getStdStatCode());
    namedParameterMap.put("paramSectCode", gradeDTO.getSectCode());
    namedParameterMap.put("paramYear", gradeDTO.getCourseYear());
    namedParameterMap.put("paramSem", gradeDTO.getSemester());
    namedParameterMap.put("paramCourseLAbrCode", gradeDTO.getCourse().getlAbrCourseNo());
    namedParameterMap.put("paramSeqNo", gradeDTO.getRecordSequence());
    try {
        return nPJdbcTemplDpsGradeChange.update(SQL_GRADE_CHANGE_UPDATE_APPROVAL_TEMP, namedParameterMap);
    } catch (UncategorizedSQLException exDB) {
        logger.error("Error in grade update. Details : " + exDB.getMessage());
        return -1;
    }
}

---

From source file:om.edu.squ.squportal.portlet.dps.grade.gradechange.db.GradeChangeDBImpl.java

/**
 * /*  w ww.  jav a2s. co  m*/
 * method name  : getGradeHistory
 * @param dto
 * @param locale
 * @return
 * GradeChangeDBImpl
 * return type  : List<GradeDTO>
 * 
 * purpose      :
 *
 * Date          :   Nov 19, 2017 4:36:02 PM
 * @throws NoDBRecordException 
 */
public List<GradeDTO> getGradeHistory(boolean isRuleGradeChangeTimingFollowed, GradeDTO dto, Locale locale)
        throws NoDBRecordException {
    String SQL_GRADE_SELECT_HISORY = queryGradeChange.getProperty(Constants.CONST_SQL_GRADE_SELECT_HISORY);
    YearSemester yearSemester = null;

    RowMapper<GradeDTO> rowMapper = new RowMapper<GradeDTO>() {

        @Override
        public GradeDTO mapRow(ResultSet rs, int rowNum) throws SQLException {
            GradeDTO gradeDto = new GradeDTO();
            Course course = new Course();
            Grade grade = new Grade();
            HOD hod = new HOD();
            DPSAsstDean dpsAsstDean = new DPSAsstDean();
            DpsDean dpsDean = new DpsDean();

            course.setlAbrCourseNo(rs.getString(Constants.CONST_COLMN_L_ABR_CRSNO));

            grade.setGradeValOld(rs.getString(Constants.CONST_COLMN_GRADE_VAL_OLD));
            grade.setGradeValNew(rs.getString(Constants.CONST_COLMN_GRADE_VAL_NEW));

            gradeDto.setSectionNo(rs.getString(Constants.CONST_COLMN_SECTION_NO));
            gradeDto.setCourse(course);

            gradeDto.setGrade(grade);

            gradeDto.setStatusDesc(rs.getString(Constants.CONST_COLMN_STATUS_DESC));
            gradeDto.setComments(rs.getString(Constants.CONST_COLMN_COMMENT));

            hod.setRoleStatus(rs.getString(Constants.CONST_COLMN_ROLE_HOD_STATUS));
            hod.setRoleStausIkon(
                    RoleTagGlyphicon.showIkon(rs.getString(Constants.CONST_COLMN_ROLE_HOD_STATUS)));
            hod.setComments(rs.getString(Constants.CONST_COLMN_ROLE_HOD_COMMENT));

            dpsAsstDean.setRoleStatus(rs.getString(Constants.CONST_COLMN_ROLE_DPS_ASST_DEAN_STATUS));
            dpsAsstDean.setRoleStausIkon(
                    RoleTagGlyphicon.showIkon(rs.getString(Constants.CONST_COLMN_ROLE_DPS_ASST_DEAN_STATUS)));
            dpsAsstDean.setComments(rs.getString(Constants.CONST_COLMN_ROLE_DPS_ASST_DEAN_COMMENT));

            dpsDean.setRoleStatus(rs.getString(Constants.CONST_COLMN_ROLE_DPS_DEAN_STATUS));
            dpsDean.setRoleStausIkon(
                    RoleTagGlyphicon.showIkon(rs.getString(Constants.CONST_COLMN_ROLE_DPS_DEAN_STATUS)));
            dpsDean.setComments(rs.getString(Constants.CONST_COLMN_ROLE_DPS_DEAN_COMMENT));

            gradeDto.setHod(hod);
            gradeDto.setDpsAsstDean(dpsAsstDean);
            gradeDto.setDpsDean(dpsDean);

            return gradeDto;
        }
    };

    yearSemester = (isRuleGradeChangeTimingFollowed) ? getRuleYearSem() : getCurrentYearSem();

    Map<String, String> namedParameterMap = new HashMap<String, String>();
    namedParameterMap.put("paramStdId", dto.getStudentId());
    namedParameterMap.put("paramYear", String.valueOf(yearSemester.getYear()));
    namedParameterMap.put("paramLAbrCourseNo", dto.getCourse().getlAbrCourseNo());
    namedParameterMap.put("paramLocale", locale.getLanguage());
    namedParameterMap.put("paramFormName", Constants.CONST_FORM_NAME_DPS_GRADE_CHANGE);
    namedParameterMap.put("paramHodRoleName", Constants.CONST_SQL_ROLE_NAME_HOD);
    namedParameterMap.put("paramADeanPRoleName", Constants.CONST_SQL_ROLE_NAME_DPS_ASSISTANT_DEAN);
    namedParameterMap.put("paramDeanPRoleName", Constants.CONST_SQL_ROLE_NAME_DPS_DEAN);

    try {
        return nPJdbcTemplDpsGradeChange.query(SQL_GRADE_SELECT_HISORY, namedParameterMap, rowMapper);
    } catch (UncategorizedSQLException sqlEx) {
        logger.error("Error occur to find to find grade change history records for student id:  {} ",
                dto.getStudentId());
        throw new NoDBRecordException(sqlEx.getMessage());
    }
}

---

From source file:om.edu.squ.squportal.portlet.dps.grade.gradechange.db.GradeChangeDBImpl.java

/**
 * //from   www. ja  va 2  s  .com
 * method name  : getStudentGrades
 * @param employeeNo
 * @param locale
 * @return
 * GradeChangeDBImpl
 * return type  : List<GradeDTO>
 * 
 * purpose      :   Grade list of a student for a particular year, semester, instructor
 *
 * Date          :   Nov 15, 2017 10:08:43 AM
 */
public List<GradeDTO> getStudentGrades(boolean isRuleGradeChangeTimingFollowed, GradeDTO gradeDTO,
        String employeeNo, final Locale locale) throws NoDBRecordException {

    String SQL_GRADE_CHANGE_STUDENT_LIST_OF_EXISTING_GRADE = queryGradeChange
            .getProperty(Constants.CONST_SQL_GRADE_CHANGE_STUDENT_LIST_OF_EXISTING_GRADE);
    YearSemester yearSemester = null;

    RowMapper<GradeDTO> rowMapper = new RowMapper<GradeDTO>() {

        @Override
        public GradeDTO mapRow(ResultSet rs, int rowNum) throws SQLException {
            GradeDTO gradeDTO = new GradeDTO();
            Course course = new Course();
            Grade grade = new Grade();
            List<Grade> grades = null;

            grades = getGrades(rs.getString(Constants.CONST_COLMN_L_ABR_CRSNO), locale);
            gradeDTO.setGrades(grades);

            gradeDTO.setSectCode(rs.getString(Constants.CONST_COLMN_SECT_CODE));
            course.setCourseNo(rs.getString(Constants.CONST_COLMN_COURSE_NO));
            course.setlAbrCourseNo(rs.getString(Constants.CONST_COLMN_L_ABR_CRSNO));
            course.setCourseName(rs.getString(Constants.CONST_COLMN_COURSE_NAME));

            grade.setGradeCode(rs.getInt(Constants.CONST_COLMN_GRADE_CODE));
            grade.setGradeVal(rs.getString(Constants.CONST_COLMN_GRADE_VAL));

            if (rs.getString(Constants.CONST_COLMN_GRADE_IS_INCOMPLETE_GRADE).equals(Constants.CONST_YES)) {
                gradeDTO.setIncompleteGrade(true);
            } else {
                gradeDTO.setIncompleteGrade(false);
            }

            gradeDTO.setStudentId(rs.getString(Constants.CONST_COLMN_STUDENT_ID));
            gradeDTO.setStudentName(rs.getString(Constants.CONST_COLMN_STUDENT_NAME));
            gradeDTO.setStudentNo(rs.getString(Constants.CONST_COLMN_STUDENT_NO));
            gradeDTO.setStdStatCode(rs.getString(Constants.CONST_COLMN_STDSTATCD));
            gradeDTO.setCourseYear(rs.getString(Constants.COST_COL_DPS_COURSE_YEAR));
            gradeDTO.setSemester(rs.getString(Constants.COST_COL_DPS_SEMESTER_CODE));

            gradeDTO.setSectionNo(rs.getString(Constants.CONST_COLMN_SECTION_NO));

            gradeDTO.setUpdatable(
                    rs.getString(Constants.CONST_COLMN_POSTPONE_GRADE_IS_UPDATABLE).equals(Constants.CONST_YES)
                            ? true
                            : false);

            if (rs.getString(Constants.CONST_COLMN_IS_CHANGE_ALLOWED).equals(Constants.CONST_YES)) {
                gradeDTO.setChangable(true);
            } else {
                gradeDTO.setChangable(false);
            }

            gradeDTO.setCourse(course);
            gradeDTO.setGrade(grade);

            return gradeDTO;
        }
    };

    yearSemester = (isRuleGradeChangeTimingFollowed) ? getRuleYearSem() : getCurrentYearSem();

    Map<String, String> namedParameterMap = new HashMap<String, String>();
    namedParameterMap.put("paramStdId", gradeDTO.getStudentId());
    namedParameterMap.put("paramYear", String.valueOf(yearSemester.getYear()));
    namedParameterMap.put("paramSem", String.valueOf(yearSemester.getSemester()));
    namedParameterMap.put("paramEmpNo", employeeNo);
    if (null == gradeDTO.getCourse().getlAbrCourseNo()
            || gradeDTO.getCourse().getlAbrCourseNo().trim().equals("")) {
        namedParameterMap.put("paramLAbrCrsNo", null);
    } else {
        namedParameterMap.put("paramLAbrCrsNo", gradeDTO.getCourse().getlAbrCourseNo());
    }
    namedParameterMap.put("paramLocale", locale.getLanguage());

    try {
        return nPJdbcTemplDpsGradeChange.query(SQL_GRADE_CHANGE_STUDENT_LIST_OF_EXISTING_GRADE,
                namedParameterMap, rowMapper);
    } catch (UncategorizedSQLException sqlEx) {
        logger.error("Error occur to find to find grade records for student id:  {} and instructor: {} ",
                gradeDTO.getStudentId(), employeeNo);
        throw new NoDBRecordException(sqlEx.getMessage());
    }

}

---