Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 77954 invoked from network); 13 Dec 2006 18:16:59 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 13 Dec 2006 18:16:59 -0000 Received: (qmail 15740 invoked by uid 500); 13 Dec 2006 18:17:03 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 15728 invoked by uid 500); 13 Dec 2006 18:17:03 -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 15717 invoked by uid 99); 13 Dec 2006 18:17:03 -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 10:17:03 -0800 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE X-Spam-Check-By: apache.org Received-SPF: neutral (herse.apache.org: local policy) Received: from [217.156.99.222] (HELO relay.kepler-rominfo.com) (217.156.99.222) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 13 Dec 2006 10:16:53 -0800 Received: from localhost (mail.kepler.ro [127.0.0.1]) by mail.kepler-rominfo.com (Postfix) with ESMTP id BEA9DB8E for ; Wed, 13 Dec 2006 20:16:28 +0200 (EET) X-Virus-Scanned: Debian amavisd-new at kepler-rominfo.com Received: from relay.kepler-rominfo.com ([127.0.0.1]) by localhost (mail.kepler.ro [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id DgXSnCWt3X4d for ; Wed, 13 Dec 2006 20:16:28 +0200 (EET) Received: from coan (unknown [192.168.16.13]) by mail.kepler-rominfo.com (Postfix) with SMTP id 70E2FB2 for ; Wed, 13 Dec 2006 20:16:28 +0200 (EET) Message-ID: <002201c71ee2$cb75ddd0$0d10a8c0@coan> From: "Cornel Antohi" To: References: <017801c71de9$a4e7d230$0d10a8c0@coan> <2fe5ef5b0612120727q8ad8347gb33576bbc14f83af@mail.gmail.com> <012a01c71eda$190fd400$0d10a8c0@coan> <2fe5ef5b0612130950w19b3f068re5350c2b558ad922@mail.gmail.com> Subject: Re: Data conversion or data mapping error. Date: Wed, 13 Dec 2006 20:16:22 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_001F_01C71EF3.8EF9F2E0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2869 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962 X-Virus-Checked: Checked by ClamAV on apache.org This is a multi-part message in MIME format. ------=_NextPart_000_001F_01C71EF3.8EF9F2E0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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 -----=20 From: Jeff Butler=20 To: user-java@ibatis.apache.org=20 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.=20 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 =20 On 12/13/06, Brandon Goodin wrote:=20 Thanks for the additional information. Is this failure happening = consistently with the set of parameters that you are displaying = (128,1409,19=20 )? 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.=20 =20 On 12/13/06, Cornel Antohi wrote:=20 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=3D? and USER_ID=3D? and = FN_ID=3D? =20 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=3D1165834341289 Failed to execute queryForObject - id = [checkAuthorizedForSecuredItem], parameterObject [{secItemId=3D128, = userId=3D1409, functionId=3D19}]. Cause: = com.ibatis.common.jdbc.exception.NestedSQLException: =20 --- The error occurred in = com/myc/fpr/admin/dao/sqlmapdao/User.xml. =20 --- The error occurred while applying a parameter map. =20 --- Check the checkAuthorizedForSecuredItem-InlineParameterMap. =20 --- Check the statement (query failed). =20 --- 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=3D128, userId=3D1409, functionId=3D19}]. Cause: = com.ibatis.common.jdbc.exception.NestedSQLException : =20 --- The error occurred in = com/myc/fpr/admin/dao/sqlmapdao/User.xml. =20 --- The error occurred while applying a parameter map. =20 --- Check the checkAuthorizedForSecuredItem-InlineParameterMap. =20 --- Check the statement (query failed). =20 --- 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. =20 --- The error occurred while applying a parameter map. =20 --- Check the checkAuthorizedForSecuredItem-InlineParameterMap. =20 --- Check the statement (query failed). =20 --- 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(SqlMapDao= Template.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(DelegatingMethodAccessorI= mpl.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.isUserAuthorizedF= orSecuredItem (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)=20 at = sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI= mpl.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(Comp= iled Code)) at = org.apache.struts.action.RequestProcessor.processActionPerform(RequestPro= cessor.java(Inlined Compiled Code))=20 at = org.apache.struts.action.RequestProcessor.process(RequestProcessor.java(C= ompiled 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(Compi= led Code)) at = com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.jav= a(Compiled Code)) at com.ibm.ws.webcontainer.servlet.ServletWrapper.service = (ServletWrapper.java(Compiled Code)) at = com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterCha= in.java(Compiled Code)) at = com.myc.fpr.security.authorization.AuthorizationFilter.doFilter(Unknown = Source)=20 at = com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInsta= nceWrapper.java(Compiled Code)) at = com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterCha= in.java(Compiled Code)) at = com.myc.common.filter.AccessFilter.doFilter(AccessFilter.java(Compiled = Code)) at = com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInsta= nceWrapper.java(Compiled Code)) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter = (WebAppFilterChain.java(Compiled Code)) at = com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterCh= ain.java(Compiled Code)) at = com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapp= er.java (Compiled Code)) at = com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheSe= rvletWrapper.java(Compiled Code)) at = com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java(Comp= iled Code))=20 at = com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java(Co= mpiled 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(HttpICL= ReadCallback.java(Compiled Code)) at = com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueMan= ager.java (Compiled Code)) at = com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.j= ava(Compiled Code)) at = com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.j= ava(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. =20 --- The error occurred while applying a parameter map. =20 --- Check the checkAuthorizedForSecuredItem-InlineParameterMap. =20 --- Check the statement (query failed). =20 --- 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.executeQueryW= ithCallback(GeneralStatement.java(Compiled Code)) at = com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryF= orObject(GeneralStatement.java (Compiled Code)) at = com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMa= pExecutorDelegate.java(Compiled Code)) at = com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMa= pExecutorDelegate.java (Inlined Compiled Code)) at = com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSess= ionImpl.java(Inlined Compiled Code)) at = com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClien= tImpl.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(WSJdbcPrepar= edStatement.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(DelegatingMethodAccessorI= mpl.java(Compiled Code)) at java.lang.reflect.Method.invoke(Method.java(Compiled Code)) at = com.ibatis.common.jdbc.logging.PreparedStatementLogProxy.invoke(PreparedS= tatementLogProxy.java(Compiled Code)) at $Proxy28.execute(Unknown Source)=20 at = com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.j= ava(Compiled Code)) at = com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQue= ry(GeneralStatement.java(Compiled Code))=20 ... 54 more Caused by:=20 com.ibatis.common.jdbc.exception.NestedSQLException: =20 --- The error occurred in = com/myc/fpr/admin/dao/sqlmapdao/User.xml. =20 --- The error occurred while applying a parameter map. =20 --- Check the checkAuthorizedForSecuredItem-InlineParameterMap. =20 --- Check the statement (query failed). =20 --- 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.executeQueryW= ithCallback(GeneralStatement.java(Compiled Code)) at = com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryF= orObject (GeneralStatement.java(Compiled Code)) at = com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMa= pExecutorDelegate.java(Compiled Code)) at = com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject = (SqlMapExecutorDelegate.java(Inlined Compiled Code)) at = com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSess= ionImpl.java(Inlined Compiled Code)) at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject = (SqlMapClientImpl.java(Compiled Code)) at = com.ibatis.dao.client.template.SqlMapDaoTemplate.queryForObject(SqlMapDao= Template.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(DelegatingMethodAccessorI= mpl.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)=20 at = com.myc.fpr.security.authorization.AuthorizationService.isUserAuthorizedF= orSecuredItem(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(DelegatingMethodAccessorI= mpl.java(Compiled Code)) at java.lang.reflect.Method.invoke (Method.java(Compiled Code)) at = org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.ja= va(Compiled Code)) at = org.apache.struts.actions.DispatchAction.execute(DispatchAction.java(Comp= iled Code)) at = org.apache.struts.action.RequestProcessor.processActionPerform(RequestPro= cessor.java(Inlined Compiled Code)) at = org.apache.struts.action.RequestProcessor.process(RequestProcessor.java(C= ompiled 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.jav= a(Inlined Compiled Code)) at = com.ibm.ws.cache.servlet.CacheHook.handleFragment(CacheHook.java(Compiled= Code))=20 at = com.ibm.ws.cache.servlet.CacheHook.handleServlet(CacheHook.java(Compiled = Code)) at = com.ibm.ws.cache.servlet.ServletWrapper.service(ServletWrapper.java(Compi= led Code)) at com.ibm.ws.webcontainer.servlet.ServletWrapper.service = (ServletWrapper.java(Compiled Code)) at = com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.jav= a(Compiled Code)) at = com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterCha= in.java (Compiled Code)) at = com.myc.fpr.security.authorization.AuthorizationFilter.doFilter(Unknown = Source) at = com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInsta= nceWrapper.java(Compiled Code)) at = com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterCha= in.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(WebAppFilterCha= in.java(Compiled Code)) at = com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterCh= ain.java (Compiled Code)) at = com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapp= er.java(Compiled Code)) at = com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheSe= rvletWrapper.java(Compiled Code))=20 at = com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java(Comp= iled Code)) at = com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java(Co= mpiled 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(WorkQueueMan= ager.java(Compiled Code)) at = com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.j= ava (Compiled Code)) at = com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.j= ava(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))=20 at = com.ibm.as400.access.AS400JDBCPreparedStatement.execute(AS400JDBCPrepared= Statement.java(Compiled Code)) at = com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecute(WSJdbcPrepar= edStatement.java(Compiled Code))=20 at = com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.execute(WSJdbcPreparedS= tatement.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(PreparedS= tatementLogProxy.java(Compiled Code))=20 at $Proxy28.execute(Unknown Source) at = com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.j= ava(Compiled Code)) at = com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQue= ry (GeneralStatement.java(Compiled Code)) ... 54 more Caused by:=20 java.sql.SQLException: [SQL0802] Data conversion or data mapping = error. at = com.ibm.as400.access.JDError.throwSQLException(JDError.java(Compiled = Code))=20 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(WSJdbcPrepar= edStatement.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(DelegatingMethodAccessorI= mpl.java(Compiled Code)) at java.lang.reflect.Method.invoke(Method.java(Compiled Code)) at = com.ibatis.common.jdbc.logging.PreparedStatementLogProxy.invoke(PreparedS= tatementLogProxy.java(Compiled Code)) at $Proxy28.execute(Unknown Source)=20 at = com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.j= ava(Compiled Code)) at = com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQue= ry(GeneralStatement.java(Compiled Code))=20 at = com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryW= ithCallback(GeneralStatement.java(Compiled Code)) at = com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryF= orObject(GeneralStatement.java (Compiled Code)) at = com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMa= pExecutorDelegate.java(Compiled Code)) at = com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMa= pExecutorDelegate.java (Inlined Compiled Code)) at = com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSess= ionImpl.java(Inlined Compiled Code)) at = com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClien= tImpl.java (Compiled Code)) at = com.ibatis.dao.client.template.SqlMapDaoTemplate.queryForObject(SqlMapDao= Template.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(DelegatingMethodAccessorI= mpl.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.isUserAuthorizedF= orSecuredItem (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)=20 at = sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI= mpl.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(Comp= iled Code)) at = org.apache.struts.action.RequestProcessor.processActionPerform(RequestPro= cessor.java(Inlined Compiled Code))=20 at = org.apache.struts.action.RequestProcessor.process(RequestProcessor.java(C= ompiled 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(Compi= led Code)) at = com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.jav= a(Compiled Code)) at com.ibm.ws.webcontainer.servlet.ServletWrapper.service = (ServletWrapper.java(Compiled Code)) at = com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterCha= in.java(Compiled Code)) at = com.myc.fpr.security.authorization.AuthorizationFilter.doFilter(Unknown = Source)=20 at = com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInsta= nceWrapper.java(Compiled Code)) at = com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterCha= in.java(Compiled Code)) at = com.myc.common.filter.AccessFilter.doFilter(AccessFilter.java(Compiled = Code)) at = com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInsta= nceWrapper.java(Compiled Code)) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter = (WebAppFilterChain.java(Compiled Code)) at = com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterCh= ain.java(Compiled Code)) at = com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapp= er.java (Compiled Code)) at = com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheSe= rvletWrapper.java(Compiled Code)) at = com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java(Comp= iled Code))=20 at = com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java(Co= mpiled 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(HttpICL= ReadCallback.java(Compiled Code)) at = com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueMan= ager.java (Compiled Code)) at = com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.j= ava(Compiled Code)) at = com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.j= ava(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=3D128, = userId=3D1409, functionId=3D19}]. Cause: = com.ibatis.common.jdbc.exception.NestedSQLException: =20 --- The error occurred in = com/myc/fpr/admin/dao/sqlmapdao/User.xml. =20 --- The error occurred while applying a parameter map. =20 --- Check the checkAuthorizedForSecuredItem-InlineParameterMap. =20 --- Check the statement (query failed). =20 --- 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: =20 --- The error occurred in = com/myc/fpr/admin/dao/sqlmapdao/User.xml. =20 --- The error occurred while applying a parameter map. =20 --- Check the checkAuthorizedForSecuredItem-InlineParameterMap. =20 --- Check the statement (query failed). =20 --- 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=3D128, userId=3D1409, functionId=3D19}]. = Cause: com.ibatis.common.jdbc.exception.NestedSQLException : =20 --- The error occurred in = com/myc/fpr/admin/dao/sqlmapdao/User.xml. =20 --- The error occurred while applying a parameter map. =20 --- Check the checkAuthorizedForSecuredItem-InlineParameterMap. =20 --- Check the statement (query failed). =20 --- 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. =20 --- The error occurred while applying a parameter map. =20 --- Check the checkAuthorizedForSecuredItem-InlineParameterMap. =20 --- Check the statement (query failed). =20 --- 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)=20 at = com.myc.fpr.admin.dao.db2.UserDb2DAO.isAuthorizedForSecuredItem(Unknown = Source) at sun.reflect.GeneratedMethodAccessor325.invoke(Unknown Source) at = sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI= mpl.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)=20 at = com.myc.fpr.security.authorization.AuthorizationService.isUserAuthorizedF= orSecuredItem(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(DelegatingMethodAccessorI= mpl.java(Compiled Code)) at java.lang.reflect.Method.invoke (Method.java(Compiled Code)) at = org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.ja= va(Compiled Code)) at = org.apache.struts.actions.DispatchAction.execute(DispatchAction.java(Comp= iled Code)) at = org.apache.struts.action.RequestProcessor.processActionPerform(RequestPro= cessor.java(Inlined Compiled Code)) at = org.apache.struts.action.RequestProcessor.process(RequestProcessor.java(C= ompiled 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.jav= a(Inlined Compiled Code)) at = com.ibm.ws.cache.servlet.CacheHook.handleFragment(CacheHook.java(Compiled= Code))=20 at = com.ibm.ws.cache.servlet.CacheHook.handleServlet(CacheHook.java(Compiled = Code)) at = com.ibm.ws.cache.servlet.ServletWrapper.service(ServletWrapper.java(Compi= led Code)) at com.ibm.ws.webcontainer.servlet.ServletWrapper.service = (ServletWrapper.java(Compiled Code)) at = com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.jav= a(Compiled Code)) at = com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterCha= in.java (Compiled Code)) at = com.myc.fpr.security.authorization.AuthorizationFilter.doFilter(Unknown = Source) at = com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInsta= nceWrapper.java(Compiled Code)) at = com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterCha= in.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(WebAppFilterCha= in.java(Compiled Code)) at = com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterCh= ain.java (Compiled Code)) at = com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapp= er.java(Compiled Code)) at = com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheSe= rvletWrapper.java(Compiled Code))=20 at = com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java(Comp= iled Code)) at = com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java(Co= mpiled 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(WorkQueueMan= ager.java(Compiled Code)) at = com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.j= ava (Compiled Code)) at = com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.j= ava(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=3D128, userId=3D1409, functionId=3D19}]. Cause: = com.ibatis.common.jdbc.exception.NestedSQLException: =20 --- The error occurred in = com/myc/fpr/admin/dao/sqlmapdao/User.xml. =20 --- The error occurred while applying a parameter map. =20 --- Check the checkAuthorizedForSecuredItem-InlineParameterMap. =20 --- Check the statement (query failed). =20 --- 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: =20 --- The error occurred in = com/myc/fpr/admin/dao/sqlmapdao/User.xml. =20 --- The error occurred while applying a parameter map. =20 --- Check the checkAuthorizedForSecuredItem-InlineParameterMap. =20 --- Check the statement (query failed). =20 --- 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(SqlMapDao= Template.java(Compiled Code)) ... 47 more Caused by: com.ibatis.common.jdbc.exception.NestedSQLException: =20 --- The error occurred in = com/myc/fpr/admin/dao/sqlmapdao/User.xml. =20 --- The error occurred while applying a parameter map. =20 --- Check the checkAuthorizedForSecuredItem-InlineParameterMap. =20 --- Check the statement (query failed). =20 --- Cause: java.sql.SQLException: [SQL0802] Data conversion or = data mapping error.=20 Caused by: java.sql.SQLException: [SQL0802] Data conversion or = data mapping error. at = com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryW= ithCallback(GeneralStatement.java(Compiled Code))=20 at = com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryF= orObject(GeneralStatement.java(Compiled Code)) at = com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMa= pExecutorDelegate.java (Compiled Code)) at = com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMa= pExecutorDelegate.java(Inlined Compiled Code)) at = com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSess= ionImpl.java (Inlined Compiled Code)) at = com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClien= tImpl.java(Compiled Code)) ... 48 more Caused by: java.sql.SQLException: [SQL0802] Data conversion or = data mapping error.=20 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(AS400JDBCPrepared= Statement.java(Compiled Code)) at = com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecute(WSJdbcPrepar= edStatement.java (Compiled Code)) at = com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.execute(WSJdbcPreparedS= tatement.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(PreparedS= tatementLogProxy.java(Compiled Code))=20 at $Proxy28.execute(Unknown Source) at = com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.j= ava(Compiled Code)) at = com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQue= ry (GeneralStatement.java(Compiled Code)) ... 54 more Thank you, Cornel ----- Original Message -----=20 From: Brandon Goodin=20 To: user-java@ibatis.apache.org=20 Sent: Tuesday, December 12, 2006 5:27 PM Subject: Re: Data conversion or data mapping error. =20 Can you post the parameterized SQL as well? Brandon On 12/12/06, Cornel Antohi wrote:=20 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.=20 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 ...=20 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=3D152, userId=3D1316, functionId=3D19}]. = Cause: com.ibatis.common.jdbc.exception.NestedSQLException: =20 --- The error occurred in com/admin/dao/sqlmapdao/User.xml. =20 --- The error occurred while applying a parameter map. =20 --- Check the = checkAuthorizedForSecuredItem-InlineParameterMap. =20 --- Check the statement (query failed). =20 --- Cause: java.sql.SQLException: [SQL0802] Data conversion or = data mapping error.=20 Caused by: java.sql.SQLException: [SQL0802] Data conversion or = data mapping error.=20 Caused by: = com.ibatis.common.jdbc.exception.NestedSQLException: =20 --- The error occurred in com/admin/dao/sqlmapdao/User.xml. =20 --- The error occurred while applying a parameter map. =20 --- Check the = checkAuthorizedForSecuredItem-InlineParameterMap. =20 --- Check the statement (query failed). =20 --- Cause: java.sql.SQLException: [SQL0802] Data conversion or = data mapping error.=20 Query:=20 =20 Params:=20 [{secItemId=3D152, userId=3D1316, functionId=3D19}]=20 [{secItemId=3D152, userId=3D1017, functionId=3D19}]=20 [{secItemId=3D131, userId=3D1055, functionId=3D19}]=20 [{secItemId=3D140, userId=3D1321, functionId=3D19}]=20 ...=20 =20 Do you have any clue for this problem? Any help is highly appreciated! Thank you, Cornel =20 ------=_NextPart_000_001F_01C71EF3.8EF9F2E0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
He,
 
