Return-Path: 
 <user-java-return-7615-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 29619 invoked from network); 27 Jun 2006 12:57:47 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 27 Jun 2006 12:57:47 -0000
Received: (qmail 79300 invoked by uid 500); 27 Jun 2006 12:57:45 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 79279 invoked by uid 500); 27 Jun 2006 12:57:45 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 79263 invoked by uid 99); 27 Jun 2006 12:57:45 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 27 Jun 2006 05:57:45 -0700
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
Received: from [83.247.21.92] (HELO wis.nl) (83.247.21.92)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 27 Jun 2006 05:57:43 -0700
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Subject: RE: Error using caches ("There is no statement named...")
X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0
Date: Tue, 27 Jun 2006 14:56:02 +0200
Message-ID: <50CA25BD6EEA954FA592C097399942E313A8059D@CM1.wis.local>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: Error using caches ("There is no statement named...")
thread-index: AcaZ3qC/zJ/rKvZ7SqukbbMZcksfFAACb+iQ
From: "Niels Beekman" <n.beekman@wis.nl>
To: <user-java@ibatis.apache.org>
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

Does the "modificacion" exist somewhere in your sqlmap-file? You =
excluded some parts by replacing it with "<...>", so I cannot verify =
that.

Second, the commented select uses a resultClass while the uncommented =
select uses a resultMap, but I don't think that matters in this case.

Niels

-----Original Message-----
From: Seraf=EDn Orill=E1n Chaparro [mailto:serafin.orillan@isotrol.com]=20
Sent: dinsdag 27 juni 2006 13:41
To: user-java@ibatis.apache.org
Subject: Re: Error using caches ("There is no statement named...")

Sure!

Here you have my Operadores.xml map file. The problem arises when i=20
discomment out the cacheModel declaration, no matter if i use it in the=20
select statement or not.

<sqlMap namespace=3D"operadores">
  =20
    <typeAlias alias=3D"Map" type=3D"java.util.Map" />
  =20
    <!--
    <cacheModel id=3D"cacheConsulta" type=3D"LRU">
        <flushInterval minutes=3D"30" />
        <flushOnExecute statement=3D"alta"/>
        <flushOnExecute statement=3D"baja"/>
        <flushOnExecute statement=3D"modificacion"/>
        <property name=3D"size" value=3D"100" />
    </cacheModel>
    -->
  =20
    <resultMap class=3D"java.util.HashMap" id=3D"resultadoOperador">
        <result property=3D"telefono" column=3D"TELEFONO"=20
javaType=3D"java.lang.String" jdbcType=3D"VARCHAR"/>
        <result property=3D"nombre" column=3D"NOMBRE"=20
javaType=3D"java.lang.String" jdbcType=3D"VARCHAR"/>
        <result property=3D"habilitado" column=3D"HABILITADO"=20
javaType=3D"boolean" jdbcType=3D"INTEGER"
           =20
typeHandler=3D"com.isotrol.navantia.sms.accesoBD.dao.ManejadoresTipos.Man=
ejadorTipoBoolean"/>
        <result property=3D"periodo_recepcion" column=3D"DIAS_SEMANA"=20
javaType=3D"int" jdbcType=3D"VARCHAR"
           =20
typeHandler=3D"com.isotrol.navantia.sms.accesoBD.dao.ManejadoresTipos.Man=
ejadorTipoPeriodoRecepcion"=20
/>
        <result property=3D"perfil" column=3D"ID_PERFIL" =
javaType=3D"int"=20
jdbcType=3D"INTEGER"/>
        <result property=3D"id_parque" column=3D"ID_PARQUE"=20
javaType=3D"java.lang.String" jdbcType=3D"VARCHAR"/>
        <result property=3D"horario_recepcion_desde" column=3D"HORA_INI" =

javaType=3D"java.lang.String" jdbcType=3D"VARCHAR"/>
        <result property=3D"horario_recepcion_hasta" column=3D"HORA_FIN" =

javaType=3D"java.lang.String" jdbcType=3D"VARCHAR"/>
        <result property=3D"envio_automatico" column=3D"ENVIO_AUTO"=20
javaType=3D"java.lang.String" jdbcType=3D"VARCHAR"
           =20
typeHandler=3D"com.isotrol.navantia.sms.accesoBD.dao.ManejadoresTipos.Man=
ejadorTipoBoolean"/>
        <result property=3D"horario_envio_automatico"=20
column=3D"HORARIO_ENVIO_AUTO" javaType=3D"java.lang.String" =
jdbcType=3D"VARCHAR"/>

    </resultMap>
  =20
  =20
    <select id=3D"consulta" resultMap=3D"resultadoOperador">
    <!-- <select id=3D"consulta" parameterClass=3D"Map"=20
resultClass=3D"java.util.HashMap" cacheModel=3D"cacheConsulta"> -->
        SELECT
            TELEFONO, NOMBRE, HABILITADO,
            DIAS_SEMANA,
            ID_PERFIL,
            ID_PARQUE,
            HORA_INI, HORA_FIN,
            ENVIO_AUTO, HORARIO_ENVIO_AUTO
        FROM
            GSM_V_OPERADORES

    </select>

    <...>
</sqlMap>