[
https://issues.apache.org/jira/browse/IBATIS-431?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Larry Meadors closed IBATIS-431.
--------------------------------
> IBATIS SQL data type out of range error thrown for invalid condition.
> ---------------------------------------------------------------------
>
> Key: IBATIS-431
> URL: https://issues.apache.org/jira/browse/IBATIS-431
> Project: iBatis for Java
> Issue Type: Bug
> Components: DAO
> Environment: DB2 on mainframe. Websphere 5.1.1.4 on AIX 5.3
> Reporter: Mohamed Asad
>
> The application was working fine and suddenly for 2 min we saw the error
> below. and again it started working fine.
> This was not a data issues As the data is always validated before being
> passed.
> This code has also not been changed for almost few months and was working
> fine.
> It seems like some how data was lost in handling of IBATIS. The
> StoredProcedures returns the values back to IBATIS. ( I am not sure if the
> stored procedure did not return the value )
> will this cause such an exception .
> Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
> --- The error occurred in sample.xml.
> --- The error occurred while applying a parameter map.
> --- Check the CreatePaymentOrder.createPaymentParams.
> --- Check the statement (update procedure failed).
> --- Cause: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] CLI0123E SQL
> data type out of range. SQLSTATE=HY004
> Caused by: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] CLI0123E SQL
> data type out of range. SQLSTATE=HY004
> at
> com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:91)
> at
> com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.insert(SqlMapExecutorDelegate.java:442)
> at
> com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.insert(SqlMapSessionImpl.java:81)
> at
> com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.insert(SqlMapClientImpl.java:58)
> at
> com.ibatis.dao.client.template.SqlMapDaoTemplate.insert(SqlMapDaoTemplate.java:100)
> ... 43 more
> Caused by: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] CLI0123E SQL
> data type out of range. SQLSTATE=HY004
> at
> COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExceptionGenerator.java(Compiled
> Code))
> at
> COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExceptionGenerator.java(Inlined
> Compiled Code))
> at
> COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(SQLExceptionGenerator.java(Compiled
> Code))
> at
> COM.ibm.db2.jdbc.app.DB2PreparedStatement.execute2(DB2PreparedStatement.java(Compiled
> Code))
> at
> COM.ibm.db2.jdbc.app.DB2PreparedStatement.execute(DB2PreparedStatement.java(Compiled
> Code))
> at
> com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.execute(WSJdbcPreparedStatement.java(Compiled
> Code))
> at
> com.ibatis.sqlmap.engine.execution.SqlExecutor.executeUpdateProcedure(SqlExecutor.java:236)
> at
> com.ibatis.sqlmap.engine.mapping.statement.ProcedureStatement.sqlExecuteUpdate(ProcedureStatement.java:30)
> at
> com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:78)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