Yes, I am using AS/400 V5R3 and Java = Long ...=20 AS/400 fields are NUMBER(12). This works fine in so many cases of my = application=20 but only during the heavy load it crashes for only this specific=20 query!
 
I also think that it may be a JDBC = Driver -=20 AS/400 issue and not related to iBatis ...
 
Thank you,
Cornel
 
----- Original Message -----
From:=20 Jeff=20 Butler
Sent: Wednesday, December 13, = 2006 7:57=20 PM
Subject: Re: Data conversion or = data=20 mapping error.

Here's my 2 cents...
 
You're using AS/400 and Java Long data type.  Those two = don't=20 normally go together.  My guess is that the AS/400 fields are = packed=20 decimal.  Try using BigDecimal as parameters instead of Longs to = see if=20 it makes a difference.  There are some driver properties related = to=20 decimal conversion too IIRC.
 
Also, if there are any strings in the result set, make sure that = the=20 CCSID is set correctly in the dirver to match what's on the system - = this=20 could be the source of translation problems too.
 
Jeff Butler


 
On 12/13/06, Brandon=20 Goodin <brandon.goodin@gmail.com>= =20 wrote:=20
Thanks=20 for the additional information. Is this failure happening = consistently with=20 the set of parameters that you are displaying (128,1409,19
)? or = just=20 under heavy load? On the front this looks like it may be a driver = issue. One=20 other thought is to upgraded to 2.2.0 and see if that makes a = difference. I=20 doubt it will. But, it is always a default action of mine to try the = latest=20 and greatest.=20


 
On 12/13/06, Cornel=20 Antohi <cantohi@kepler-rominfo.com > wrote:=20
Hello,
 
