iBatis中报 java.sql.SQLException: 无效的列类型异常

最新推荐文章于 2021-10-29 11:19:11 发布

转载最新推荐文章于 2021-10-29 11:19:11 发布 · 260 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

原文链接：http://www.cnblogs.com/cici-new/archive/2013/01/25/2876450.html

标签

#java

本文解析了一条关于Spring框架中JDBC操作引发的UncategorizedSQLException错误。错误发生在尝试获取个人基本信息列表时，提示无效的列类型。文章详细分析了问题出现在参数映射过程中的DEPT_NO属性，并提供了相应的解决办法。

错误信息

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.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

    <![CDATA[
                AND     EXISTS (SELECT *
                              FROM HR_DEPARTMENT B1
                             WHERE B1.DEPTNO = B.DEPTNO
                             START WITH B1.DEPTNO = #DEPT_NO#
                           CONNECT BY PRIOR B1.DEPTNO = B1.PARENT_DEPT_NO)
            ]]>

参数传值

{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());

问题点

黄色部分参数名称不对应

故改之

转载于:https://www.cnblogs.com/cici-new/archive/2013/01/25/2876450.html