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 17:14:07 GMT
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