I am still getting the error no mater if i use the #epoca[]# or the #epocas[]#
or the #epoca#
public class EpocasTO {
public Integer epoca;
public List<Integer> epocas;
private int sala;
public List<Integer> salas;
private int actualizacion;
private int tipoAct;
private int procedencia;
private int acuerdoEpoca;
Getters and setters are public fore each property.
On tesisMap.xml:
<select id="porEpoca" resultMap="tesisTO">
select Parte, Consec, IUS, Rubro, Texto, Precedentes,Epoca,
Sala, Fuente, Volumen, Tesis, Pagina, TA_TJ, Materia1,
Materia2,Materia3,IdGenealogia,VolOrden, ConsecIndx,IdTCC, InfAnexos,
LocAbr, NumLetra,ConsecLetra, Instancia,ConsecInst
from Tesis where
<iterate open = "(" close = ")" conjunction="OR">
epoca =#epoca[]# AND sala = #sala[]#
</iterate>
</select>
If need some other part or file, please let me know, since the mail was
rejecting this sending attachments.
Greetings
2007-10-31 08:09:57,679 [main] DEBUG
org.springframework.jdbc.datasource.DataSourceUtils - Returning JDBC Connection
to DataSource
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:45)
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.BaseProbe.getIndexedProperty(BaseProbe.java:52)
at
com.ibatis.common.beans.ComplexBeanProbe.getProperty(ComplexBeanProbe.java:297)
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.BaseProbe.getIndexedProperty(BaseProbe.java:52)
at
com.ibatis.common.beans.ComplexBeanProbe.getProperty(ComplexBeanProbe.java:297)
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:45)
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)
On October 30 Larry Meadors [EMAIL PROTECTED] says:
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
>
¡Sé un mejor asador!
Aprende todo sobre asados en:
http://telemundo.yahoo.com/promos/mejorasador.html
-----Sigue archivo adjunto en el mensaje-----
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap
PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
"resources/dtd/sql-map-2.dtd">
<sqlMap namespace="TesisDAO">
<resultMap id="tesisTO" class="mx.gob.scjn.iuscommon.TO.TesisTO">
<result property ="parte" column="Parte" columnIndex="1"/>
<result property ="consec" column="Consec" columnIndex="2"/>
<result property ="ius" column="IUS" columnIndex="3"/>
<result property ="rubro" column="Rubro" columnIndex="4"/>
<result property ="texto" column="Texto" columnIndex="5"/>
<result property ="precedentes" column="Precedentes" columnIndex="6"/>
<result property ="epoca" column="Epoca" columnIndex="7"/>
<result property ="sala" column="Sala" columnIndex="8"/>
<result property ="fuente" column="Fuente" columnIndex="9"/>
<result property ="volumen" column="Volumen" columnIndex="10"/>
<result property ="tesis" column="Tesis" columnIndex="11"/>
<result property ="pagina" column="Pagina" columnIndex="12"/>
<result property ="ta_tj" column="TA_TJ" columnIndex="13"/>
<result property ="materia1" column="Materia1" columnIndex="14"/>
<result property ="materia2" column="Materia2" columnIndex="15"/>
<result property ="materia3" column="Materia3" columnIndex="16"/>
<result property ="idGenealogia" column="idGenealogia" columnIndex="17"/>
<result property ="volOrden" column="VolOrden" columnIndex="18"/>
<result property ="consecIndx" column="ConsecIndx" columnIndex="19"/>
<result property ="idTCC" column="IdTCC" columnIndex="20"/>
<result property ="infAnexos" column="InfAnexos" columnIndex="21"/>
<result property ="locAbr" column="locAbr" columnIndex="22"/>
<result property ="numLetra" column="NumLetra" columnIndex="23"/>
<result property ="consecLetra" column="ConsecLetra" columnIndex="24"/>
<result property ="instancia" column="Instancia" columnIndex="25"/>
<result property ="consecInst" column="ConsecInst" columnIndex="26"/>
</resultMap>
<select id="getAll" resultMap="tesisTO">
select Parte, Consec, IUS, Rubro, Texto, Precedentes,Epoca,
Sala, Fuente, Volumen, Tesis, Pagina, TA_TJ, Materia1,
Materia2,Materia3,IdGenealogia,VolOrden, ConsecIndx,IdTCC, InfAnexos,
LocAbr, NumLetra,ConsecLetra, Instancia,ConsecInst
from Tesis where epoca = 5 limit 300000
</select>
<select id="porEpoca" resultMap="tesisTO">
select Parte, Consec, IUS, Rubro, Texto, Precedentes,Epoca,
Sala, Fuente, Volumen, Tesis, Pagina, TA_TJ, Materia1,
Materia2,Materia3,IdGenealogia,VolOrden, ConsecIndx,IdTCC, InfAnexos,
LocAbr, NumLetra,ConsecLetra, Instancia,ConsecInst
from Tesis where
<iterate open = "(" close = ")" conjunction="OR">
epoca =#epoca[]# AND sala = #sala[]#
</iterate>
</select>
</sqlMap>
-----Sigue archivo adjunto en el mensaje-----
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMapConfig
PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"
"resources/dtd/sql-map-config-2.dtd">
<sqlMapConfig>
<settings errorTracingEnabled="true" useStatementNamespaces="true"/>
<!-- SQL Map XML files should be listed here -->
<sqlMap resource="EjecutoriasDAO.xml" />
<sqlMap resource="TesisDAO.xml" />
</sqlMapConfig>
-----Sigue archivo adjunto en el mensaje-----
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN"
"http://www.springframework.org/dtd/spring-beans.dtd";;>
<beans>
<bean id="dataSource"
class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName">
<value> com.mysql.jdbc.Driver</value>
</property>
<property name="url">
<value>jdbc:mysql://172.10.52.182:3306/ius07</value>
</property>
<property name="username">
<value>CARLOS</value>
</property>
<property name="password">
<value>deluna</value>
</property>
</bean>
<bean id="sqlMap"
class = "org.springframework.orm.ibatis.SqlMapClientFactoryBean">
<property name="configLocation">
<value>sqlMapConfig..xml</value>
</property>
</bean>
<bean id="EjecutoriasDAO" class =
"mx.gob.scjn.iuscommon.DAO.impl.EjecutoriasDAOImpl">
<property name="dataSource">
<ref local="dataSource"/>
</property>
<property name="sqlMapClient">
<ref local="sqlMap"/>
</property>
</bean>
<bean id="AcuerdosDAO" class =
"mx.gob.scjn.iuscommon.DAO.impl.AcuerdosDAOImpl">
<property name="dataSource">
<ref local="dataSource"/>
</property>
<property name="sqlMapClient">
<ref local="sqlMap"/>
</property>
</bean>
<bean id="TesisDAO" class = "mx.gob.scjn.iuscommon.DAO.impl.TesisDAOImpl">
<property name="dataSource">
<ref local="dataSource"/>
</property>
<property name="sqlMapClient">
<ref local="sqlMap"/>
</property>
</bean>
<bean id="transactionManager"
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource">
<ref local="dataSource"/>
</property>
</bean>
</beans>
¡Sé un mejor besador!
Comparte todo lo que sabes sobre besos en:
http://telemundo.yahoo.com/promos/mejorbesador.html
-----Sigue archivo adjunto en el mensaje-----
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap
PUBLIC "-//ibatis.apache.org//DTD SQL Map 2..0//EN"
"resources/dtd/sql-map-2.dtd">
<sqlMap namespace="TesisDAO">
<resultMap id="tesisTO" class="mx.gob.scjn.iuscommon.TO.TesisTO">
<result property ="parte" column="Parte" columnIndex="1"/>
<result property ="consec" column="Consec" columnIndex="2"/>
<result property ="ius" column="IUS" columnIndex="3"/>
<result property ="rubro" column="Rubro" columnIndex="4"/>
<result property ="texto" column="Texto" columnIndex="5"/>
<result property ="precedentes" column="Precedentes" columnIndex="6"/>
<result property ="epoca" column="Epoca" columnIndex="7"/>
<result property ="sala" column="Sala" columnIndex="8"/>
<result property ="fuente" column="Fuente" columnIndex="9"/>
<result property ="volumen" column="Volumen" columnIndex="10"/>
<result property ="tesis" column="Tesis" columnIndex="11"/>
<result property ="pagina" column="Pagina" columnIndex="12"/>
<result property ="ta_tj" column="TA_TJ" columnIndex="13"/>
<result property ="materia1" column="Materia1" columnIndex="14"/>
<result property ="materia2" column="Materia2" columnIndex="15"/>
<result property ="materia3" column="Materia3" columnIndex="16"/>
<result property ="idGenealogia" column="idGenealogia" columnIndex="17"/>
<result property ="volOrden" column="VolOrden" columnIndex="18"/>
<result property ="consecIndx" column="ConsecIndx" columnIndex="19"/>
<result property ="idTCC" column="IdTCC" columnIndex="20"/>
<result property ="infAnexos" column="InfAnexos" columnIndex="21"/>
<result property ="locAbr" column="locAbr" columnIndex="22"/>
<result property ="numLetra" column="NumLetra" columnIndex="23"/>
<result property ="consecLetra" column="ConsecLetra" columnIndex="24"/>
<result property ="instancia" column="Instancia" columnIndex="25"/>
<result property ="consecInst" column="ConsecInst" columnIndex="26"/>
</resultMap>
<select id="getAll" resultMap="tesisTO">
select Parte, Consec, IUS, Rubro, Texto, Precedentes,Epoca,
Sala, Fuente, Volumen, Tesis, Pagina, TA_TJ, Materia1,
Materia2,Materia3,IdGenealogia,VolOrden, ConsecIndx,IdTCC, InfAnexos,
LocAbr, NumLetra,ConsecLetra, Instancia,ConsecInst
from Tesis where epoca = 5 limit 300000
</select>
<select id="porEpoca" resultMap="tesisTO">
select Parte, Consec, IUS, Rubro, Texto, Precedentes,Epoca,
Sala, Fuente, Volumen, Tesis, Pagina, TA_TJ, Materia1,
Materia2,Materia3,IdGenealogia,VolOrden, ConsecIndx,IdTCC, InfAnexos,
LocAbr, NumLetra,ConsecLetra, Instancia,ConsecInst
from Tesis where
<iterate open = "(" close = ")" conjunction="OR">
epoca =#epoca[]# AND sala = #sala[]#
</iterate>
</select>
</sqlMap>
____________________________________________________________________________________
¡Sé un mejor besador!
Comparte todo lo que sabes sobre besos.
http://telemundo.yahoo.com/promos/mejorbesador.html