Here are more log = info:
 
// STATEMENTS //
 
11 Dec 2006 = 11:52:21=20 [WebContainer : 6] DEBUG java.sql.PreparedStatement ///java/// -=20 {pstm-195813} PreparedStatement:     select 1 = from=20 SEC_FN_USR      where SEC_ID=3D? and = USER_ID=3D? and=20 FN_ID=3D?   
11 Dec 2006 11:52:21 [WebContainer = : 6]=20 DEBUG java.sql.PreparedStatement ///java/// - {pstm-195813} = Parameters:=20 [128, 1409, 19]
11 Dec 2006 11:52:21 [WebContainer : 6] DEBUG=20 java.sql.PreparedStatement ///java/// - {pstm-195813} Types: [=20 java.lang.Long, java.lang.Long, java.lang.Long]
 
// App Logs //
 
11 Dec 2006 = 11:52:21=20 [WebContainer : 6] ERROR com.myc.exceptions.SystemException=20 ///<init>/// - Error id=3D1165834341289
Failed to execute = queryForObject - id [checkAuthorizedForSecuredItem], = parameterObject=20 [{secItemId=3D128, userId=3D1409, functionId=3D19}].  Cause:=20 com.ibatis.common.jdbc.exception.NestedSQLException:   =
---=20 The error occurred in = com/myc/fpr/admin/dao/sqlmapdao/User.xml. =20
--- The error occurred while applying a parameter = map. =20
--- Check the = checkAuthorizedForSecuredItem-InlineParameterMap. =20
--- Check the statement (query failed). 
--- Cause:=20 java.sql.SQLException: [SQL0802] Data conversion or data mapping=20 error.
Caused by: java.sql.SQLException: [SQL0802] Data = conversion or=20 data mapping error.
com.ibatis.dao.client.DaoException: = Failed=20 to execute queryForObject - id [checkAuthorizedForSecuredItem],=20 parameterObject [{secItemId=3D128, userId=3D1409, = functionId=3D19}]. =20 Cause: com.ibatis.common.jdbc.exception.NestedSQLException = :  =20
--- The error occurred in=20 com/myc/fpr/admin/dao/sqlmapdao/User.xml. 
--- The = error=20 occurred while applying a parameter map. 
--- Check the=20 checkAuthorizedForSecuredItem-InlineParameterMap. 
--- = Check the=20 statement (query failed). 
--- Cause: = java.sql.SQLException:=20 [SQL0802] Data conversion or data mapping error.
Caused by:=20 java.sql.SQLException: [SQL0802] Data conversion or data mapping=20 error.
Caused by: = com.ibatis.common.jdbc.exception.NestedSQLException=20 :  
--- The error occurred in=20 com/myc/fpr/admin/dao/sqlmapdao/User.xml. 
--- The = error=20 occurred while applying a parameter map. 
--- Check the=20 checkAuthorizedForSecuredItem-InlineParameterMap. 
--- = Check the=20 statement (query failed). 
--- Cause: = java.sql.SQLException:=20 [SQL0802] Data conversion or data mapping error.
Caused by:=20 java.sql.SQLException: [SQL0802] Data conversion or data mapping=20 error.
 at=20 = com.ibatis.dao.client.template.SqlMapDaoTemplate.queryForObject(SqlMapDao= Template.java(Compiled=20 Code))
 at = com.myc.dbaccess.db2.BaseDao.queryForObject(Unknown=20 Source)
 at=20 com.myc.fpr.admin.dao.db2.UserDb2DAO.isAuthorizedForSecuredItem = (Unknown=20 Source)
 at = sun.reflect.GeneratedMethodAccessor325.invoke(Unknown=20 Source)
 at=20 = sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI= mpl.java(Compiled=20 Code))
 at java.lang.reflect.Method.invoke = (Method.java(Compiled=20 Code))
 at=20 com.ibatis.dao.engine.impl.DaoProxy.invoke(DaoProxy.java(Compiled=20 Code))
 at $Proxy9.isAuthorizedForSecuredItem(Unknown=20 Source)
 at=20 = com.myc.fpr.security.authorization.AuthorizationService.isUserAuthorizedF= orSecuredItem=20 (Unknown Source)
 at=20 com.myc.fpr.product.action.MethodsAction.show(Unknown = Source)
 at=20 com.myc.fpr.product.action.MethodsAction.display(Unknown=20 Source)
 at = sun.reflect.GeneratedMethodAccessor322.invoke(Unknown=20 Source)
 at=20 = sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI= mpl.java(Compiled=20 Code))
 at = java.lang.reflect.Method.invoke(Method.java(Compiled=20 Code))
 at = org.apache.struts.actions.DispatchAction.dispatchMethod=20 (DispatchAction.java(Compiled Code))
 at=20 = org.apache.struts.actions.DispatchAction.execute(DispatchAction.java(Comp= iled=20 Code))
 at=20 = org.apache.struts.action.RequestProcessor.processActionPerform(RequestPro= cessor.java(Inlined=20 Compiled Code))
 at=20 = org.apache.struts.action.RequestProcessor.process(RequestProcessor.java(C= ompiled=20 Code))
 at=20 = org.apache.struts.action.ActionServlet.process(ActionServlet.java(Inlined= =20 Compiled Code))
 at = org.apache.struts.action.ActionServlet.doGet=20 (ActionServlet.java(Compiled Code))
 at=20 javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled=20 Code))
 at=20 javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled=20 Code))
 at = com.ibm.ws.cache.servlet.ServletWrapper.serviceProxied=20 (ServletWrapper.java(Inlined Compiled Code))
 at=20 = com.ibm.ws.cache.servlet.CacheHook.handleFragment(CacheHook.java(Compiled= =20 Code))
 at=20 = com.ibm.ws.cache.servlet.CacheHook.handleServlet(CacheHook.java(Compiled = Code))
 at=20 = com.ibm.ws.cache.servlet.ServletWrapper.service(ServletWrapper.java(Compi= led=20 Code))
 at=20 = com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.jav= a(Compiled=20 Code))
 at = com.ibm.ws.webcontainer.servlet.ServletWrapper.service=20 (ServletWrapper.java(Compiled Code))
 at=20 = com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterCha= in.java(Compiled=20 Code))
 at=20 = com.myc.fpr.security.authorization.AuthorizationFilter.doFilter(Unknown=20 Source)
 at=20 = com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInsta= nceWrapper.java(Compiled=20 Code))
 at=20 = com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterCha= in.java(Compiled=20 Code))
 at=20 = com.myc.common.filter.AccessFilter.doFilter(AccessFilter.java(Compiled=20 Code))
 at=20 = com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInsta= nceWrapper.java(Compiled=20 Code))
 at=20 com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter=20 (WebAppFilterChain.java(Compiled Code))
 at=20 = com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterCh= ain.java(Compiled=20 Code))
 at=20 = com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapp= er.java=20 (Compiled Code))
 at=20 = com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheSe= rvletWrapper.java(Compiled=20 Code))
 at=20 = com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java(Comp= iled=20 Code))
 at=20 = com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java(Co= mpiled=20 Code))
 at=20 = com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination= (HttpInboundLink.java(Compiled=20 Code))
 at=20 = com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation= =20 (HttpInboundLink.java(Compiled Code))
 at=20 = com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICL= ReadCallback.java(Compiled=20 Code))
 at=20 = com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueMan= ager.java=20 (Compiled Code))
 at=20 = com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.j= ava(Compiled=20 Code))
 at=20 = com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.j= ava(Compiled=20 Code))
 at=20 = com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.= java(Compiled=20 Code))
 at=20 com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled=20 Code))
