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 Re: Data conversion or data mapping error.
Date Wed, 13 Dec 2006 18:13:31 GMT
This failure happening from time to time under the heavy load.The same query is well executed
and from time to time it crashes ... not always with the same set of parameters ... I cannot
find a pattern to say that it crashes always with a defined list of parameters.

One more information ... after the heavy load ends, if I am trying to execute the same application
functionality (so executing the same query with same parameters as the ones when it crashes)
it works fine ...

Thank you,
Cornel
  ----- Original Message ----- 
  From: Brandon Goodin 
  To: user-java@ibatis.apache.org 
  Sent: Wednesday, December 13, 2006 7:50 PM
  Subject: Re: Data conversion or data mapping error.


  Thanks for the additional information. Is this failure happening consistently with the set
of parameters that you are displaying (128,1409,19
  )? or just under heavy load? On the front this looks like it may be a driver issue. One
other thought is to upgraded to 2.2.0 and see if that makes a difference. I doubt it will.
But, it is always a default action of mine to try the latest and greatest.

   

  On 12/13/06, Cornel Antohi <cantohi@kepler-rominfo.com> wrote:
    Hello,

    Here are more log info:

    // STATEMENTS //

    11 Dec 2006 11:52:21 [WebContainer : 6] DEBUG java.sql.PreparedStatement ///java/// -
{pstm-195813} PreparedStatement:     select 1 from SEC_FN_USR      where SEC_ID=? and USER_ID=?
and FN_ID=?    
    11 Dec 2006 11:52:21 [WebContainer : 6] DEBUG java.sql.PreparedStatement ///java/// -
{pstm-195813} Parameters: [128, 1409, 19]
    11 Dec 2006 11:52:21 [WebContainer : 6] DEBUG java.sql.PreparedStatement ///java/// -
{pstm-195813} Types: [java.lang.Long, java.lang.Long, java.lang.Long]

    // App Logs //

    11 Dec 2006 11:52:21 [WebContainer : 6] ERROR com.myc.exceptions.SystemException ///<init>///
- Error id=1165834341289
    Failed to execute queryForObject - id [checkAuthorizedForSecuredItem], parameterObject
[{secItemId=128, userId=1409, functionId=19}].  Cause: com.ibatis.common.jdbc.exception.NestedSQLException:
  
    --- The error occurred in com/myc/fpr/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.
    com.ibatis.dao.client.DaoException: Failed to execute queryForObject - id [checkAuthorizedForSecuredItem],
parameterObject [{secItemId=128, userId=1409, functionId=19}].  Cause: com.ibatis.common.jdbc.exception.NestedSQLException:
  
    --- The error occurred in com/myc/fpr/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/myc/fpr/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.
     at com.ibatis.dao.client.template.SqlMapDaoTemplate.queryForObject(SqlMapDaoTemplate.java(Compiled
Code))
     at com.myc.dbaccess.db2.BaseDao.queryForObject(Unknown Source)
     at com.myc.fpr.admin.dao.db2.UserDb2DAO.isAuthorizedForSecuredItem(Unknown Source)
     at sun.reflect.GeneratedMethodAccessor325.invoke(Unknown Source)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled
Code))
     at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
     at com.ibatis.dao.engine.impl.DaoProxy.invoke(DaoProxy.java(Compiled Code))
     at $Proxy9.isAuthorizedForSecuredItem(Unknown Source)
     at com.myc.fpr.security.authorization.AuthorizationService.isUserAuthorizedForSecuredItem(Unknown
Source)
     at com.myc.fpr.product.action.MethodsAction.show(Unknown Source)
     at com.myc.fpr.product.action.MethodsAction.display(Unknown Source)
     at sun.reflect.GeneratedMethodAccessor322.invoke(Unknown Source)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled
