You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by Cornel Antohi <ca...@kepler-rominfo.com> on 2006/12/12 13:32:53 UTC
Data conversion or data mapping error.
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
Re: Data conversion or data mapping error.
Posted by Cornel Antohi <ca...@kepler-rominfo.com>.
He,
Yes, I am using AS/400 V5R3 and Java Long ... AS/400 fields are NUMBER(12). This works fine in so many cases of my application but only during the heavy load it crashes for only this specific query!
I also think that it may be a JDBC Driver - AS/400 issue and not related to iBatis ...
Thank you,
Cornel
----- Original Message -----
From: Jeff Butler
To: user-java@ibatis.apache.org
Sent: Wednesday, December 13, 2006 7:57 PM
Subject: Re: Data conversion or data mapping error.
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 <br...@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
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
Re: Data conversion or data mapping error.
Posted by Cornel Antohi <ca...@kepler-rominfo.com>.
Hi,
After searching more on AS/400 side, here is the SQLState associated to the SQLError 0802:
Sqlstate = 22003 (A numeric value is out of range and division by zero is invalid.)
Thank you,
Cornel
----- Original Message -----
From: Jeff Butler
To: user-java@ibatis.apache.org
Sent: Wednesday, December 13, 2006 7:57 PM
Subject: Re: Data conversion or data mapping error.
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 <br...@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
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
Re: Data conversion or data mapping error.
Posted by Jeff Butler <je...@gmail.com>.
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 <br...@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 <ca...@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 <br...@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
> > >
> > >
> > >
> >
> >
>
Re: Data conversion or data mapping error.
Posted by Cornel Antohi <ca...@kepler-rominfo.com>.
This failure happening from time to time under the heavy load.The same query is well executed and from time to time it crashes ... not always with the same set of parameters ... I cannot find a pattern to say that it crashes always with a defined list of parameters.
One more information ... after the heavy load ends, if I am trying to execute the same application functionality (so executing the same query with same parameters as the ones when it crashes) it works fine ...
Thank you,
Cornel
----- Original Message -----
From: Brandon Goodin
To: user-java@ibatis.apache.org
Sent: Wednesday, December 13, 2006 7:50 PM
Subject: Re: Data conversion or data mapping error.
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 <ca...@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
Re: Data conversion or data mapping error.
Posted by Brandon Goodin <br...@gmail.com>.
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 <ca...@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 <br...@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
> >
> >
>
Re: Data conversion or data mapping error.
Posted by Larry Meadors <lm...@apache.org>.
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 <ca...@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
> >
> >
>
>
Re: Data conversion or data mapping error.
Posted by Cornel Antohi <ca...@kepler-rominfo.com>.
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
Re: Data conversion or data mapping error.
Posted by Brandon Goodin <br...@gmail.com>.
Can you post the parameterized SQL as well?
Brandon
On 12/12/06, Cornel Antohi <ca...@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
>
>