Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 68737 invoked from network); 13 Dec 2006 17:49:03 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 13 Dec 2006 17:49:03 -0000 Received: (qmail 48060 invoked by uid 500); 13 Dec 2006 17:49:07 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 48038 invoked by uid 500); 13 Dec 2006 17:49:07 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 48026 invoked by uid 99); 13 Dec 2006 17:49:07 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 13 Dec 2006 09:49:07 -0800 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: domain of larry.meadors@gmail.com designates 64.233.184.239 as permitted sender) Received: from [64.233.184.239] (HELO wr-out-0506.google.com) (64.233.184.239) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 13 Dec 2006 09:48:57 -0800 Received: by wr-out-0506.google.com with SMTP id i28so232326wra for ; Wed, 13 Dec 2006 09:48:36 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:sender:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references:x-google-sender-auth; b=Sd/3+U1dTzV2e+LDIQKlJLi5YUYfMxeJQDRh+tL6+Pkc8NSJRSVC+cwW0/6VMMXgqgbBWHROsKvtudolBDAsM1HBPf0BUUCs1VbOgbqATndDHUuXKIzy6NizjpsdFhIvPLOrv6LQzUH0cL+bPa7t0fKvTiDSO8GGGUgoP0WMJEw= Received: by 10.90.25.7 with SMTP id 7mr1061222agy.1166032116266; Wed, 13 Dec 2006 09:48:36 -0800 (PST) Received: by 10.90.35.4 with HTTP; Wed, 13 Dec 2006 09:48:36 -0800 (PST) Message-ID: Date: Wed, 13 Dec 2006 10:48:36 -0700 From: "Larry Meadors" Reply-To: lmeadors@apache.org Sender: larry.meadors@gmail.com To: user-java@ibatis.apache.org Subject: Re: Data conversion or data mapping error. In-Reply-To: <012a01c71eda$190fd400$0d10a8c0@coan> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <017801c71de9$a4e7d230$0d10a8c0@coan> <2fe5ef5b0612120727q8ad8347gb33576bbc14f83af@mail.gmail.com> <012a01c71eda$190fd400$0d10a8c0@coan> X-Google-Sender-Auth: 785e5aadc89f4cfb X-Virus-Checked: Checked by ClamAV on 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 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 ////// - 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 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: > > > > > > > > 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 > > > > > >