Code))
     at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
     at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java(Compiled
Code))
     at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java(Compiled Code))
     at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java(Inlined
Compiled Code))
     at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java(Compiled Code))
     at org.apache.struts.action.ActionServlet.process(ActionServlet.java(Inlined Compiled
Code))
     at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java(Compiled Code))
     at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
     at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
     at com.ibm.ws.cache.servlet.ServletWrapper.serviceProxied(ServletWrapper.java(Inlined
Compiled Code))
     at com.ibm.ws.cache.servlet.CacheHook.handleFragment(CacheHook.java(Compiled Code))
     at com.ibm.ws.cache.servlet.CacheHook.handleServlet(CacheHook.java(Compiled Code))
     at com.ibm.ws.cache.servlet.ServletWrapper.service(ServletWrapper.java(Compiled Code))
     at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java(Compiled
Code))
     at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java(Compiled
Code))
     at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java(Compiled
Code))
     at com.myc.fpr.security.authorization.AuthorizationFilter.doFilter(Unknown Source)
     at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java(Compiled
Code))
     at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java(Compiled
Code))
     at com.myc.common.filter.AccessFilter.doFilter(AccessFilter.java(Compiled Code))
     at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java(Compiled
Code))
     at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java(Compiled
Code))
     at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java(Compiled
Code))
     at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java(Compiled
Code))
     at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java(Compiled
Code))
     at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java(Compiled Code))
     at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java(Compiled Code))
     at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java(Compiled
Code))
     at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java(Compiled
Code))
     at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java(Compiled
Code))
     at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java(Compiled
Code))
     at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java(Compiled
Code))
     at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java(Compiled
Code))
     at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java(Compiled
Code))
     at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code))
    Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:   
    --- The error occurred in com/myc/fpr/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.
     at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java(Compiled
Code))
     at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForObject(GeneralStatement.java(Compiled
Code))
     at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java(Compiled
Code))
     at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java(Inlined
Compiled Code))
     at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java(Inlined
Compiled Code))
     at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClientImpl.java(Compiled
Code))
     ... 48 more
    Caused by: java.sql.SQLException: [SQL0802] Data conversion or data mapping error.
     at com.ibm.as400.access.JDError.throwSQLException(JDError.java(Compiled Code))
     at com.ibm.as400.access.JDError.throwSQLException(JDError.java(Inlined Compiled Code))
     at com.ibm.as400.access.AS400JDBCStatement.commonExecute(AS400JDBCStatement.java(Compiled
Code))
     at com.ibm.as400.access.AS400JDBCPreparedStatement.execute(AS400JDBCPreparedStatement.java(Compiled
Code))
     at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecute(WSJdbcPreparedStatement.java(Compiled
Code))
     at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.execute(WSJdbcPreparedStatement.java(Compiled
Code))
     at sun.reflect.GeneratedMethodAccessor71.invoke(Unknown Source)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled
Code))
     at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
     at com.ibatis.common.jdbc.logging.PreparedStatementLogProxy.invoke(PreparedStatementLogProxy.java(Compiled
Code))
     at $Proxy28.execute(Unknown Source)
     at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java(Compiled
Code))
     at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java(Compiled
Code))
     ... 54 more

    Caused by: 
    com.ibatis.common.jdbc.exception.NestedSQLException:   
    --- The error occurred in com/myc/fpr/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.
     at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java(Compiled
Code))
     at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForObject(GeneralStatement.java(Compiled
Code))
     at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java(Compiled
Code))
     at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java(Inlined
Compiled Code))
     at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java(Inlined
Compiled Code))
     at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClientImpl.java(Compiled
Code))
     at com.ibatis.dao.client.template.SqlMapDaoTemplate.queryForObject(SqlMapDaoTemplate.java(Compiled
Code))
     at com.myc.dbaccess.db2.BaseDao.queryForObject(Unknown Source)
     at com.myc.fpr.admin.dao.db2.UserDb2DAO.isAuthorizedForSecuredItem(Unknown Source)
     at sun.reflect.GeneratedMethodAccessor325.invoke(Unknown Source)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled
Code))
     at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
     at com.ibatis.dao.engine.impl.DaoProxy.invoke(DaoProxy.java(Compiled Code))
     at $Proxy9.isAuthorizedForSecuredItem(Unknown Source)
     at com.myc.fpr.security.authorization.AuthorizationService.isUserAuthorizedForSecuredItem(Unknown
Source)
     at com.myc.fpr.product.action.MethodsAction.show(Unknown Source)
     at com.myc.fpr.product.action.MethodsAction.display(Unknown Source)
     at sun.reflect.GeneratedMethodAccessor322.invoke(Unknown Source)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled
Code))
     at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
     at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java(Compiled
Code))
     at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java(Compiled Code))
     at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java(Inlined
Compiled Code))
     at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java(Compiled Code))
     at org.apache.struts.action.ActionServlet.process(ActionServlet.java(Inlined Compiled
Code))
     at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java(Compiled Code))
     at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
     at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
     at com.ibm.ws.cache.servlet.ServletWrapper.serviceProxied(ServletWrapper.java(Inlined
Compiled Code))
     at com.ibm.ws.cache.servlet.CacheHook.handleFragment(CacheHook.java(Compiled Code))
     at com.ibm.ws.cache.servlet.CacheHook.handleServlet(CacheHook.java(Compiled Code))
     at com.ibm.ws.cache.servlet.ServletWrapper.service(ServletWrapper.java(Compiled Code))
     at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java(Compiled
Code))
     at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java(Compiled
Code))
     at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java(Compiled
Code))
     at com.myc.fpr.security.authorization.AuthorizationFilter.doFilter(Unknown Source)
     at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java(Compiled
Code))
     at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java(Compiled
Code))
     at com.myc.common.filter.AccessFilter.doFilter(AccessFilter.java(Compiled Code))
     at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java(Compiled
Code))
     at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java(Compiled
Code))
     at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java(Compiled
Code))
     at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java(Compiled
Code))
     at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java(Compiled
Code))
     at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java(Compiled Code))
     at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java(Compiled Code))
     at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java(Compiled
Code))
     at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java(Compiled
Code))
     at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java(Compiled
Code))
     at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java(Compiled
Code))
     at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java(Compiled
Code))
     at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java(Compiled
Code))
     at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java(Compiled
Code))
     at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code))
    Caused by: java.sql.SQLException: [SQL0802] Data conversion or data mapping error.
     at com.ibm.as400.access.JDError.throwSQLException(JDError.java(Compiled Code))
     at com.ibm.as400.access.JDError.throwSQLException(JDError.java(Inlined Compiled Code))
     at com.ibm.as400.access.AS400JDBCStatement.commonExecute(AS400JDBCStatement.java(Compiled
Code))
     at com.ibm.as400.access.AS400JDBCPreparedStatement.execute(AS400JDBCPreparedStatement.java(Compiled
Code))
     at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecute(WSJdbcPreparedStatement.java(Compiled
Code))
     at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.execute(WSJdbcPreparedStatement.java(Compiled
Code))
     at sun.reflect.GeneratedMethodAccessor71.invoke(Unknown Source)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled
Code))
     at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
     at com.ibatis.common.jdbc.logging.PreparedStatementLogProxy.invoke(PreparedStatementLogProxy.java(Compiled
Code))
     at $Proxy28.execute(Unknown Source)
     at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java(Compiled
Code))
     at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java(Compiled
Code))
     ... 54 more

    Caused by: 
    java.sql.SQLException: [SQL0802] Data conversion or data mapping error.
     at com.ibm.as400.access.JDError.throwSQLException(JDError.java(Compiled Code))
     at com.ibm.as400.access.JDError.throwSQLException(JDError.java(Inlined Compiled Code))
     at com.ibm.as400.access.AS400JDBCStatement.commonExecute(AS400JDBCStatement.java(Compiled
Code))
     at com.ibm.as400.access.AS400JDBCPreparedStatement.execute(AS400JDBCPreparedStatement.java(Compiled
Code))
     at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecute(WSJdbcPreparedStatement.java(Compiled
Code))
     at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.execute(WSJdbcPreparedStatement.java(Compiled
Code))
     at sun.reflect.GeneratedMethodAccessor71.invoke(Unknown Source)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled
Code))
     at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
     at com.ibatis.common.jdbc.logging.PreparedStatementLogProxy.invoke(PreparedStatementLogProxy.java(Compiled
Code))
     at $Proxy28.execute(Unknown Source)
     at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java(Compiled
Code))
     at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java(Compiled
Code))
     at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java(Compiled
Code))
     at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForObject(GeneralStatement.java(Compiled
Code))
     at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java(Compiled
Code))
     at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java(Inlined
Compiled Code))
     at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java(Inlined
Compiled Code))
     at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClientImpl.java(Compiled
Code))
     at com.ibatis.dao.client.template.SqlMapDaoTemplate.queryForObject(SqlMapDaoTemplate.java(Compiled
Code))
     at com.myc.dbaccess.db2.BaseDao.queryForObject(Unknown Source)
     at com.myc.fpr.admin.dao.db2.UserDb2DAO.isAuthorizedForSecuredItem(Unknown Source)
     at sun.reflect.GeneratedMethodAccessor325.invoke(Unknown Source)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled
