ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Brandon Goodin" <brandon.goo...@gmail.com>
Subject Re: Data conversion or data mapping error.
Date Tue, 12 Dec 2006 15:27:10 GMT
Can you post the parameterized SQL as well?

Brandon

On 12/12/06, Cornel Antohi <cantohi@kepler-rominfo.com> 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
>
>

Mime
View raw message