ibatis-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mohamed Asad (JIRA)" <ibatis-...@incubator.apache.org>
Subject [jira] Created: (IBATIS-431) IBATIS SQL data type out of range error thrown for invalid condition.
Date Fri, 25 May 2007 17:04:17 GMT
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.


Mime
View raw message