Code))
     at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
     at com.ibatis.dao.engine.impl.DaoProxy.invoke(DaoProxy.java(Compiled Code))
     at $Proxy9.isAuthorizedForSecuredItem(Unknown Source)
     at com.myc.fpr.security.authorization.AuthorizationService.isUserAuthorizedForSecuredItem(Unknown
Source)
     at com.myc.fpr.product.action.MethodsAction.show(Unknown Source)
     at com.myc.fpr.product.action.MethodsAction.display(Unknown Source)
     at sun.reflect.GeneratedMethodAccessor322.invoke(Unknown Source)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled
Code))
     at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
     at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java(Compiled
Code))
     at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java(Compiled Code))
     at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java(Inlined
Compiled Code))
     at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java(Compiled Code))
     at org.apache.struts.action.ActionServlet.process(ActionServlet.java(Inlined Compiled
Code))
     at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java(Compiled Code))
     at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
     at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
     at com.ibm.ws.cache.servlet.ServletWrapper.serviceProxied(ServletWrapper.java(Inlined
Compiled Code))
     at com.ibm.ws.cache.servlet.CacheHook.handleFragment(CacheHook.java(Compiled Code))
     at com.ibm.ws.cache.servlet.CacheHook.handleServlet(CacheHook.java(Compiled Code))
     at com.ibm.ws.cache.servlet.ServletWrapper.service(ServletWrapper.java(Compiled Code))
     at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java(Compiled
Code))
     at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java(Compiled
Code))
     at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java(Compiled
Code))
     at com.myc.fpr.security.authorization.AuthorizationFilter.doFilter(Unknown Source)
     at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java(Compiled
Code))
     at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java(Compiled
Code))
     at com.myc.common.filter.AccessFilter.doFilter(AccessFilter.java(Compiled Code))
     at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java(Compiled
Code))
     at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java(Compiled
Code))
     at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java(Compiled
Code))
     at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java(Compiled
Code))
     at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java(Compiled
Code))
     at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java(Compiled Code))
     at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java(Compiled Code))
     at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java(Compiled
Code))
     at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java(Compiled
Code))
     at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java(Compiled
Code))
     at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java(Compiled
Code))
     at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java(Compiled
Code))
     at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java(Compiled
Code))
     at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java(Compiled
Code))
     at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code))
    11 Dec 2006 11:52:21 [WebContainer : 6] ERROR com.myc.fpr.utils.FprExceptionHandler ///execute///
- Exception occured ... catched by Handler
    11 Dec 2006 11:52:21 [WebContainer : 6] ERROR com.myc.fpr.utils.FprExceptionHandler ///execute///
- com.ibatis.dao.client.DaoException: Failed to execute queryForObject - id [checkAuthorizedForSecuredItem],
parameterObject [{secItemId=128, userId=1409, functionId=19}].  Cause: com.ibatis.common.jdbc.exception.NestedSQLException:
  
    --- The error occurred in com/myc/fpr/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/myc/fpr/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.
    com.myc.dbaccess.DBException: com.ibatis.dao.client.DaoException: Failed to execute queryForObject
- id [checkAuthorizedForSecuredItem], parameterObject [{secItemId=128, userId=1409, functionId=19}].
 Cause: com.ibatis.common.jdbc.exception.NestedSQLException:   
    --- The error occurred in com/myc/fpr/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/myc/fpr/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.
     at com.myc.dbaccess.DB2ExceptionDecoder.throwDecodedException(Unknown Source)
     at com.myc.dbaccess.DB2ExceptionDecoder.throwDecodedException(Unknown Source)
     at com.myc.dbaccess.db2.BaseDao.queryForObject(Unknown Source)
     at com.myc.fpr.admin.dao.db2.UserDb2DAO.isAuthorizedForSecuredItem(Unknown Source)
     at sun.reflect.GeneratedMethodAccessor325.invoke(Unknown Source)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled
