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:23:07 GMT
Hi Jeff,

Sorry for my mistake ... on AS/400 side the fields are NUMERIC(12,0) ...

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


  He,

  Yes, I am using AS/400 V5R3 and Java Long ... AS/400 fields are NUMBER(12). This works fine
in so many cases of my application but only during the heavy load it crashes for only this
specific query!

  I also think that it may be a JDBC Driver - AS/400 issue and not related to iBatis ...

  Thank you,
  Cornel

    ----- Original Message ----- 
    From: Jeff Butler 
    To: user-java@ibatis.apache.org 
    Sent: Wednesday, December 13, 2006 7:57 PM
    Subject: Re: Data conversion or data mapping error.


    Here's my 2 cents...

    You're using AS/400 and Java Long data type.  Those two don't normally go together.  My
guess is that the AS/400 fields are packed decimal.  Try using BigDecimal as parameters instead
of Longs to see if it makes a difference.  There are some driver properties related to decimal
conversion too IIRC. 

    Also, if there are any strings in the result set, make sure that the CCSID is set correctly
in the dirver to match what's on the system - this could be the source of translation problems
too.

    Jeff Butler


     
    On 12/13/06, Brandon Goodin <brandon.goodin@gmail.com> wrote: 
      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