Can you post the parameterized SQL as well?
Brandon
On 12/12/06, Cornel Antohi <[EMAIL PROTECTED]> wrote:
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
