ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Larry Meadors" <lmead...@apache.org>
Subject Re: Data conversion or data mapping error.
Date Wed, 13 Dec 2006 17:48:36 GMT
Holy stack trace.

That looks like a jdbc-level db/2 specific error - you may want to
google "[SQL0802] Data conversion or data mapping error."

Larry


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