Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 80886 invoked from network); 21 Nov 2009 16:10:50 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 21 Nov 2009 16:10:50 -0000 Received: (qmail 42544 invoked by uid 500); 21 Nov 2009 16:10:49 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 42502 invoked by uid 500); 21 Nov 2009 16:10:49 -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 42491 invoked by uid 99); 21 Nov 2009 16:10:49 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 21 Nov 2009 16:10:49 +0000 X-ASF-Spam-Status: No, hits=-2.6 required=5.0 tests=BAYES_00 X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of mikel.sanchez.sg@gmail.com designates 72.14.220.155 as permitted sender) Received: from [72.14.220.155] (HELO fg-out-1718.google.com) (72.14.220.155) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 21 Nov 2009 16:10:46 +0000 Received: by fg-out-1718.google.com with SMTP id e12so416548fga.6 for ; Sat, 21 Nov 2009 08:10:24 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:content-type :content-transfer-encoding; bh=/twdytqLbDPj4442e0RZbxdDBoXhipOzRb//K43os5k=; b=g6NFJoL7x72Sd7Djv1UUDDFAp7H5D+/3D9Ry8v/Jiq40z/KE8YzBSp1tyksaTVkY9B BcdHZ80cXa3AxIAHAogKdWY/81aFGZcqDifUj8/VdPEab6qY/0Ggi59C7Gpm3+HLhNwE OougpNJQJJ9GS348g892F8hHQTA5n3NfqqdlE= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type:content-transfer-encoding; b=VYuYO1m3AqV8Wb+4Uskid3xjJ3ar6D8jzubvYyF+Xhkz46RAw+lzBixJcniqw23fjE 1ZXm46SSzzPaPsUR8yEFwTveHMpPEFj0aAjlPH9cYfa5hCJ6OA+Sy/eSXQx2OjZLVyl9 QORhftNh3BPdORXJKZpGgeBF25yVHtXtLj2ss= MIME-Version: 1.0 Received: by 10.86.214.20 with SMTP id m20mr2256552fgg.4.1258819824838; Sat, 21 Nov 2009 08:10:24 -0800 (PST) In-Reply-To: <26457825.post@talk.nabble.com> References: <26457825.post@talk.nabble.com> Date: Sat, 21 Nov 2009 17:10:24 +0100 Message-ID: Subject: Re: invalid column index (urgent) From: Mikel sanchez To: user-java@ibatis.apache.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable I'm not sure, but could it be that in the property buName is not being properly joined with the string '%' ? I usually change the property value from code, before calling the statement. That is: buName =3D "%" + buName + "%" and the statement remains the same without the %: .......LIKE UPPER(#buName#) 2009/11/21 helpmeplzplz : > > Hi ALL, > > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0type=3D"com.everbridge.aware.ui.MembersDis= playBean" /> > > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0type=3D"com.everbridge.aware.ui.MemberSear= chParameters" /> > > > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 > =A0 > > class=3D"businessUnitsEditsParameters"> > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 > =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 > =A0 =A0 =A0 =A0 > > > > > > > > > =A0 =A0 =A0 =A0 > > > > > For this query i am getting invalid column index . > > But i am not getting that why it is giving error like that > > > org.springframework.jdbc.InvalidResultSetAccessException: SqlMapClient > operation; invalid ResultSet access for SQL []; nested exception is > com.ibatis.common.jdbc.exception.NestedSQLException: > --- The error occurred in com/everbridge/aware/ui/MemberManagement.xml. > --- The error occurred while applying a parameter map. > --- Check the MemberManagement.buEditParamMap. > --- Check the parameter mapping for the 'buName' property. > --- Cause: java.sql.SQLException: Invalid column index > Caused by: java.sql.SQLException: Invalid column index > Caused by: com.ibatis.common.jdbc.exception.NestedSQLException: > --- The error occurred in com/everbridge/aware/ui/MemberManagement.xml. > --- The error occurred while applying a parameter map. > --- Check the MemberManagement.buEditParamMap. > --- Check the parameter mapping for the 'buName' property. > --- Cause: java.sql.SQLException: Invalid column index > Caused by: java.sql.SQLException: Invalid column index > =A0 =A0 =A0 =A0at > com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryW= ithCallback(GeneralStatement.java:185) > =A0 =A0 =A0 =A0at > com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryF= orList(GeneralStatement.java:123) > =A0 =A0 =A0 =A0at > com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapE= xecutorDelegate.java:614) > =A0 =A0 =A0 =A0at > com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapE= xecutorDelegate.java:588) > =A0 =A0 =A0 =A0at > com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessio= nImpl.java:118) > =A0 =A0 =A0 =A0at > org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(Sq= lMapClientTemplate.java:268) > =A0 =A0 =A0 =A0at > org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientT= emplate.java:193) > =A0 =A0 =A0 =A0at > org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResult= (SqlMapClientTemplate.java:219) > =A0 =A0 =A0 =A0at > org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapCl= ientTemplate.java:266) > =A0 =A0 =A0 =A0at > com.everbridge.aware.ui.spi.MemberSearchDao.buSearchCriteriaContains(Memb= erSearchDao.java:342) > =A0 =A0 =A0 =A0at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Met= hod) > =A0 =A0 =A0 =A0at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java= :39) > =A0 =A0 =A0 =A0at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI= mpl.java:25) > =A0 =A0 =A0 =A0at java.lang.reflect.Method.invoke(Method.java:324) > =A0 =A0 =A0 =A0at > org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(A= opUtils.java:281) > =A0 =A0 =A0 =A0at > org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpo= int(ReflectiveMethodInvocation.java:187) > =A0 =A0 =A0 =A0at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Refl= ectiveMethodInvocation.java:154) > =A0 =A0 =A0 =A0at > org.springframework.transaction.interceptor.TransactionInterceptor.invoke= (TransactionInterceptor.java:107) > =A0 =A0 =A0 =A0at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Refl= ectiveMethodInvocation.java:176) > =A0 =A0 =A0 =A0at > org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAop= Proxy.java:210) > =A0 =A0 =A0 =A0at $Proxy7.buSearchCriteriaContains(Unknown Source) > =A0 =A0 =A0 =A0at > com.everbridge.aware.services.TestCreateBusinessUnit.testBuConatins(TestC= reateBusinessUnit.java:64) > =A0 =A0 =A0 =A0at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Met= hod) > =A0 =A0 =A0 =A0at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java= :39) > =A0 =A0 =A0 =A0at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI= mpl.java:25) > =A0 =A0 =A0 =A0at java.lang.reflect.Method.invoke(Method.java:324) > =A0 =A0 =A0 =A0at junit.framework.TestCase.runTest(TestCase.java:154) > =A0 =A0 =A0 =A0at junit.framework.TestCase.runBare(TestCase.java:127) > =A0 =A0 =A0 =A0at junit.framework.TestResult$1.protect(TestResult.java:10= 6) > =A0 =A0 =A0 =A0at junit.framework.TestResult.runProtected(TestResult.java= :124) > =A0 =A0 =A0 =A0at junit.framework.TestResult.run(TestResult.java:109) > =A0 =A0 =A0 =A0at junit.framework.TestCase.run(TestCase.java:118) > =A0 =A0 =A0 =A0at junit.framework.TestSuite.runTest(TestSuite.java:208) > =A0 =A0 =A0 =A0at junit.framework.TestSuite.run(TestSuite.java:203) > =A0 =A0 =A0 =A0at > org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUni= t3TestReference.java:128) > =A0 =A0 =A0 =A0at > org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.jav= a:38) > =A0 =A0 =A0 =A0at > org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTes= tRunner.java:460) > =A0 =A0 =A0 =A0at > org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTes= tRunner.java:673) > =A0 =A0 =A0 =A0at > org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunn= er.java:386) > =A0 =A0 =A0 =A0at > org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRun= ner.java:196) > Caused by: java.sql.SQLException: Invalid column index > =A0 =A0 =A0 =A0at > oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125= ) > =A0 =A0 =A0 =A0at > oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162= ) > =A0 =A0 =A0 =A0at > oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227= ) > =A0 =A0 =A0 =A0at > oracle.jdbc.driver.OraclePreparedStatement.setStringInternal(OraclePrepar= edStatement.java:4754) > =A0 =A0 =A0 =A0at > oracle.jdbc.driver.OraclePreparedStatement.setString(OraclePreparedStatem= ent.java:4717) > =A0 =A0 =A0 =A0at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Met= hod) > =A0 =A0 =A0 =A0at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java= :39) > =A0 =A0 =A0 =A0at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI= mpl.java:25) > =A0 =A0 =A0 =A0at java.lang.reflect.Method.invoke(Method.java:324) > =A0 =A0 =A0 =A0at > com.ibatis.common.jdbc.logging.PreparedStatementLogProxy.invoke(PreparedS= tatementLogProxy.java:70) > =A0 =A0 =A0 =A0at $Proxy13.setString(Unknown Source) > =A0 =A0 =A0 =A0at > com.ibatis.sqlmap.engine.type.StringTypeHandler.setParameter(StringTypeHa= ndler.java:30) > =A0 =A0 =A0 =A0at > com.ibatis.sqlmap.engine.mapping.parameter.BasicParameterMap.setParameter= (BasicParameterMap.java:165) > =A0 =A0 =A0 =A0at > com.ibatis.sqlmap.engine.mapping.parameter.BasicParameterMap.setParameter= s(BasicParameterMap.java:125) > =A0 =A0 =A0 =A0at > com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.j= ava:180) > =A0 =A0 =A0 =A0at > com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQue= ry(GeneralStatement.java:205) > =A0 =A0 =A0 =A0at > com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryW= ithCallback(GeneralStatement.java:173) > =A0 =A0 =A0 =A0... 39 more > > Caused by: > java.sql.SQLException: Invalid column index > =A0 =A0 =A0 =A0at > oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125= ) > =A0 =A0 =A0 =A0at > oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162= ) > =A0 =A0 =A0 =A0at > oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227= ) > =A0 =A0 =A0 =A0at > oracle.jdbc.driver.OraclePreparedStatement.setStringInternal(OraclePrepar= edStatement.java:4754) > =A0 =A0 =A0 =A0at > oracle.jdbc.driver.OraclePreparedStatement.setString(OraclePreparedStatem= ent.java:4717) > =A0 =A0 =A0 =A0at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Met= hod) > =A0 =A0 =A0 =A0at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java= :39) > =A0 =A0 =A0 =A0at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI= mpl.java:25) > =A0 =A0 =A0 =A0at java.lang.reflect.Method.invoke(Method.java:324) > =A0 =A0 =A0 =A0at > com.ibatis.common.jdbc.logging.PreparedStatementLogProxy.invoke(PreparedS= tatementLogProxy.java:70) > =A0 =A0 =A0 =A0at $Proxy13.setString(Unknown Source) > =A0 =A0 =A0 =A0at > com.ibatis.sqlmap.engine.type.StringTypeHandler.setParameter(StringTypeHa= ndler.java:30) > =A0 =A0 =A0 =A0at > com.ibatis.sqlmap.engine.mapping.parameter.BasicParameterMap.setParameter= (BasicParameterMap.java:165) > =A0 =A0 =A0 =A0at > com.ibatis.sqlmap.engine.mapping.parameter.BasicParameterMap.setParameter= s(BasicParameterMap.java:125) > =A0 =A0 =A0 =A0at > com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.j= ava:180) > =A0 =A0 =A0 =A0at > com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQue= ry(GeneralStatement.java:205) > =A0 =A0 =A0 =A0at > com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryW= ithCallback(GeneralStatement.java:173) > =A0 =A0 =A0 =A0at > com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryF= orList(GeneralStatement.java:123) > =A0 =A0 =A0 =A0at > com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapE= xecutorDelegate.java:614) > =A0 =A0 =A0 =A0at > com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapE= xecutorDelegate.java:588) > =A0 =A0 =A0 =A0at > com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessio= nImpl.java:118) > =A0 =A0 =A0 =A0at > org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(Sq= lMapClientTemplate.java:268) > =A0 =A0 =A0 =A0at > org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientT= emplate.java:193) > =A0 =A0 =A0 =A0at > org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResult= (SqlMapClientTemplate.java:219) > =A0 =A0 =A0 =A0at > org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapCl= ientTemplate.java:266) > =A0 =A0 =A0 =A0at > com.everbridge.aware.ui.spi.MemberSearchDao.buSearchCriteriaContains(Memb= erSearchDao.java:342) > =A0 =A0 =A0 =A0at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Met= hod) > =A0 =A0 =A0 =A0at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java= :39) > =A0 =A0 =A0 =A0at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI= mpl.java:25) > =A0 =A0 =A0 =A0at java.lang.reflect.Method.invoke(Method.java:324) > =A0 =A0 =A0 =A0at > org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(A= opUtils.java:281) > =A0 =A0 =A0 =A0at > org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpo= int(ReflectiveMethodInvocation.java:187) > =A0 =A0 =A0 =A0at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Refl= ectiveMethodInvocation.java:154) > =A0 =A0 =A0 =A0at > org.springframework.transaction.interceptor.TransactionInterceptor.invoke= (TransactionInterceptor.java:107) > =A0 =A0 =A0 =A0at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Refl= ectiveMethodInvocation.java:176) > =A0 =A0 =A0 =A0at > org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAop= Proxy.java:210) > =A0 =A0 =A0 =A0at $Proxy7.buSearchCriteriaContains(Unknown Source) > =A0 =A0 =A0 =A0at > com.everbridge.aware.services.TestCreateBusinessUnit.testBuConatins(TestC= reateBusinessUnit.java:64) > =A0 =A0 =A0 =A0at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Met= hod) > =A0 =A0 =A0 =A0at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java= :39) > =A0 =A0 =A0 =A0at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorI= mpl.java:25) > =A0 =A0 =A0 =A0at java.lang.reflect.Method.invoke(Method.java:324) > =A0 =A0 =A0 =A0at junit.framework.TestCase.runTest(TestCase.java:154) > =A0 =A0 =A0 =A0at junit.framework.TestCase.runBare(TestCase.java:127) > =A0 =A0 =A0 =A0at junit.framework.TestResult$1.protect(TestResult.java:10= 6) > =A0 =A0 =A0 =A0at junit.framework.TestResult.runProtected(TestResult.java= :124) > =A0 =A0 =A0 =A0at junit.framework.TestResult.run(TestResult.java:109) > =A0 =A0 =A0 =A0at junit.framework.TestCase.run(TestCase.java:118) > =A0 =A0 =A0 =A0at junit.framework.TestSuite.runTest(TestSuite.java:208) > =A0 =A0 =A0 =A0at junit.framework.TestSuite.run(TestSuite.java:203) > =A0 =A0 =A0 =A0at > org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUni= t3TestReference.java:128) > =A0 =A0 =A0 =A0at > org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.jav= a:38) > =A0 =A0 =A0 =A0at > org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTes= tRunner.java:460) > =A0 =A0 =A0 =A0at > org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTes= tRunner.java:673) > =A0 =A0 =A0 =A0at > org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunn= er.java:386) > =A0 =A0 =A0 =A0at > org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRun= ner.java:196) > > plz give me reply it is very urgent for me > > thanks in advance. > -- > View this message in context: http://old.nabble.com/invalid-column-index-= -%28urgent%29-tp26457825p26457825.html > Sent from the iBATIS - User - Java mailing list archive at Nabble.com. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org > For additional commands, e-mail: user-java-help@ibatis.apache.org > > --------------------------------------------------------------------- To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org For additional commands, e-mail: user-java-help@ibatis.apache.org