ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Cornel Antohi" <cant...@kepler-rominfo.com>
Subject Data conversion or data mapping error.
Date Tue, 12 Dec 2006 12:32:53 GMT
Hello,

I have a big problem on one of my application that is ussing IBatis v2.1.7, DB2 AS400 V5R3
and WAS 6.0. 
During the tests (few users) the application is working fine but when we run the loading tests
(many users in paralel) we received the following error. What is strange it is that the query
fails only during the loading tests and with some parameters and not always ... the exact
same query it is executed fine in some cases. We could not find yet a pattern to reproduce
this behaviour ...

Here are the logs:


11 Dec 2006 10:44:12 [WebContainer : 1] ERROR FprExceptionHandler ///execute/// - com.ibatis.dao.client.DaoException:
Failed to execute queryForObject - id [checkAuthorizedForSecuredItem], parameterObject [{secItemId=152,
userId=1316, functionId=19}].  Cause: com.ibatis.common.jdbc.exception.NestedSQLException:
  
--- The error occurred in com/admin/dao/sqlmapdao/User.xml.   
--- The error occurred while applying a parameter map.   
--- Check the checkAuthorizedForSecuredItem-InlineParameterMap.   
--- Check the statement (query failed).   
--- Cause: java.sql.SQLException: [SQL0802] Data conversion or data mapping error. 
Caused by: java.sql.SQLException: [SQL0802] Data conversion or data mapping error. 
Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:   
--- The error occurred in com/admin/dao/sqlmapdao/User.xml.   
--- The error occurred while applying a parameter map.   
--- Check the checkAuthorizedForSecuredItem-InlineParameterMap.   
--- Check the statement (query failed).   
--- Cause: java.sql.SQLException: [SQL0802] Data conversion or data mapping error. 


Query: 
  <select id="checkAuthorizedForSecuredItem" resultClass="long" parameterClass="map">

          select 1 from SEC_FN_USR 
                  where SEC_ID=#secItemId# and USER_ID=#userId# and FN_ID=#functionId# 
  </select> 


Params: 
[{secItemId=152, userId=1316, functionId=19}] 
[{secItemId=152, userId=1017, functionId=19}] 
[{secItemId=131, userId=1055, functionId=19}] 
[{secItemId=140, userId=1321, functionId=19}] 
... 


Do you have any clue for this problem?

Any help is highly appreciated!

Thank you,
Cornel


Mime
View raw message