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.