Caused by:=20 com.ibatis.common.jdbc.exception.NestedSQLException :  =20
--- The error occurred in=20 com/myc/fpr/admin/dao/sqlmapdao/User.xml. 
--- The = error=20 occurred while applying a parameter map. 
--- Check the=20 checkAuthorizedForSecuredItem-InlineParameterMap. 
--- = Check the=20 statement (query failed). 
--- Cause: = java.sql.SQLException:=20 [SQL0802] Data conversion or data mapping error.
Caused by:=20 java.sql.SQLException: [SQL0802] Data conversion or data mapping=20 error.
 at=20 = com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryW= ithCallback(GeneralStatement.java(Compiled=20 Code))
 at=20 = com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryF= orObject(GeneralStatement.java=20 (Compiled Code))
 at=20 = com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMa= pExecutorDelegate.java(Compiled=20 Code))
 at=20 = com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMa= pExecutorDelegate.java=20 (Inlined Compiled Code))
 at=20 = com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSess= ionImpl.java(Inlined=20 Compiled Code))
 at=20 = com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClien= tImpl.java=20 (Compiled Code))
 ... 48 more
Caused by:=20 java.sql.SQLException: [SQL0802] Data conversion or data mapping=20 error.
 at=20 = com.ibm.as400.access.JDError.throwSQLException(JDError.java(Compiled=20 Code))
 at=20 = com.ibm.as400.access.JDError.throwSQLException(JDError.java(Inlined=20 Compiled Code))
 at=20 = com.ibm.as400.access.AS400JDBCStatement.commonExecute(AS400JDBCStatement.= java(Compiled=20 Code))
 at = com.ibm.as400.access.AS400JDBCPreparedStatement.execute=20 (AS400JDBCPreparedStatement.java(Compiled Code))
 at=20 = com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecute(WSJdbcPrepar= edStatement.java(Compiled=20 Code))
 at=20 com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.execute=20 (WSJdbcPreparedStatement.java(Compiled Code))
 at=20 sun.reflect.GeneratedMethodAccessor71.invoke(Unknown = Source)
 at=20 = sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI= mpl.java(Compiled=20 Code))
 at = java.lang.reflect.Method.invoke(Method.java(Compiled=20 Code))
 at=20 = com.ibatis.common.jdbc.logging.PreparedStatementLogProxy.invoke(PreparedS= tatementLogProxy.java(Compiled=20 Code))
 at $Proxy28.execute(Unknown Source)
 at=20 = com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.j= ava(Compiled=20 Code))
 at=20 = com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQue= ry(GeneralStatement.java(Compiled=20 Code))
 ... 54 more
 
