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
