You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ibatis.apache.org by "Mohamed Asad (JIRA)" <ib...@incubator.apache.org> on 2007/05/25 19:04:17 UTC
[jira] Created: (IBATIS-431) IBATIS SQL data type out of range
error thrown for invalid condition.
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.
[jira] Closed: (IBATIS-431) IBATIS SQL data type out of range error
thrown for invalid condition.
Posted by "Larry Meadors (JIRA)" <ib...@incubator.apache.org>.
[ 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.