chenjun7418 2015-09-05 10:04 采纳率: 0%
浏览 3995
已结题

db2报错求大神解决,在线等到明天

严重: StandardWrapper.Throwable
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'systemInfoCache' defined in class path resource [config/core.xml]: Invocation of init method failed; nested exception is org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [-4220];

--- The error occurred in config/sql-mapping/coreSql.xml.

--- The error occurred while applying a result map.

--- Check the core.sysInfoList.

--- Check the result mapping for the 'name' property.

--- Cause: com.ibm.db2.jcc.a.SqlException: [jcc][t4][10199][10462][4.2.73] 必需的字符转换器不可用。 ERRORCODE=-4220, SQLSTATE=null; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:

--- The error occurred in config/sql-mapping/coreSql.xml.

--- The error occurred while applying a result map.

--- Check the core.sysInfoList.

--- Check the result mapping for the 'name' property.

--- Cause: com.ibm.db2.jcc.a.SqlException: [jcc][t4][10199][10462][4.2.73] 必需的字符转换器不可用。 ERRORCODE=-4220, SQLSTATE=null
org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [-4220];

--- The error occurred in config/sql-mapping/coreSql.xml.

--- The error occurred while applying a result map.

--- Check the core.sysInfoList.

--- Check the result mapping for the 'name' property.

--- Cause: com.ibm.db2.jcc.a.SqlException: [jcc][t4][10199][10462][4.2.73] 必需的字符转换器不可用。 ERRORCODE=-4220, SQLSTATE=null; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:

--- The error occurred in config/sql-mapping/coreSql.xml.

--- The error occurred while applying a result map.

--- Check the core.sysInfoList.

--- Check the result mapping for the 'name' property.

--- Cause: com.ibm.db2.jcc.a.SqlException: [jcc][t4][10199][10462][4.2.73] 必需的字符转换器不可用。 ERRORCODE=-4220, SQLSTATE=null
com.ibatis.common.jdbc.exception.NestedSQLException:

--- The error occurred in config/sql-mapping/coreSql.xml.

--- The error occurred while applying a result map.

--- Check the core.sysInfoList.

--- Check the result mapping for the 'name' property.

 Java代码:
 public class SystemInfoCache {

    public void init(){
        sysInfoCacheMap = new HashMap();
        List sysList = sqlMapExecutor.queryForList("core.querySysInfoList");
        for(int i=0;i<sysList.size();i++){
            Map sysMap = (Map)sysList.get(i);
            sysInfoCacheMap.put(sysMap.get("name"), sysMap.get("value"));
        }
    }
    public void setSqlMap(SqlMapClientOperations sqlmapclientoperations) {
        this.sqlMapExecutor = sqlmapclientoperations;

    }

    private SqlMapClientOperations sqlMapExecutor;
    public static Map sysInfoCacheMap;

}

<resultMap class="java.util.HashMap" id="sysInfoList">
    <result property="name" column="name"/>
    <result property="value" column="valueOf"/>
</resultMap>
<select id="querySysInfoList" resultMap="sysInfoList">
    select name,valueOf from ocs_sysinfo
</select>

  • 写回答

2条回答 默认 最新

  • 微wx笑 Java领域优质创作者 2015-09-05 10:17
    关注

    --- The error occurred in config/sql-mapping/coreSql.xml.
    这个错误发生在config/sql-mapping/coreSql.xml文件中
    --- The error occurred while applying a result map.
    在进行结果映射时产生的
    --- Check the core.sysInfoList.
    检查core.sysInfoList
    --- Check the result mapping for the 'name' property.
    检查name属性的映射

    但以下文章提供了完全不同的解决思路:
    http://blog.sina.com.cn/s/blog_5c0522dd0100fz8p.html
    http://blog.csdn.net/thc1987/article/details/7217733

    评论

报告相同问题?

悬赏问题

  • ¥15 如何在scanpy上做差异基因和通路富集?
  • ¥20 关于#硬件工程#的问题,请各位专家解答!
  • ¥15 关于#matlab#的问题:期望的系统闭环传递函数为G(s)=wn^2/s^2+2¢wn+wn^2阻尼系数¢=0.707,使系统具有较小的超调量
  • ¥15 FLUENT如何实现在堆积颗粒的上表面加载高斯热源
  • ¥30 截图中的mathematics程序转换成matlab
  • ¥15 动力学代码报错,维度不匹配
  • ¥15 Power query添加列问题
  • ¥50 Kubernetes&Fission&Eleasticsearch
  • ¥15 報錯:Person is not mapped,如何解決?
  • ¥15 c++头文件不能识别CDialog