ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Brandon Goodin" <brandon.goo...@gmail.com>
Subject Re: Data conversion or data mapping error.
Date Wed, 13 Dec 2006 17:50:39 GMT
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 <brandon.goodin@gmail.com>
> *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
> <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