Caused by:=20 =
com.ibatis.common.jdbc.exception.NestedSQLException:  =20
--- The error occurred in=20 com/myc/fpr/admin/dao/sqlmapdao/User.xml. 
--- The = error=20 occurred while applying a parameter map. 
--- Check the=20 checkAuthorizedForSecuredItem-InlineParameterMap. 
--- = Check the=20 statement (query failed). 
--- Cause: = java.sql.SQLException:=20 [SQL0802] Data conversion or data mapping error.
Caused by:=20 java.sql.SQLException : [SQL0802] Data conversion or data mapping=20 error.
 at=20 = com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryW= ithCallback(GeneralStatement.java(Compiled=20 Code))
 at=20 = com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryF= orObject=20 (GeneralStatement.java(Compiled Code))
 at=20 = com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMa= pExecutorDelegate.java(Compiled=20 Code))
 at=20 = com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject=20 (SqlMapExecutorDelegate.java(Inlined Compiled Code))
 at=20 = com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSess= ionImpl.java(Inlined=20 Compiled Code))
 at=20 com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject=20 (SqlMapClientImpl.java(Compiled Code))
 at=20 = com.ibatis.dao.client.template.SqlMapDaoTemplate.queryForObject(SqlMapDao= Template.java(Compiled=20 Code))
 at = com.myc.dbaccess.db2.BaseDao.queryForObject(Unknown=20 Source)
 at=20 = com.myc.fpr.admin.dao.db2.UserDb2DAO.isAuthorizedForSecuredItem(Unknown=20 Source)
 at = sun.reflect.GeneratedMethodAccessor325.invoke(Unknown=20 Source)
 at=20 = sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI= mpl.java=20 (Compiled Code))
 at=20 java.lang.reflect.Method.invoke(Method.java(Compiled = Code))
 at=20 com.ibatis.dao.engine.impl.DaoProxy.invoke(DaoProxy.java(Compiled=20 Code))
 at $Proxy9.isAuthorizedForSecuredItem(Unknown = Source)=20
 at=20 = com.myc.fpr.security.authorization.AuthorizationService.isUserAuthorizedF= orSecuredItem(Unknown=20 Source)
 at = com.myc.fpr.product.action.MethodsAction.show(Unknown=20 Source)
 at = com.myc.fpr.product.action.MethodsAction.display=20 (Unknown Source)
 at=20 sun.reflect.GeneratedMethodAccessor322.invoke(Unknown = Source)
 at=20 = sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI= mpl.java(Compiled=20 Code))
 at java.lang.reflect.Method.invoke = (Method.java(Compiled=20 Code))
 at=20 = org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.ja= va(Compiled=20 Code))
 at=20 = org.apache.struts.actions.DispatchAction.execute(DispatchAction.java(Comp= iled=20 Code))
 at=20 = org.apache.struts.action.RequestProcessor.processActionPerform(RequestPro= cessor.java(Inlined=20 Compiled Code))
 at=20 = org.apache.struts.action.RequestProcessor.process(RequestProcessor.java(C= ompiled=20 Code))
 at org.apache.struts.action.ActionServlet.process=20 (ActionServlet.java(Inlined Compiled Code))
 at=20 = org.apache.struts.action.ActionServlet.doGet(ActionServlet.java(Compiled = Code))
 at=20 javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled=20 Code))
 at javax.servlet.http.HttpServlet.service=20 (HttpServlet.java(Compiled Code))
 at=20 = com.ibm.ws.cache.servlet.ServletWrapper.serviceProxied(ServletWrapper.jav= a(Inlined=20 Compiled Code))
 at=20 = com.ibm.ws.cache.servlet.CacheHook.handleFragment(CacheHook.java(Compiled= =20 Code))
 at=20 = com.ibm.ws.cache.servlet.CacheHook.handleServlet(CacheHook.java(Compiled = Code))
 at=20 = com.ibm.ws.cache.servlet.ServletWrapper.service(ServletWrapper.java(Compi= led=20 Code))
 at = com.ibm.ws.webcontainer.servlet.ServletWrapper.service=20 (ServletWrapper.java(Compiled Code))
 at=20 = com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.jav= a(Compiled=20 Code))
 at=20 = com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterCha= in.java=20 (Compiled Code))
 at=20 = com.myc.fpr.security.authorization.AuthorizationFilter.doFilter(Unknown=20 Source)
 at=20 = com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInsta= nceWrapper.java(Compiled=20 Code))
 at=20 = com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterCha= in.java(Compiled=20 Code))
 at=20 = com.myc.common.filter.AccessFilter.doFilter(AccessFilter.java(Compiled=20 Code))
 at=20 com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter=20 (FilterInstanceWrapper.java(Compiled Code))
 at=20 = com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterCha= in.java(Compiled=20 Code))
 at=20 = com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterCh= ain.java=20 (Compiled Code))
 at=20 = com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapp= er.java(Compiled=20 Code))
 at=20 = com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheSe= rvletWrapper.java(Compiled=20 Code))
 at=20 = com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java(Comp= iled=20 Code))
 at=20 = com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java(Co= mpiled=20 Code))
 at=20 = com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination= =20 (HttpInboundLink.java(Compiled Code))
 at=20 = com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation= (HttpInboundLink.java(Compiled=20 Code))
 at=20 com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete=20 (HttpICLReadCallback.java(Compiled Code))
 at=20 = com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueMan= ager.java(Compiled=20 Code))
 at=20 = com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.j= ava=20 (Compiled Code))
 at=20 = com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.j= ava(Compiled=20 Code))
 at=20 = com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.= java(Compiled=20 Code))
 at=20 com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled=20 Code))
