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 [email protected] 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 <[EMAIL PROTECTED]> 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 >
