错误信息

description The server encountered an internal error () that prevented it from fulfilling this request.exceptionorg.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [17004];   --- The error occurred while applying a parameter map.  --- Check the ess.viewApply.getEssPersonalInfoList-InlineParameterMap.  --- Check the parameter mapping for the 'DEPT_NO' property.  --- Cause: java.sql.SQLException: 无效的列类型; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:   --- The error occurred while applying a parameter map.  --- Check the ess.viewApply.getEssPersonalInfoList-InlineParameterMap.  --- Check the parameter mapping for the 'DEPT_NO' property.  --- Cause: java.sql.SQLException: 无效的列类型    org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:894)    org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:778)    javax.servlet.http.HttpServlet.service(HttpServlet.java:617)    javax.servlet.http.HttpServlet.service(HttpServlet.java:717)    com.ait.web.filter.UserAuthenFilter.doFilter(UserAuthenFilter.java:77)    org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)    org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

关键点XML SQL

参数传值

{interLanguage=zh, interCpnyID=C11, orderField=, orderDirection=asc, specialParam=special,  AR_SUPERVISIOR_INFO=30044292, userNo=36911,  deptNo=C114, ADMIN_ID=30044292, CREATED_BY=30044292, UPDATED_BY=30044292, PERSON_ID=30044292, CPNY_ID=C11}

public class ViewApplySerImpl implements ViewApplySer {

 Line 55 paramMap.put("DEPT_NO", admin.getDeptNo());

问题点

黄色部分参数名称不对应

故改之