Caused by: java.sql.SQLException: [SQL0802] Data=20 conversion or data mapping error.
 at=20 com.ibm.as400.access.JDError.throwSQLException = (JDError.java(Compiled=20 Code))
 at=20 = com.ibm.as400.access.JDError.throwSQLException(JDError.java(Inlined=20 Compiled Code))
 at=20 = com.ibm.as400.access.AS400JDBCStatement.commonExecute(AS400JDBCStatement.= java(Compiled=20 Code))
 at=20 = com.ibm.as400.access.AS400JDBCPreparedStatement.execute(AS400JDBCPrepared= Statement.java(Compiled=20 Code))
 at=20 = com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecute(WSJdbcPrepar= edStatement.java(Compiled=20 Code))
 at=20 = com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.execute(WSJdbcPreparedS= tatement.java(Compiled=20 Code))
 at = sun.reflect.GeneratedMethodAccessor71.invoke(Unknown=20 Source)
 at = sun.reflect.DelegatingMethodAccessorImpl.invoke=20 (DelegatingMethodAccessorImpl.java(Compiled Code))
 at=20 java.lang.reflect.Method.invoke(Method.java(Compiled = Code))
 at=20 = com.ibatis.common.jdbc.logging.PreparedStatementLogProxy.invoke(PreparedS= tatementLogProxy.java(Compiled=20 Code))
 at $Proxy28.execute(Unknown Source)
 at=20 = com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.j= ava(Compiled=20 Code))
 at=20 = com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQue= ry=20 (GeneralStatement.java(Compiled Code))
 ... 54 = more
 
Caused by:=20
java.sql.SQLException: [SQL0802] Data conversion or data = mapping=20 error.
 at=20 = com.ibm.as400.access.JDError.throwSQLException(JDError.java(Compiled=20 Code))
 at=20 = com.ibm.as400.access.JDError.throwSQLException(JDError.java(Inlined=20 Compiled Code))
 at=20 = com.ibm.as400.access.AS400JDBCStatement.commonExecute(AS400JDBCStatement.= java(Compiled=20 Code))
 at = com.ibm.as400.access.AS400JDBCPreparedStatement.execute=20 (AS400JDBCPreparedStatement.java(Compiled Code))
 at=20 = com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecute(WSJdbcPrepar= edStatement.java(Compiled=20 Code))
 at=20 com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.execute=20 (WSJdbcPreparedStatement.java(Compiled Code))
 at=20 sun.reflect.GeneratedMethodAccessor71.invoke(Unknown = Source)
 at=20 = sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI= mpl.java(Compiled=20 Code))
 at = java.lang.reflect.Method.invoke(Method.java(Compiled=20 Code))
 at=20 = com.ibatis.common.jdbc.logging.PreparedStatementLogProxy.invoke(PreparedS= tatementLogProxy.java(Compiled=20 Code))
 at $Proxy28.execute(Unknown Source)
 at=20 = com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.j= ava(Compiled=20 Code))
 at=20 = com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQue= ry(GeneralStatement.java(Compiled=20 Code))
 at=20 = com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryW= ithCallback(GeneralStatement.java(Compiled=20 Code))
 at=20 = com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryF= orObject(GeneralStatement.java=20 (Compiled Code))
 at=20 = com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMa= pExecutorDelegate.java(Compiled=20 Code))
 at=20 = com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMa= pExecutorDelegate.java=20 (Inlined Compiled Code))
 at=20 = com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSess= ionImpl.java(Inlined=20 Compiled Code))
 at=20 = com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClien= tImpl.java=20 (Compiled Code))
 at=20 = com.ibatis.dao.client.template.SqlMapDaoTemplate.queryForObject(SqlMapDao= Template.java(Compiled=20 Code))
 at = com.myc.dbaccess.db2.BaseDao.queryForObject(Unknown=20 Source)
 at=20 com.myc.fpr.admin.dao.db2.UserDb2DAO.isAuthorizedForSecuredItem = (Unknown=20 Source)
 at = sun.reflect.GeneratedMethodAccessor325.invoke(Unknown=20 Source)
 at=20 = sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI= mpl.java(Compiled=20 Code))
 at java.lang.reflect.Method.invoke = (Method.java(Compiled=20 Code))
 at=20 com.ibatis.dao.engine.impl.DaoProxy.invoke(DaoProxy.java(Compiled=20 Code))
 at $Proxy9.isAuthorizedForSecuredItem(Unknown=20 Source)
 at=20 = com.myc.fpr.security.authorization.AuthorizationService.isUserAuthorizedF= orSecuredItem=20 (Unknown Source)
 at=20 com.myc.fpr.product.action.MethodsAction.show(Unknown = Source)
 at=20 com.myc.fpr.product.action.MethodsAction.display(Unknown=20 Source)
 at = sun.reflect.GeneratedMethodAccessor322.invoke(Unknown=20 Source)
 at=20 = sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI= mpl.java(Compiled=20 Code))
 at = java.lang.reflect.Method.invoke(Method.java(Compiled=20 Code))
 at = org.apache.struts.actions.DispatchAction.dispatchMethod=20 (DispatchAction.java(Compiled Code))
 at=20 = org.apache.struts.actions.DispatchAction.execute(DispatchAction.java(Comp= iled=20 Code))
 at=20 = org.apache.struts.action.RequestProcessor.processActionPerform(RequestPro= cessor.java(Inlined=20 Compiled Code))
 at=20 = org.apache.struts.action.RequestProcessor.process(RequestProcessor.java(C= ompiled=20 Code))
 at=20 = org.apache.struts.action.ActionServlet.process(ActionServlet.java(Inlined= =20 Compiled Code))
 at = org.apache.struts.action.ActionServlet.doGet=20 (ActionServlet.java(Compiled Code))
 at=20 javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled=20 Code))
 at=20 javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled=20 Code))
 at = com.ibm.ws.cache.servlet.ServletWrapper.serviceProxied=20 (ServletWrapper.java(Inlined Compiled Code))
 at=20 = com.ibm.ws.cache.servlet.CacheHook.handleFragment(CacheHook.java(Compiled= =20 Code))
 at=20 = com.ibm.ws.cache.servlet.CacheHook.handleServlet(CacheHook.java(Compiled = Code))
 at=20 = com.ibm.ws.cache.servlet.ServletWrapper.service(ServletWrapper.java(Compi= led=20 Code))
 at=20 = com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.jav= a(Compiled=20 Code))
 at = com.ibm.ws.webcontainer.servlet.ServletWrapper.service=20 (ServletWrapper.java(Compiled Code))
 at=20 = com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterCha= in.java(Compiled=20 Code))
 at=20 = com.myc.fpr.security.authorization.AuthorizationFilter.doFilter(Unknown=20 Source)
 at=20 = com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInsta= nceWrapper.java(Compiled=20 Code))
 at=20 = com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterCha= in.java(Compiled=20 Code))
 at=20 = com.myc.common.filter.AccessFilter.doFilter(AccessFilter.java(Compiled=20 Code))
 at=20 = com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInsta= nceWrapper.java(Compiled=20 Code))
 at=20 com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter=20 (WebAppFilterChain.java(Compiled Code))
 at=20 = com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterCh= ain.java(Compiled=20 Code))
 at=20 = com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapp= er.java=20 (Compiled Code))
 at=20 = com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheSe= rvletWrapper.java(Compiled=20 Code))
 at=20 = com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java(Comp= iled=20 Code))
 at=20 = com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java(Co= mpiled=20 Code))
 at=20 = com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination= (HttpInboundLink.java(Compiled=20 Code))
 at=20 = com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation= =20 (HttpInboundLink.java(Compiled Code))
 at=20 = com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICL= ReadCallback.java(Compiled=20 Code))
 at=20 = com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueMan= ager.java=20 (Compiled Code))
 at=20 = com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.j= ava(Compiled=20 Code))
 at=20 = com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.j= ava(Compiled=20 Code))
 at=20 = com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.= java(Compiled=20 Code))
 at=20 com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled=20 Code))
