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

[weixin_38048397]

执行存储过程异常: [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)