ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jeff Butler" <jeffgbut...@gmail.com>
Subject Re: Data conversion or data mapping error.
Date Wed, 13 Dec 2006 17:57:48 GMT
Here's my 2 cents...

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

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

Jeff Butler



On 12/13/06, Brandon Goodin <brandon.goodin@gmail.com> wrote:
>
> Thanks for the additional information. Is this failure happening
> consistently with the set of parameters that you are displaying (128,1409,19
> )? or just under heavy load? On the front this looks like it may be a
> driver issue. One other thought is to upgraded to 2.2.0 and see if that
> makes a difference. I doubt it will. But, it is always a default action of
> mine to try the latest and greatest.
>
>
> On 12/13/06, Cornel Antohi <cantohi@kepler-rominfo.com> wrote:
> >
> >  Hello,
> >
> > Here are more log info:
> >
> > // STATEMENTS //
> >
> > 11 Dec 2006 11:52:21 [WebContainer : 6] DEBUG java.sql.PreparedStatement///java///
- {pstm-195813} PreparedStatement:     select 1 from
> > SEC_FN_USR      where SEC_ID=? and USER_ID=? and FN_ID=?
> > 11 Dec 2006 11:52:21 [WebContainer : 6] DEBUG java.sql.PreparedStatement///java///
- {pstm-195813} Parameters: [128, 1409, 19]
> > 11 Dec 2006 11:52:21 [WebContainer : 6] DEBUG java.sql.PreparedStatement///java///
- {pstm-195813} Types: [
> > java.lang.Long, java.lang.Long, java.lang.Long]
> >
> > // App Logs //
> >
> > 11 Dec 2006 11:52:21 [WebContainer : 6] ERROR
> > com.myc.exceptions.SystemException ///<init>/// - Error id=1165834341289
> > Failed to execute queryForObject - id [checkAuthorizedForSecuredItem],
> > parameterObject [{secItemId=128, userId=1409, functionId=19}].  Cause:
> > com.ibatis.common.jdbc.exception.NestedSQLException:
> > --- The error occurred in com/myc/fpr/admin/dao/sqlmapdao/User.xml.
> > --- The error occurred while applying a parameter map.
> > --- Check the checkAuthorizedForSecuredItem-InlineParameterMap.
> > --- Check the statement (query failed).
> > --- Cause: java.sql.SQLException: [SQL0802] Data conversion or data
> > mapping error.
> > Caused by: java.sql.SQLException: [SQL0802] Data conversion or data
> > mapping error.
> > com.ibatis.dao.client.DaoException: Failed to execute queryForObject -
> > id [checkAuthorizedForSecuredItem], parameterObject [{secItemId=128,
> > userId=1409, functionId=19}].  Cause:
> > com.ibatis.common.jdbc.exception.NestedSQLException:
> > --- The error occurred in com/myc/fpr/admin/dao/sqlmapdao/User.xml.
> > --- The error occurred while applying a parameter map.
> > --- Check the checkAuthorizedForSecuredItem-InlineParameterMap.
> > --- Check the statement (query failed).
> > --- Cause: java.sql.SQLException: [SQL0802] Data conversion or data
> > mapping error.
> > Caused by: java.sql.SQLException: [SQL0802] Data conversion or data
> > mapping error.
> > Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
> > --- The error occurred in com/myc/fpr/admin/dao/sqlmapdao/User.xml.
> > --- The error occurred while applying a parameter map.
> > --- Check the checkAuthorizedForSecuredItem-InlineParameterMap.
> > --- Check the statement (query failed).
> > --- Cause: java.sql.SQLException: [SQL0802] Data conversion or data
> > mapping error.
> > Caused by: java.sql.SQLException: [SQL0802] Data conversion or data
> > mapping error.
> >  at com.ibatis.dao.client.template.SqlMapDaoTemplate.queryForObject(
> > SqlMapDaoTemplate.java(Compiled Code))
> >  at com.myc.dbaccess.db2.BaseDao.queryForObject(Unknown Source)
> >  at com.myc.fpr.admin.dao.db2.UserDb2DAO.isAuthorizedForSecuredItem(Unknown
> > Source)
> >  at sun.reflect.GeneratedMethodAccessor325.invoke(Unknown Source)
> >  at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> > DelegatingMethodAccessorImpl.java(Compiled Code))
> >  at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
> >  at com.ibatis.dao.engine.impl.DaoProxy.invoke(DaoProxy.java(Compiled
> > Code))
> >  at $Proxy9.isAuthorizedForSecuredItem(Unknown Source)
> >  at
> > com.myc.fpr.security.authorization.AuthorizationService.isUserAuthorizedForSecuredItem(Unknown
> > Source)
> >  at com.myc.fpr.product.action.MethodsAction.show(Unknown Source)
> >  at com.myc.fpr.product.action.MethodsAction.display(Unknown Source)
> >  at sun.reflect.GeneratedMethodAccessor322.invoke(Unknown Source)
> >  at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> > DelegatingMethodAccessorImpl.java(Compiled Code))
> >  at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
> >  at org.apache.struts.actions.DispatchAction.dispatchMethod(
> > DispatchAction.java(Compiled Code))
> >  at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java(Compiled
> > Code))
> >  at org.apache.struts.action.RequestProcessor.processActionPerform(
> > RequestProcessor.java(Inlined Compiled Code))
> >  at org.apache.struts.action.RequestProcessor.process(
> > RequestProcessor.java(Compiled Code))
> >  at org.apache.struts.action.ActionServlet.process(ActionServlet.java(Inlined
> > Compiled Code))
> >  at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java(Compiled
> > Code))
> >  at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled
> > Code))
> >  at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled
> > Code))
> >  at com.ibm.ws.cache.servlet.ServletWrapper.serviceProxied(
> > ServletWrapper.java(Inlined Compiled Code))
> >  at com.ibm.ws.cache.servlet.CacheHook.handleFragment(CacheHook.java(Compiled
> > Code))
> >  at com.ibm.ws.cache.servlet.CacheHook.handleServlet(CacheHook.java(Compiled
> > Code))
> >  at com.ibm.ws.cache.servlet.ServletWrapper.service(ServletWrapper.java(Compiled
> > Code))
> >  at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(
> > ServletWrapper.java(Compiled Code))
> >  at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(
> > ServletWrapper.java(Compiled Code))
> >  at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(
> > WebAppFilterChain.java(Compiled Code))
> >  at com.myc.fpr.security.authorization.AuthorizationFilter.doFilter(Unknown
> > Source)
> >  at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(
> > FilterInstanceWrapper.java(Compiled Code))
> >  at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(
> > WebAppFilterChain.java(Compiled Code))
> >  at com.myc.common.filter.AccessFilter.doFilter(AccessFilter.java(Compiled
> > Code))
> >  at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(
> > FilterInstanceWrapper.java(Compiled Code))
> >  at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(
> > WebAppFilterChain.java(Compiled Code))
> >  at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(
> > WebAppFilterChain.java(Compiled Code))
> >  at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(
> > ServletWrapper.java(Compiled Code))
> >  at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(
> > CacheServletWrapper.java(Compiled Code))
> >  at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java(Compiled
> > Code))
> >  at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(
> > WCChannelLink.java(Compiled Code))
> >  at
> > com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination
> > (HttpInboundLink.java(Compiled Code))
> >  at
> > com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation
> > (HttpInboundLink.java(Compiled Code))
> >  at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(
> > HttpICLReadCallback.java(Compiled Code))
> >  at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(
> > WorkQueueManager.java(Compiled Code))
> >  at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(
> > WorkQueueManager.java(Compiled Code))
> >  at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(
> > WorkQueueManager.java(Compiled Code))
> >  at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(
> > WorkQueueManager.java(Compiled Code))
> >  at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled
> > Code))
> > Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
> > --- The error occurred in com/myc/fpr/admin/dao/sqlmapdao/User.xml.
> > --- The error occurred while applying a parameter map.
> > --- Check the checkAuthorizedForSecuredItem-InlineParameterMap.
> > --- Check the statement (query failed).
> > --- Cause: java.sql.SQLException: [SQL0802] Data conversion or data
> > mapping error.
> > Caused by: java.sql.SQLException: [SQL0802] Data conversion or data
> > mapping error.
> >  at
> > com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback
> > (GeneralStatement.java(Compiled Code))
> >  at
> > com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForObject
> > (GeneralStatement.java(Compiled Code))
> >  at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(
> > SqlMapExecutorDelegate.java(Compiled Code))
> >  at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(
> > SqlMapExecutorDelegate.java(Inlined Compiled Code))
> >  at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(
> > SqlMapSessionImpl.java(Inlined Compiled Code))
> >  at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(
> > SqlMapClientImpl.java(Compiled Code))
> >  ... 48 more
> > Caused by: java.sql.SQLException: [SQL0802] Data conversion or data
> > mapping error.
> >  at com.ibm.as400.access.JDError.throwSQLException(JDError.java(Compiled
> > Code))
> >  at com.ibm.as400.access.JDError.throwSQLException(JDError.java(Inlined
> > Compiled Code))
> >  at com.ibm.as400.access.AS400JDBCStatement.commonExecute(
> > AS400JDBCStatement.java(Compiled Code))
> >  at com.ibm.as400.access.AS400JDBCPreparedStatement.execute(
> > AS400JDBCPreparedStatement.java(Compiled Code))
> >  at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecute(
> > WSJdbcPreparedStatement.java(Compiled Code))
> >  at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.execute(
> > WSJdbcPreparedStatement.java(Compiled Code))
> >  at sun.reflect.GeneratedMethodAccessor71.invoke(Unknown Source)
> >  at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> > DelegatingMethodAccessorImpl.java(Compiled Code))
> >  at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
> >  at com.ibatis.common.jdbc.logging.PreparedStatementLogProxy.invoke(
> > PreparedStatementLogProxy.java(Compiled Code))
> >  at $Proxy28.execute(Unknown Source)
> >  at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(
> > SqlExecutor.java(Compiled Code))
> >  at
> > com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery
> > (GeneralStatement.java(Compiled Code))
> >  ... 54 more
> >
> > Caused by:
> > com.ibatis.common.jdbc.exception.NestedSQLException:
> > --- The error occurred in com/myc/fpr/admin/dao/sqlmapdao/User.xml.
> > --- The error occurred while applying a parameter map.
> > --- Check the checkAuthorizedForSecuredItem-InlineParameterMap.
> > --- Check the statement (query failed).
> > --- Cause: java.sql.SQLException: [SQL0802] Data conversion or data
> > mapping error.
> > Caused by: java.sql.SQLException: [SQL0802] Data conversion or data
> > mapping error.
> >  at
> > com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback
> > (GeneralStatement.java(Compiled Code))
> >  at
> > com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForObject
> > (GeneralStatement.java(Compiled Code))
> >  at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(
> > SqlMapExecutorDelegate.java(Compiled Code))
> >  at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(
> > SqlMapExecutorDelegate.java(Inlined Compiled Code))
> >  at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(
> > SqlMapSessionImpl.java(Inlined Compiled Code))
> >  at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(
> > SqlMapClientImpl.java(Compiled Code))
> >  at com.ibatis.dao.client.template.SqlMapDaoTemplate.queryForObject(
> > SqlMapDaoTemplate.java(Compiled Code))
> >  at com.myc.dbaccess.db2.BaseDao.queryForObject(Unknown Source)
> >  at com.myc.fpr.admin.dao.db2.UserDb2DAO.isAuthorizedForSecuredItem(Unknown
> > Source)
> >  at sun.reflect.GeneratedMethodAccessor325.invoke(Unknown Source)
> >  at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> > DelegatingMethodAccessorImpl.java(Compiled Code))
> >  at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
> >  at com.ibatis.dao.engine.impl.DaoProxy.invoke(DaoProxy.java(Compiled
> > Code))
> >  at $Proxy9.isAuthorizedForSecuredItem(Unknown Source)
> >  at
> > com.myc.fpr.security.authorization.AuthorizationService.isUserAuthorizedForSecuredItem(Unknown
> > Source)
> >  at com.myc.fpr.product.action.MethodsAction.show(Unknown Source)
> >  at com.myc.fpr.product.action.MethodsAction.display(Unknown Source)
> >  at sun.reflect.GeneratedMethodAccessor322.invoke(Unknown Source)
> >  at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> > DelegatingMethodAccessorImpl.java(Compiled Code))
> >  at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
> >  at org.apache.struts.actions.DispatchAction.dispatchMethod(
> > DispatchAction.java(Compiled Code))
> >  at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java(Compiled
> > Code))
> >  at org.apache.struts.action.RequestProcessor.processActionPerform(
> > RequestProcessor.java(Inlined Compiled Code))
> >  at org.apache.struts.action.RequestProcessor.process(
> > RequestProcessor.java(Compiled Code))
> >  at org.apache.struts.action.ActionServlet.process(ActionServlet.java(Inlined
> > Compiled Code))
> >  at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java(Compiled
> > Code))
> >  at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled
> > Code))
> >  at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled
> > Code))
> >  at com.ibm.ws.cache.servlet.ServletWrapper.serviceProxied(
> > ServletWrapper.java(Inlined Compiled Code))
> >  at com.ibm.ws.cache.servlet.CacheHook.handleFragment(CacheHook.java(Compiled
> > Code))
> >  at com.ibm.ws.cache.servlet.CacheHook.handleServlet(CacheHook.java(Compiled
> > Code))
> >  at com.ibm.ws.cache.servlet.ServletWrapper.service(ServletWrapper.java(Compiled
> > Code))
> >  at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(
> > ServletWrapper.java(Compiled Code))
> >  at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(
> > ServletWrapper.java(Compiled Code))
> >  at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(
> > WebAppFilterChain.java(Compiled Code))
> >  at com.myc.fpr.security.authorization.AuthorizationFilter.doFilter(Unknown
> > Source)
> >  at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(
> > FilterInstanceWrapper.java(Compiled Code))
> >  at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(
> > WebAppFilterChain.java(Compiled Code))
> >  at com.myc.common.filter.AccessFilter.doFilter(AccessFilter.java(Compiled
> > Code))
> >  at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(
> > FilterInstanceWrapper.java(Compiled Code))
> >  at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(
> > WebAppFilterChain.java(Compiled Code))
> >  at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(
> > WebAppFilterChain.java(Compiled Code))
> >  at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(
> > ServletWrapper.java(Compiled Code))
> >  at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(
> > CacheServletWrapper.java(Compiled Code))
> >  at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java(Compiled
> > Code))
> >  at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(
> > WCChannelLink.java(Compiled Code))
> >  at
> > com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination
> > (HttpInboundLink.java(Compiled Code))
> >  at
> > com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation
> > (HttpInboundLink.java(Compiled Code))
> >  at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(
> > HttpICLReadCallback.java(Compiled Code))
> >  at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(
> > WorkQueueManager.java(Compiled Code))
> >  at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(
> > WorkQueueManager.java(Compiled Code))
> >  at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(
> > WorkQueueManager.java(Compiled Code))
> >  at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(
> > WorkQueueManager.java(Compiled Code))
> >  at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled
> > Code))
> > Caused by: java.sql.SQLException: [SQL0802] Data conversion or data
> > mapping error.
> >  at com.ibm.as400.access.JDError.throwSQLException(JDError.java(Compiled
> > Code))
> >  at com.ibm.as400.access.JDError.throwSQLException(JDError.java(Inlined
> > Compiled Code))
> >  at com.ibm.as400.access.AS400JDBCStatement.commonExecute(
> > AS400JDBCStatement.java(Compiled Code))
> >  at com.ibm.as400.access.AS400JDBCPreparedStatement.execute(
> > AS400JDBCPreparedStatement.java(Compiled Code))
> >  at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecute(
> > WSJdbcPreparedStatement.java(Compiled Code))
> >  at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.execute(
> > WSJdbcPreparedStatement.java(Compiled Code))
> >  at sun.reflect.GeneratedMethodAccessor71.invoke(Unknown Source)
> >  at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> > DelegatingMethodAccessorImpl.java(Compiled Code))
> >  at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
> >  at com.ibatis.common.jdbc.logging.PreparedStatementLogProxy.invoke(
> > PreparedStatementLogProxy.java(Compiled Code))
> >  at $Proxy28.execute(Unknown Source)
> >  at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(
> > SqlExecutor.java(Compiled Code))
> >  at
> > com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery
> > (GeneralStatement.java(Compiled Code))
> >  ... 54 more
> >
> > Caused by:
> > java.sql.SQLException: [SQL0802] Data conversion or data mapping error.
> >  at com.ibm.as400.access.JDError.throwSQLException(JDError.java(Compiled
> > Code))
> >  at com.ibm.as400.access.JDError.throwSQLException(JDError.java(Inlined
> > Compiled Code))
> >  at com.ibm.as400.access.AS400JDBCStatement.commonExecute(
> > AS400JDBCStatement.java(Compiled Code))
> >  at com.ibm.as400.access.AS400JDBCPreparedStatement.execute(
> > AS400JDBCPreparedStatement.java(Compiled Code))
> >  at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecute(
> > WSJdbcPreparedStatement.java(Compiled Code))
> >  at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.execute(
> > WSJdbcPreparedStatement.java(Compiled Code))
> >  at sun.reflect.GeneratedMethodAccessor71.invoke(Unknown Source)
> >  at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> > DelegatingMethodAccessorImpl.java(Compiled Code))
> >  at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
> >  at com.ibatis.common.jdbc.logging.PreparedStatementLogProxy.invoke(
> > PreparedStatementLogProxy.java(Compiled Code))
> >  at $Proxy28.execute(Unknown Source)
> >  at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(
> > SqlExecutor.java(Compiled Code))
> >  at
> > com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery
> > (GeneralStatement.java(Compiled Code))
> >  at
> > com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback
> > (GeneralStatement.java(Compiled Code))
> >  at
> > com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForObject
> > (GeneralStatement.java(Compiled Code))
> >  at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(
> > SqlMapExecutorDelegate.java(Compiled Code))
> >  at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(
> > SqlMapExecutorDelegate.java(Inlined Compiled Code))
> >  at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(
> > SqlMapSessionImpl.java(Inlined Compiled Code))
> >  at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(
> > SqlMapClientImpl.java(Compiled Code))
> >  at com.ibatis.dao.client.template.SqlMapDaoTemplate.queryForObject(
> > SqlMapDaoTemplate.java(Compiled Code))
> >  at com.myc.dbaccess.db2.BaseDao.queryForObject(Unknown Source)
> >  at com.myc.fpr.admin.dao.db2.UserDb2DAO.isAuthorizedForSecuredItem(Unknown
> > Source)
> >  at sun.reflect.GeneratedMethodAccessor325.invoke(Unknown Source)
> >  at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> > DelegatingMethodAccessorImpl.java(Compiled Code))
> >  at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
> >  at com.ibatis.dao.engine.impl.DaoProxy.invoke(DaoProxy.java(Compiled
> > Code))
> >  at $Proxy9.isAuthorizedForSecuredItem(Unknown Source)
> >  at
> > com.myc.fpr.security.authorization.AuthorizationService.isUserAuthorizedForSecuredItem(Unknown
> > Source)
> >  at com.myc.fpr.product.action.MethodsAction.show(Unknown Source)
> >  at com.myc.fpr.product.action.MethodsAction.display(Unknown Source)
> >  at sun.reflect.GeneratedMethodAccessor322.invoke(Unknown Source)
> >  at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> > DelegatingMethodAccessorImpl.java(Compiled Code))
> >  at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
> >  at org.apache.struts.actions.DispatchAction.dispatchMethod(
> > DispatchAction.java(Compiled Code))
> >  at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java(Compiled
> > Code))
> >  at org.apache.struts.action.RequestProcessor.processActionPerform(
> > RequestProcessor.java(Inlined Compiled Code))
> >  at org.apache.struts.action.RequestProcessor.process(
> > RequestProcessor.java(Compiled Code))
> >  at org.apache.struts.action.ActionServlet.process(ActionServlet.java(Inlined
> > Compiled Code))
> >  at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java(Compiled
> > Code))
> >  at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled
> > Code))
> >  at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled
> > Code))
> >  at com.ibm.ws.cache.servlet.ServletWrapper.serviceProxied(
> > ServletWrapper.java(Inlined Compiled Code))
> >  at com.ibm.ws.cache.servlet.CacheHook.handleFragment(CacheHook.java(Compiled
> > Code))
> >  at com.ibm.ws.cache.servlet.CacheHook.handleServlet(CacheHook.java(Compiled
> > Code))
> >  at com.ibm.ws.cache.servlet.ServletWrapper.service(ServletWrapper.java(Compiled
> > Code))
> >  at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(
> > ServletWrapper.java(Compiled Code))
> >  at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(
> > ServletWrapper.java(Compiled Code))
> >  at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(
> > WebAppFilterChain.java(Compiled Code))
> >  at com.myc.fpr.security.authorization.AuthorizationFilter.doFilter(Unknown
> > Source)
> >  at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(
> > FilterInstanceWrapper.java(Compiled Code))
> >  at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(
> > WebAppFilterChain.java(Compiled Code))
> >  at com.myc.common.filter.AccessFilter.doFilter(AccessFilter.java(Compiled
> > Code))
> >  at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(
> > FilterInstanceWrapper.java(Compiled Code))
> >  at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(
> > WebAppFilterChain.java(Compiled Code))
> >  at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(
> > WebAppFilterChain.java(Compiled Code))
> >  at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(
> > ServletWrapper.java(Compiled Code))
> >  at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(
> > CacheServletWrapper.java(Compiled Code))
> >  at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java(Compiled
> > Code))
> >  at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(
> > WCChannelLink.java(Compiled Code))
> >  at
> > com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination
> > (HttpInboundLink.java(Compiled Code))
> >  at
> > com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation
> > (HttpInboundLink.java(Compiled Code))
> >  at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(
> > HttpICLReadCallback.java(Compiled Code))
> >  at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(
> > WorkQueueManager.java(Compiled Code))
> >  at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(
> > WorkQueueManager.java(Compiled Code))
> >  at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(
> > WorkQueueManager.java(Compiled Code))
> >  at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(
> > WorkQueueManager.java(Compiled Code))
> >  at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled
> > Code))
> > 11 Dec 2006 11:52:21 [WebContainer : 6] ERROR
> > com.myc.fpr.utils.FprExceptionHandler ///execute/// - Exception occured
> > ... catched by Handler
> > 11 Dec 2006 11:52:21 [WebContainer : 6] ERROR
> > com.myc.fpr.utils.FprExceptionHandler ///execute/// -
> > com.ibatis.dao.client.DaoException: Failed to execute queryForObject -
> > id [checkAuthorizedForSecuredItem], parameterObject [{secItemId=128,
> > userId=1409, functionId=19}].  Cause:
> > com.ibatis.common.jdbc.exception.NestedSQLException:
> > --- The error occurred in com/myc/fpr/admin/dao/sqlmapdao/User.xml.
> > --- The error occurred while applying a parameter map.
> > --- Check the checkAuthorizedForSecuredItem-InlineParameterMap.
> > --- Check the statement (query failed).
> > --- Cause: java.sql.SQLException: [SQL0802] Data conversion or data
> > mapping error.
> > Caused by: java.sql.SQLException: [SQL0802] Data conversion or data
> > mapping error.
> > Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
> > --- The error occurred in com/myc/fpr/admin/dao/sqlmapdao/User.xml.
> > --- The error occurred while applying a parameter map.
> > --- Check the checkAuthorizedForSecuredItem-InlineParameterMap.
> > --- Check the statement (query failed).
> > --- Cause: java.sql.SQLException: [SQL0802] Data conversion or data
> > mapping error.
> > Caused by: java.sql.SQLException: [SQL0802] Data conversion or data
> > mapping error.
> > com.myc.dbaccess.DBException: com.ibatis.dao.client.DaoException: Failed
> > to execute queryForObject - id [checkAuthorizedForSecuredItem],
> > parameterObject [{secItemId=128, userId=1409, functionId=19}].  Cause:
> > com.ibatis.common.jdbc.exception.NestedSQLException:
> > --- The error occurred in com/myc/fpr/admin/dao/sqlmapdao/User.xml.
> > --- The error occurred while applying a parameter map.
> > --- Check the checkAuthorizedForSecuredItem-InlineParameterMap.
> > --- Check the statement (query failed).
> > --- Cause: java.sql.SQLException: [SQL0802] Data conversion or data
> > mapping error.
> > Caused by: java.sql.SQLException: [SQL0802] Data conversion or data
> > mapping error.
> > Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
> > --- The error occurred in com/myc/fpr/admin/dao/sqlmapdao/User.xml.
> > --- The error occurred while applying a parameter map.
> > --- Check the checkAuthorizedForSecuredItem-InlineParameterMap.
> > --- Check the statement (query failed).
> > --- Cause: java.sql.SQLException: [SQL0802] Data conversion or data
> > mapping error.
> > Caused by: java.sql.SQLException: [SQL0802] Data conversion or data
> > mapping error.
> >  at com.myc.dbaccess.DB2ExceptionDecoder.throwDecodedException(Unknown
> > Source)
> >  at com.myc.dbaccess.DB2ExceptionDecoder.throwDecodedException(Unknown
> > Source)
> >  at com.myc.dbaccess.db2.BaseDao.queryForObject(Unknown Source)
> >  at com.myc.fpr.admin.dao.db2.UserDb2DAO.isAuthorizedForSecuredItem(Unknown
> > Source)
> >  at sun.reflect.GeneratedMethodAccessor325.invoke(Unknown Source)
> >  at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> > DelegatingMethodAccessorImpl.java(Compiled Code))
> >  at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
> >  at com.ibatis.dao.engine.impl.DaoProxy.invoke(DaoProxy.java(Compiled
> > Code))
> >  at $Proxy9.isAuthorizedForSecuredItem(Unknown Source)
> >  at
> > com.myc.fpr.security.authorization.AuthorizationService.isUserAuthorizedForSecuredItem(Unknown
> > Source)
> >  at com.myc.fpr.product.action.MethodsAction.show(Unknown Source)
> >  at com.myc.fpr.product.action.MethodsAction.display(Unknown Source)
> >  at sun.reflect.GeneratedMethodAccessor322.invoke(Unknown Source)
> >  at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> > DelegatingMethodAccessorImpl.java(Compiled Code))
> >  at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
> >  at org.apache.struts.actions.DispatchAction.dispatchMethod(
> > DispatchAction.java(Compiled Code))
> >  at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java(Compiled
> > Code))
> >  at org.apache.struts.action.RequestProcessor.processActionPerform(
> > RequestProcessor.java(Inlined Compiled Code))
> >  at org.apache.struts.action.RequestProcessor.process(
> > RequestProcessor.java(Compiled Code))
> >  at org.apache.struts.action.ActionServlet.process(ActionServlet.java(Inlined
> > Compiled Code))
> >  at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java(Compiled
> > Code))
> >  at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled
> > Code))
> >  at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled
> > Code))
> >  at com.ibm.ws.cache.servlet.ServletWrapper.serviceProxied(
> > ServletWrapper.java(Inlined Compiled Code))
> >  at com.ibm.ws.cache.servlet.CacheHook.handleFragment(CacheHook.java(Compiled
> > Code))
> >  at com.ibm.ws.cache.servlet.CacheHook.handleServlet(CacheHook.java(Compiled
> > Code))
> >  at com.ibm.ws.cache.servlet.ServletWrapper.service(ServletWrapper.java(Compiled
> > Code))
> >  at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(
> > ServletWrapper.java(Compiled Code))
> >  at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(
> > ServletWrapper.java(Compiled Code))
> >  at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(
> > WebAppFilterChain.java(Compiled Code))
> >  at com.myc.fpr.security.authorization.AuthorizationFilter.doFilter(Unknown
> > Source)
> >  at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(
> > FilterInstanceWrapper.java(Compiled Code))
> >  at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(
> > WebAppFilterChain.java(Compiled Code))
> >  at com.myc.common.filter.AccessFilter.doFilter(AccessFilter.java(Compiled
> > Code))
> >  at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(
> > FilterInstanceWrapper.java(Compiled Code))
> >  at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(
> > WebAppFilterChain.java(Compiled Code))
> >  at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(
> > WebAppFilterChain.java(Compiled Code))
> >  at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(
> > ServletWrapper.java(Compiled Code))
> >  at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(
> > CacheServletWrapper.java(Compiled Code))
> >  at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java(Compiled
> > Code))
> >  at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(
> > WCChannelLink.java(Compiled Code))
> >  at
> > com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination
> > (HttpInboundLink.java(Compiled Code))
> >  at
> > com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation
> > (HttpInboundLink.java(Compiled Code))
> >  at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(
> > HttpICLReadCallback.java(Compiled Code))
> >  at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(
> > WorkQueueManager.java(Compiled Code))
> >  at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(
> > WorkQueueManager.java(Compiled Code))
> >  at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(
> > WorkQueueManager.java(Compiled Code))
> >  at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(
> > WorkQueueManager.java(Compiled Code))
> >  at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled
> > Code))
> > Caused by: com.ibatis.dao.client.DaoException: Failed to execute
> > queryForObject - id [checkAuthorizedForSecuredItem], parameterObject
> > [{secItemId=128, userId=1409, functionId=19}].  Cause:
> > com.ibatis.common.jdbc.exception.NestedSQLException:
> > --- The error occurred in com/myc/fpr/admin/dao/sqlmapdao/User.xml.
> > --- The error occurred while applying a parameter map.
> > --- Check the checkAuthorizedForSecuredItem-InlineParameterMap.
> > --- Check the statement (query failed).
> > --- Cause: java.sql.SQLException: [SQL0802] Data conversion or data
> > mapping error.
> > Caused by: java.sql.SQLException: [SQL0802] Data conversion or data
> > mapping error.
> > Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
> > --- The error occurred in com/myc/fpr/admin/dao/sqlmapdao/User.xml.
> > --- The error occurred while applying a parameter map.
> > --- Check the checkAuthorizedForSecuredItem-InlineParameterMap.
> > --- Check the statement (query failed).
> > --- Cause: java.sql.SQLException: [SQL0802] Data conversion or data
> > mapping error.
> > Caused by: java.sql.SQLException: [SQL0802] Data conversion or data
> > mapping error.
> >  at com.ibatis.dao.client.template.SqlMapDaoTemplate.queryForObject(
> > SqlMapDaoTemplate.java(Compiled Code))
> >  ... 47 more
> > Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
> > --- The error occurred in com/myc/fpr/admin/dao/sqlmapdao/User.xml.
> > --- The error occurred while applying a parameter map.
> > --- Check the checkAuthorizedForSecuredItem-InlineParameterMap.
> > --- Check the statement (query failed).
> > --- Cause: java.sql.SQLException: [SQL0802] Data conversion or data
> > mapping error.
> > Caused by: java.sql.SQLException: [SQL0802] Data conversion or data
> > mapping error.
> >  at
> > com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback
> > (GeneralStatement.java(Compiled Code))
> >  at
> > com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForObject
> > (GeneralStatement.java(Compiled Code))
> >  at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(
> > SqlMapExecutorDelegate.java(Compiled Code))
> >  at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(
> > SqlMapExecutorDelegate.java(Inlined Compiled Code))
> >  at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(
> > SqlMapSessionImpl.java(Inlined Compiled Code))
> >  at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(
> > SqlMapClientImpl.java(Compiled Code))
> >  ... 48 more
> > Caused by: java.sql.SQLException: [SQL0802] Data conversion or data
> > mapping error.
> >  at com.ibm.as400.access.JDError.throwSQLException(JDError.java(Compiled
> > Code))
> >  at com.ibm.as400.access.JDError.throwSQLException(JDError.java(Inlined
> > Compiled Code))
> >  at com.ibm.as400.access.AS400JDBCStatement.commonExecute(
> > AS400JDBCStatement.java(Compiled Code))
> >  at com.ibm.as400.access.AS400JDBCPreparedStatement.execute(
> > AS400JDBCPreparedStatement.java(Compiled Code))
> >  at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecute(
> > WSJdbcPreparedStatement.java(Compiled Code))
> >  at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.execute(
> > WSJdbcPreparedStatement.java(Compiled Code))
> >  at sun.reflect.GeneratedMethodAccessor71.invoke(Unknown Source)
> >  at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> > DelegatingMethodAccessorImpl.java(Compiled Code))
> >  at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
> >  at com.ibatis.common.jdbc.logging.PreparedStatementLogProxy.invoke(
> > PreparedStatementLogProxy.java(Compiled Code))
> >  at $Proxy28.execute(Unknown Source)
> >  at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(
> > SqlExecutor.java(Compiled Code))
> >  at
> > com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery
> > (GeneralStatement.java(Compiled Code))
> >  ... 54 more
> >
> >
> > Thank you,
> > Cornel
> >
> > ----- Original Message -----
> > *From:* Brandon Goodin <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