Code))
     at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
     at com.ibatis.dao.engine.impl.DaoProxy.invoke(DaoProxy.java(Compiled Code))
     at $Proxy9.isAuthorizedForSecuredItem(Unknown Source)
     at com.myc.fpr.security.authorization.AuthorizationService.isUserAuthorizedForSecuredItem(Unknown
Source)
     at com.myc.fpr.product.action.MethodsAction.show(Unknown Source)
     at com.myc.fpr.product.action.MethodsAction.display(Unknown Source)
     at sun.reflect.GeneratedMethodAccessor322.invoke(Unknown Source)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled
Code))
     at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
     at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java(Compiled
Code))
     at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java(Compiled Code))
     at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java(Inlined
Compiled Code))
     at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java(Compiled Code))
     at org.apache.struts.action.ActionServlet.process(ActionServlet.java(Inlined Compiled
Code))
     at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java(Compiled Code))
     at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
     at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
     at com.ibm.ws.cache.servlet.ServletWrapper.serviceProxied(ServletWrapper.java(Inlined
Compiled Code))
     at com.ibm.ws.cache.servlet.CacheHook.handleFragment(CacheHook.java(Compiled Code))
     at com.ibm.ws.cache.servlet.CacheHook.handleServlet(CacheHook.java(Compiled Code))
     at com.ibm.ws.cache.servlet.ServletWrapper.service(ServletWrapper.java(Compiled Code))
     at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java(Compiled
Code))
     at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java(Compiled
Code))
     at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java(Compiled
Code))
     at com.myc.fpr.security.authorization.AuthorizationFilter.doFilter(Unknown Source)
     at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java(Compiled
Code))
     at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java(Compiled
Code))
     at com.myc.common.filter.AccessFilter.doFilter(AccessFilter.java(Compiled Code))
     at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java(Compiled
Code))
     at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java(Compiled
Code))
     at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java(Compiled
Code))
     at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java(Compiled
Code))
     at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java(Compiled
Code))
     at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java(Compiled Code))
     at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java(Compiled Code))
     at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java(Compiled
Code))
     at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java(Compiled
Code))
     at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java(Compiled
Code))
     at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java(Compiled
Code))
     at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java(Compiled
Code))
     at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java(Compiled
Code))
     at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java(Compiled
Code))
     at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code))
    Caused by: com.ibatis.dao.client.DaoException: Failed to execute queryForObject - id [checkAuthorizedForSecuredItem],
parameterObject [{secItemId=128, userId=1409, functionId=19}].  Cause: com.ibatis.common.jdbc.exception.NestedSQLException:
  
    --- The error occurred in com/myc/fpr/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/myc/fpr/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.
     at com.ibatis.dao.client.template.SqlMapDaoTemplate.queryForObject(SqlMapDaoTemplate.java(Compiled
Code))
     ... 47 more
    Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:   
    --- The error occurred in com/myc/fpr/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.
     at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java(Compiled
Code))
     at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForObject(GeneralStatement.java(Compiled
Code))
     at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java(Compiled
Code))
     at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java(Inlined
Compiled Code))
     at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java(Inlined
Compiled Code))
     at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClientImpl.java(Compiled
Code))
     ... 48 more
    Caused by: java.sql.SQLException: [SQL0802] Data conversion or data mapping error.
     at com.ibm.as400.access.JDError.throwSQLException(JDError.java(Compiled Code))
     at com.ibm.as400.access.JDError.throwSQLException(JDError.java(Inlined Compiled Code))
     at com.ibm.as400.access.AS400JDBCStatement.commonExecute(AS400JDBCStatement.java(Compiled
Code))
     at com.ibm.as400.access.AS400JDBCPreparedStatement.execute(AS400JDBCPreparedStatement.java(Compiled
Code))
     at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecute(WSJdbcPreparedStatement.java(Compiled
Code))
     at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.execute(WSJdbcPreparedStatement.java(Compiled
Code))
     at sun.reflect.GeneratedMethodAccessor71.invoke(Unknown Source)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled
Code))
     at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
     at com.ibatis.common.jdbc.logging.PreparedStatementLogProxy.invoke(PreparedStatementLogProxy.java(Compiled
Code))
     at $Proxy28.execute(Unknown Source)
     at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java(Compiled
Code))
     at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java(Compiled
Code))
     ... 54 more


    Thank you,
    Cornel
      ----- Original Message ----- 
      From: Brandon Goodin 
      To: user-java@ibatis.apache.org 
      Sent: Tuesday, December 12, 2006 5:27 PM
      Subject: Re: Data conversion or data mapping error.


      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