11 Dec 2006 11:52:21 [WebContainer : 6] ERROR=20 com.myc.fpr.utils.FprExceptionHandler ///execute/// - Exception = occured=20 ... catched by Handler
11 Dec 2006 11:52:21 [WebContainer : 6] = ERROR=20 com.myc.fpr.utils.FprExceptionHandler ///execute/// -=20 com.ibatis.dao.client.DaoException: Failed to execute = queryForObject - id=20 [checkAuthorizedForSecuredItem], parameterObject = [{secItemId=3D128,=20 userId=3D1409, functionId=3D19}].  Cause:=20 com.ibatis.common.jdbc.exception.NestedSQLException:   =
---=20 The error occurred in = com/myc/fpr/admin/dao/sqlmapdao/User.xml. =20
--- The error occurred while applying a parameter = map. =20
--- Check the = checkAuthorizedForSecuredItem-InlineParameterMap. =20
--- Check the statement (query failed). 
--- Cause:=20 java.sql.SQLException: [SQL0802] Data conversion or data mapping=20 error.
Caused by: java.sql.SQLException: [SQL0802] Data = conversion or=20 data mapping error.
Caused by:=20 com.ibatis.common.jdbc.exception.NestedSQLException:  =20
--- The error occurred in=20 com/myc/fpr/admin/dao/sqlmapdao/User.xml. 
--- The = error=20 occurred while applying a parameter map. 
--- Check the=20 checkAuthorizedForSecuredItem-InlineParameterMap. 
--- = Check the=20 statement (query failed). 
--- Cause: = java.sql.SQLException:=20 [SQL0802] Data conversion or data mapping error.
Caused by:=20 java.sql.SQLException: [SQL0802] Data conversion or data mapping=20 error.
com.myc.dbaccess.DBException:=20 com.ibatis.dao.client.DaoException: Failed to execute = queryForObject - id=20 [checkAuthorizedForSecuredItem], parameterObject = [{secItemId=3D128,=20 userId=3D1409, functionId=3D19}].  Cause:=20 com.ibatis.common.jdbc.exception.NestedSQLException :   =
---=20 The error occurred in = com/myc/fpr/admin/dao/sqlmapdao/User.xml. =20
--- The error occurred while applying a parameter = map. =20
--- Check the = checkAuthorizedForSecuredItem-InlineParameterMap. =20
--- Check the statement (query failed). 
--- Cause:=20 java.sql.SQLException: [SQL0802] Data conversion or data mapping=20 error.
Caused by: java.sql.SQLException: [SQL0802] Data = conversion or=20 data mapping error.
Caused by:=20 com.ibatis.common.jdbc.exception.NestedSQLException :  =20
--- The error occurred in=20 com/myc/fpr/admin/dao/sqlmapdao/User.xml. 
--- The = error=20 occurred while applying a parameter map. 
--- Check the=20 checkAuthorizedForSecuredItem-InlineParameterMap. 
--- = Check the=20 statement (query failed). 
--- Cause: = java.sql.SQLException:=20 [SQL0802] Data conversion or data mapping error.
Caused by:=20 java.sql.SQLException: [SQL0802] Data conversion or data mapping=20 error.
 at=20 com.myc.dbaccess.DB2ExceptionDecoder.throwDecodedException(Unknown = Source)
 at=20 com.myc.dbaccess.DB2ExceptionDecoder.throwDecodedException(Unknown = Source)
 at = com.myc.dbaccess.db2.BaseDao.queryForObject(Unknown=20 Source)
 at=20 = com.myc.fpr.admin.dao.db2.UserDb2DAO.isAuthorizedForSecuredItem(Unknown=20 Source)
 at = sun.reflect.GeneratedMethodAccessor325.invoke(Unknown=20 Source)
 at=20 = sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI= mpl.java=20 (Compiled Code))
 at=20 java.lang.reflect.Method.invoke(Method.java(Compiled = Code))
 at=20 com.ibatis.dao.engine.impl.DaoProxy.invoke(DaoProxy.java(Compiled=20 Code))
 at $Proxy9.isAuthorizedForSecuredItem(Unknown = Source)=20
 at=20 = com.myc.fpr.security.authorization.AuthorizationService.isUserAuthorizedF= orSecuredItem(Unknown=20 Source)
 at = com.myc.fpr.product.action.MethodsAction.show(Unknown=20 Source)
 at = com.myc.fpr.product.action.MethodsAction.display=20 (Unknown Source)
 at=20 sun.reflect.GeneratedMethodAccessor322.invoke(Unknown = Source)
 at=20 = sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI= mpl.java(Compiled=20 Code))
 at java.lang.reflect.Method.invoke = (Method.java(Compiled=20 Code))
 at=20 = org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.ja= va(Compiled=20 Code))
 at=20 = org.apache.struts.actions.DispatchAction.execute(DispatchAction.java(Comp= iled=20 Code))
 at=20 = org.apache.struts.action.RequestProcessor.processActionPerform(RequestPro= cessor.java(Inlined=20 Compiled Code))
 at=20 = org.apache.struts.action.RequestProcessor.process(RequestProcessor.java(C= ompiled=20 Code))
 at org.apache.struts.action.ActionServlet.process=20 (ActionServlet.java(Inlined Compiled Code))
 at=20 = org.apache.struts.action.ActionServlet.doGet(ActionServlet.java(Compiled = Code))
 at=20 javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled=20 Code))
 at javax.servlet.http.HttpServlet.service=20 (HttpServlet.java(Compiled Code))
 at=20 = com.ibm.ws.cache.servlet.ServletWrapper.serviceProxied(ServletWrapper.jav= a(Inlined=20 Compiled Code))
 at=20 = com.ibm.ws.cache.servlet.CacheHook.handleFragment(CacheHook.java(Compiled= =20 Code))
 at=20 = com.ibm.ws.cache.servlet.CacheHook.handleServlet(CacheHook.java(Compiled = Code))
 at=20 = com.ibm.ws.cache.servlet.ServletWrapper.service(ServletWrapper.java(Compi= led=20 Code))
 at = com.ibm.ws.webcontainer.servlet.ServletWrapper.service=20 (ServletWrapper.java(Compiled Code))
 at=20 = com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.jav= a(Compiled=20 Code))
 at=20 = com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterCha= in.java=20 (Compiled Code))
 at=20 = com.myc.fpr.security.authorization.AuthorizationFilter.doFilter(Unknown=20 Source)
 at=20 = com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInsta= nceWrapper.java(Compiled=20 Code))
 at=20 = com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterCha= in.java(Compiled=20 Code))
 at=20 = com.myc.common.filter.AccessFilter.doFilter(AccessFilter.java(Compiled=20 Code))
 at=20 com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter=20 (FilterInstanceWrapper.java(Compiled Code))
 at=20 = com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterCha= in.java(Compiled=20 Code))
 at=20 = com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterCh= ain.java=20 (Compiled Code))
 at=20 = com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapp= er.java(Compiled=20 Code))
 at=20 = com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheSe= rvletWrapper.java(Compiled=20 Code))
 at=20 = com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java(Comp= iled=20 Code))
 at=20 = com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java(Co= mpiled=20 Code))
 at=20 = com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination= =20 (HttpInboundLink.java(Compiled Code))
 at=20 = com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation= (HttpInboundLink.java(Compiled=20 Code))
 at=20 com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete=20 (HttpICLReadCallback.java(Compiled Code))
 at=20 = com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueMan= ager.java(Compiled=20 Code))
 at=20 = com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.j= ava=20 (Compiled Code))
 at=20 = com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.j= ava(Compiled=20 Code))
 at=20 = com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.= java(Compiled=20 Code))
 at=20 com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled=20 Code))
