Re: "There is no READABLE property named 'condition' in class 'java.util.ArrayList'".

[Larry Meadors <lm...@apache.org>]

Your sqlmap isn't using the iteration syntax right - you have this:

epoca =#epoca# AND sala = #sala#

...and it should be something like this:

epoca =#epoca[]# AND sala = #sala[]#

Also, please send emails like this to user-java@ibatis.apache.org
instead of me directly. You generally get better responses (faster),
and others can benefit from them.

Larry


On 10/30/07, Carlos de Luna Saenz <cd...@yahoo.com.mx> wrote:
>
> I have the same error... i am attaching the files that involves the error...
> BTW... it seems odd that the package name is preappended with an L
> Greetings and thanks in advance
>
>
>
> org.springframework.jdbc.UncategorizedSQLException:
> SqlMapClient operation; uncategorized SQLException for SQL []; SQL state
> [null]; error code [0];
>
> --- The error occurred in TesisDAO.xml.
>
> --- The error occurred while preparing the mapped statement for execution.
>
> --- Check the TesisDAO.porEpoca.
>
> --- Check the parameter map.
>
> --- Cause: com.ibatis.common.beans.ProbeException: There is
> no READABLE property named 'epoca' in class
> '[Lmx.gob.scjn.iuscommon.TO.EpocasTO;'; nested exception is
> com.ibatis.common.jdbc.exception.NestedSQLException:
>
> --- The error occurred in TesisDAO.xml.
>
> --- The error occurred while preparing the mapped statement for execution.
>
> --- Check the TesisDAO.porEpoca.
>
> --- Check the parameter map.
>
> --- Cause: com.ibatis.common.beans.ProbeException: There is
> no READABLE property named 'epoca' in class
> '[Lmx.gob.scjn.iuscommon.TO.EpocasTO;'
>
> Caused by: com.ibatis.common.beans..ProbeException: There
> is no READABLE property named 'epoca' in class
> '[Lmx.gob.scjn.iuscommon.TO.EpocasTO;'
>
> Caused by:
> com.ibatis.common.jdbc.exception.NestedSQLException:
>
> --- The error occurred in TesisDAO.xml.
>
> --- The error occurred while preparing the mapped statement for execution.
>
> --- Check the TesisDAO.porEpoca.
>
> --- Check the parameter map.
>
> --- Cause: com.ibatis.common.beans.ProbeException: There is
> no READABLE property named 'epoca' in class
> '[Lmx.gob.scjn.iuscommon..TO.EpocasTO;'
>
> Caused by: com.ibatis.common.beans.ProbeException: There is
> no READABLE property named 'epoca' in class
> '[Lmx.gob.scjn.iuscommon.TO.EpocasTO;'
>
> at
> com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:184)
>
> at
> com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:119)
>
> at
> com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:610)
>
> at
> com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:584)
>
> at
> com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:105)
>
> at
> org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(SqlMapClientTemplate.java:269)
>
> at
> org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:194)
>
> at
> org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResult(SqlMapClientTemplate.java:220)
>
> at
> org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClientTemplate.java:267)
>
> at
> mx.gob.scjn.iuscommon.DAO.impl.TesisDAOImpl.getTesis(TesisDAOImpl.java:42)
>
> at mx.gob.scjn.iuscommon.ius.Tesis.getTesis(Tesis.java:37)
>
> at
> mx.gob.scjn.iuscommon.fachade.FachadaBusquedaTradicional.getConsultaPanel(FachadaBusquedaTradicional.java:60)
>
> at
> mx.gob.scjn.iuscommon.fachade.FachadaBusquedaTradicionalTest.testGetConsultaPanel(FachadaBusquedaTradicionalTest.java:75)
>
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> Method)
>
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown
> Source)
>
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
> Source)
>
> at java.lang.reflect.Method.invoke(Unknown Source)
>
> at junit.framework.TestCase.runTest(TestCase.java:164)
>
> at junit.framework.TestCase.runBare(TestCase.java:130)
>
> at
> junit.framework.TestResult$1.protect(TestResult.java:110)
>
> at
> junit.framework.TestResult.runProtected(TestResult.java:128)
>
> at junit.framework.TestResult.run(TestResult.java:113)
>
> at junit.framework.TestCase.run(TestCase.java:120)
>
> at junit.framework.TestSuite.runTest(TestSuite.java:228)
>
> at junit.framework.TestSuite.run(TestSuite.java:223)
>
> at
> org.junit.internal.runners.OldTestClassRunner.run(OldTestClassRunner.java:35)
>
> at
> org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:38)
>
> at
> org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
>
> at
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
>
> at
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
>
> at
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
>
> at
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
>
> Caused by: com.ibatis.common.beans.ProbeException: There is
> no READABLE property named 'epoca' in class
> '[Lmx.gob..scjn.iuscommon.TO.EpocasTO;'
>
> at
> com.ibatis.common.beans.ClassInfo.getGetter(ClassInfo.java:160)
>
> at
> com.ibatis.common.beans.ComplexBeanProbe.getProperty(ComplexBeanProbe.java:302)
>
> at
> com.ibatis.common.beans.ComplexBeanProbe.getObject(ComplexBeanProbe.java:197)
>
> at
> com.ibatis.common.beans.GenericProbe.getObject(GenericProbe.java:57)
>
> at
> com.ibatis.sqlmap.engine.exchange.ComplexDataExchange.getData(ComplexDataExchange..java:65)
>
> at
> com.ibatis.sqlmap.engine.mapping.parameter.BasicParameterMap.getParameterObjectValues(BasicParameterMap.java:132)
>
> at
> com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:161)
>
> ... 31 more
>
>
>
> Caused by:
>
> com.ibatis.common.beans.ProbeException: There is no
> READABLE property named 'epoca' in class
> '[Lmx.gob.scjn.iuscommon.TO.EpocasTO;'
>
> at
> com.ibatis.common.beans.ClassInfo.getGetter(ClassInfo.java:160)
>
> at
> com.ibatis.common.beans.ComplexBeanProbe.getProperty(ComplexBeanProbe.java:302)
>
> at
> com.ibatis.common.beans.ComplexBeanProbe.getObject(ComplexBeanProbe.java:197)
>
> at
> com.ibatis.common.beans.GenericProbe.getObject(GenericProbe.java:57)
>
> at
> com.ibatis.sqlmap.engine.exchange.ComplexDataExchange.getData(ComplexDataExchange.java:65)
>
> at
> com.ibatis.sqlmap.engine.mapping.parameter.BasicParameterMap.getParameterObjectValues(BasicParameterMap.java:132)
>
> at
> com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:161)
>
> at
> com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:119)
>
> at
> com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:610)
>
> at
> com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:584)
>
> at
> com.ibatis.sqlmap.engine..impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:105)
>
> at
> org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(SqlMapClientTemplate.java:269)
>
> at
> org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:194)
>
> at
> org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResult(SqlMapClientTemplate.java:220)
>
> at
> org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClientTemplate.java:267)
>
> at
> mx.gob.scjn.iuscommon.DAO.impl.TesisDAOImpl.getTesis(TesisDAOImpl.java:42)
>
> at mx.gob.scjn.iuscommon.ius.Tesis.getTesis(Tesis.java:37)
>
> at
> mx.gob.scjn.iuscommon.fachade.FachadaBusquedaTradicional.getConsultaPanel(FachadaBusquedaTradicional.java:60)
>
> at
> mx.gob.scjn.iuscommon.fachade.FachadaBusquedaTradicionalTest.testGetConsultaPanel(FachadaBusquedaTradicionalTest.java:75)
>
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> Method)
>
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown
> Source)
>
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
> Source)
>
> at java.lang.reflect.Method.invoke(Unknown Source)
>
> at junit.framework.TestCase.runTest(TestCase.java:164)
>
> at junit.framework.TestCase.runBare(TestCase.java:130)
>
> at
> junit.framework.TestResult$1.protect(TestResult.java:110)
>
> at
> junit.framework.TestResult.runProtected(TestResult.java:128)
>
> at junit.framework.TestResult.run(TestResult.java:113)
>
> at junit.framework.TestCase.run(TestCase.java:120)
>
> at junit.framework.TestSuite.runTest(TestSuite.java:228)
>
> at junit.framework.TestSuite.run(TestSuite.java:223)
>
> at
> org.junit.internal.runners.OldTestClassRunner.run(OldTestClassRunner.java:35)
>
> at
> org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:38)
>
> at
> org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
>
> at
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
>
> at
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
>
> at
> org.eclipse.jdt.internal..junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
>
> at
> org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
>  ________________________________
>
> ¡Sé un mejor besador!
> Comparte todo lo que sabes sobre besos en:
>  http://telemundo.yahoo.com/promos/mejorbesador.html
>