ibatis-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Larry Meadors (JIRA)" <ibatis-...@incubator.apache.org>
Subject [jira] Closed: (IBATIS-431) IBATIS SQL data type out of range error thrown for invalid condition.
Date Fri, 25 May 2007 18:02:16 GMT

     [ 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.


Mime
View raw message