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 <[EMAIL PROTECTED]> 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: [email protected]
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 <[EMAIL PROTECTED] > 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
>
>