Caused by: com.ibatis.dao.client.DaoException: Failed to = execute=20 queryForObject - id [checkAuthorizedForSecuredItem], = parameterObject=20 [{secItemId=3D128, userId=3D1409, functionId=3D19}].  Cause:=20 com.ibatis.common.jdbc.exception.NestedSQLException:   =
---=20 The error occurred in = com/myc/fpr/admin/dao/sqlmapdao/User.xml. =20
--- The error occurred while applying a parameter = map. =20
--- Check the = checkAuthorizedForSecuredItem-InlineParameterMap. =20
--- Check the statement (query failed). 
--- Cause:=20 java.sql.SQLException: [SQL0802] Data conversion or data mapping=20 error.
Caused by: java.sql.SQLException: [SQL0802] Data = conversion or=20 data mapping error.
Caused by:=20 com.ibatis.common.jdbc.exception.NestedSQLException:  =20
--- The error occurred in=20 com/myc/fpr/admin/dao/sqlmapdao/User.xml. 
--- The = error=20 occurred while applying a parameter map. 
--- Check the=20 checkAuthorizedForSecuredItem-InlineParameterMap. 
--- = Check the=20 statement (query failed). 
--- Cause: = java.sql.SQLException:=20 [SQL0802] Data conversion or data mapping error.
Caused by:=20 java.sql.SQLException: [SQL0802] Data conversion or data mapping=20 error.
 at=20 = com.ibatis.dao.client.template.SqlMapDaoTemplate.queryForObject(SqlMapDao= Template.java(Compiled=20 Code))
 ... 47 more
Caused by:=20 com.ibatis.common.jdbc.exception.NestedSQLException:  =20
--- The error occurred in=20 com/myc/fpr/admin/dao/sqlmapdao/User.xml. 
--- The = error=20 occurred while applying a parameter map. 
--- Check the=20 checkAuthorizedForSecuredItem-InlineParameterMap. 
--- = Check the=20 statement (query failed). 
--- Cause: = java.sql.SQLException:=20 [SQL0802] Data conversion or data mapping error.
Caused by:=20 java.sql.SQLException: [SQL0802] Data conversion or data mapping=20 error.
 at=20 = com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryW= ithCallback(GeneralStatement.java(Compiled=20 Code))
 at=20 = com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryF= orObject(GeneralStatement.java(Compiled=20 Code))
 at=20 = com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMa= pExecutorDelegate.java=20 (Compiled Code))
 at=20 = com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMa= pExecutorDelegate.java(Inlined=20 Compiled Code))
 at=20 = com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSess= ionImpl.java=20 (Inlined Compiled Code))
 at=20 = com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClien= tImpl.java(Compiled=20 Code))
 ... 48 more
Caused by: = java.sql.SQLException:=20 [SQL0802] Data conversion or data mapping error. =
 at=20 = com.ibm.as400.access.JDError.throwSQLException(JDError.java(Compiled=20 Code))
 at=20 = com.ibm.as400.access.JDError.throwSQLException(JDError.java(Inlined=20 Compiled Code))
 at=20 com.ibm.as400.access.AS400JDBCStatement.commonExecute=20 (AS400JDBCStatement.java(Compiled Code))
 at=20 = com.ibm.as400.access.AS400JDBCPreparedStatement.execute(AS400JDBCPrepared= Statement.java(Compiled=20 Code))
 at=20 = com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecute(WSJdbcPrepar= edStatement.java=20 (Compiled Code))
 at=20 = com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.execute(WSJdbcPreparedS= tatement.java(Compiled=20 Code))
 at = sun.reflect.GeneratedMethodAccessor71.invoke(Unknown=20 Source)
 at = sun.reflect.DelegatingMethodAccessorImpl.invoke=20 (DelegatingMethodAccessorImpl.java(Compiled Code))
 at=20 java.lang.reflect.Method.invoke(Method.java(Compiled = Code))
 at=20 = com.ibatis.common.jdbc.logging.PreparedStatementLogProxy.invoke(PreparedS= tatementLogProxy.java(Compiled=20 Code))
 at $Proxy28.execute(Unknown Source)
 at=20 = com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.j= ava(Compiled=20 Code))
 at=20 = com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQue= ry=20 (GeneralStatement.java(Compiled Code))
 ... 54 = more
 
 
Thank you,
Cornel
-----=20 Original Message -----
From:=20 Brandon = Goodin=20
To:=20 user-java@ibatis.apache.org
Sent:=20 Tuesday, December 12, 2006 5:27 PM
Subject:=20 Re: Data conversion or data mapping error.

 
Can you post the parameterized SQL as=20 well?

Brandon

On 12/12/06, Cornel Antohi <cantohi@kepler-rominfo.com > = wrote:=20
Hello,
 
I have a big problem on one = of my=20 application that is ussing IBatis v2.1.7, DB2 AS400 V5R3 and = WAS 6.0.=20
During the tests (few users) = the=20 application is working fine but when we run the loading tests = (many=20 users in paralel) we received the following error. What is = strange it=20 is that the query fails only during the loading tests and with = some=20 parameters and not always ... the exact same query it is = executed fine=20 in some cases. We could not find yet a pattern to reproduce = this=20 behaviour ...
 
Here are the = logs:
 
 
11 Dec 2006 10:44:12=20 [WebContainer : 1] ERROR FprExceptionHandler ///execute/// -=20 com.ibatis.dao.client.DaoException: Failed to execute = queryForObject -=20 id [checkAuthorizedForSecuredItem], parameterObject = [{secItemId=3D152,=20 userId=3D1316, functionId=3D19}].  Cause:=20 com.ibatis.common.jdbc.exception.NestedSQLException:   =
---=20 The error occurred in com/admin/dao/sqlmapdao/User.xml. =  =20
--- The error occurred = while=20 applying a parameter map.  
--- Check the = checkAuthorizedForSecuredItem-InlineParameterMap.=20  
--- = Check the=20 statement (query failed).  
--- Cause: java.sql.SQLException: [SQL0802] Data = conversion or=20 data mapping error.
Caused=20 by: java.sql.SQLException: [SQL0802] Data conversion or data = mapping=20 error.
Caused = by:=20 com.ibatis.common.jdbc.exception.NestedSQLException:  =20
--- The error = occurred in=20 com/admin/dao/sqlmapdao/User.xml.  
--- The error occurred while = applying a=20 parameter map.  
---=20 Check the checkAuthorizedForSecuredItem-InlineParameterMap.=20  
--- = Check the=20 statement (query failed).  
--- Cause: java.sql.SQLException: [SQL0802] Data = conversion or=20 data mapping error.


Query:
 =20 <select id=3D"checkAuthorizedForSecuredItem" = resultClass=3D"long"=20 parameterClass=3D"map">
          select 1 from = SEC_FN_USR=20
    =    =20           where SEC_ID=3D#secItemId# = and=20 USER_ID=3D#userId# and FN_ID=3D#functionId#
  </select>=20


Params:=20
[{secItemId=3D152, = userId=3D1316,=20 functionId=3D19}]
[{secItemId=3D152, userId=3D1017, = functionId=3D19}]
[{secItemId=3D131, = userId=3D1055,=20 functionId=3D19}]
[{secItemId=3D140, userId=3D1321, = functionId=3D19}]
...
 
 
Do you have any clue for this = problem?
 
Any help is highly=20 appreciated!
 
Thank you,
Cornel
=

 



------=_NextPart_000_001F_01C71EF3.8EF9F2E0--