程序执行postgresql的存储过程报不良的类型值 int

我不是骚勇 发布于 2018/10/22 16:09
阅读 594
收藏 0

执行存储过程异常: [8958085892090750662, p_refresh_bas_cm_customer_rel_r], {} 
 org.springframework.dao.DataIntegrityViolationException: SqlMapClient operation; SQL [];   
--- The error occurred in sqlmap/common.xml.  
--- The error occurred while applying a result map.  
--- Check the dynamicSql.callProcedure-AutoResultMap.  
--- Check the result mapping for the 'p_refresh_bas_cm_customer_rel_r' property.  
--- Cause: org.postgresql.util.PSQLException: 不良的类型值 int : ; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:   
--- The error occurred in sqlmap/common.xml.  
--- The error occurred while applying a result map.  
--- Check the dynamicSql.callProcedure-AutoResultMap.  
--- Check the result mapping for the 'p_refresh_bas_cm_customer_rel_r' property.  
--- Cause: org.postgresql.util.PSQLException: 不良的类型值 int : 
    at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:102)
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
    at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:206)
Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:   
--- The error occurred in sqlmap/common.xml.  
--- The error occurred while applying a result map.  
--- Check the dynamicSql.callProcedure-AutoResultMap.  
--- Check the result mapping for the 'p_refresh_bas_cm_customer_rel_r' property.  
--- Cause: org.postgresql.util.PSQLException: 不良的类型值 int : 
    at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:201)
    at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForObject(MappedStatement.java:120)
    at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:518)
    at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:493)
    at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:106)
Caused by: org.postgresql.util.PSQLException: 不良的类型值 int : 
    at org.postgresql.jdbc2.AbstractJdbc2ResultSet.toInt(AbstractJdbc2ResultSet.java:2759)
    at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getInt(AbstractJdbc2ResultSet.java:2003)
    at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getInt(AbstractJdbc2ResultSet.java:2426)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

加载中
返回顶部
顶部