ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Carlos de Luna Saenz <cdelunasa...@yahoo.com.mx>
Subject Rv: Rv: iterate syntax problem
Date Wed, 31 Oct 2007 15:20:18 GMT
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 lmeadors@apache.org 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 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 <cdelunasaenz@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 
> 





¡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


Mime
View raw message