Return-Path: 
 <user-java-return-7623-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 89699 invoked from network); 27 Jun 2006 14:44:20 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 27 Jun 2006 14:44:20 -0000
Received: (qmail 29212 invoked by uid 500); 27 Jun 2006 14:44:18 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 29188 invoked by uid 500); 27 Jun 2006 14:44:17 -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 29177 invoked by uid 99); 27 Jun 2006 14:44:17 -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 07:44:17 -0700
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_HELO_PASS,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: domain of serafin.orillan@isotrol.com
 designates 83.175.206.228 as permitted sender)
Received: from [83.175.206.228] (HELO isotrol.com) (83.175.206.228)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 27 Jun 2006 07:44:15 -0700
Received: from localhost (localhost [127.0.0.1])
	by isotrol.com (Postfix) with ESMTP id 8E9FB6C313
	for <user-java@ibatis.apache.org>; Tue, 27 Jun 2006 16:43:52 +0200 (CEST)
Received: from isotrol.com ([127.0.0.1])
	by localhost (srv007.red.isotrol.com [127.0.0.1]) (amavisd-new, port 10024)
	with LMTP id 01029-01-36 for <user-java@ibatis.apache.org>;
	Tue, 27 Jun 2006 16:43:52 +0200 (CEST)
Received: from [127.0.0.1] (tierra.red.isotrol.com [192.168.102.198])
	by isotrol.com (Postfix) with ESMTP id C011A6C27A
	for <user-java@ibatis.apache.org>; Tue, 27 Jun 2006 16:43:51 +0200 (CEST)
Message-ID: <44A1442F.3070305@isotrol.com>
Date: Tue, 27 Jun 2006 16:43:59 +0200
From: =?ISO-8859-1?Q?Seraf=EDn_Orill=E1n_Chaparro?=
 <serafin.orillan@isotrol.com>
User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206)
X-Accept-Language: es-es, es
MIME-Version: 1.0
To: user-java@ibatis.apache.org
Subject: Re: Error using caches ("There is no statement named...")
References: <50CA25BD6EEA954FA592C097399942E313A8059D@CM1.wis.local>
In-Reply-To: <50CA25BD6EEA954FA592C097399942E313A8059D@CM1.wis.local>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at isotrol.com
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

Yes, it exists.

Here i paste the complete Operadores.xml file:

<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN"
"http://www.ibatis.com/dtd/sql-map-2.dtd">

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

    </resultMap>
   
   
    <!-- <select id="consulta" resultMap="resultadoOperador"> -->
    <select id="consulta" parameterClass="Map" 
resultMap="resultadoOperador" cacheModel="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>
   
    <insert id="alta" parameterClass="Map">

        INSERT INTO GSM_V_OPERADORES
            (TELEFONO, NOMBRE, ID_PERFIL,
            ID_PARQUE, HABILITADO,
            ENVIO_AUTO, HORARIO_ENVIO_AUTO,
            DIAS_SEMANA, HORA_INI, HORA_FIN)
        VALUES
            (#telefono#, #nombre#, #perfil#, #idParque#,
            
#habilitado,javaType=java.lang.Boolean,handler=com.isotrol.navantia.sms.accesoBD.dao.ManejadoresTipos.ManejadorTipoBoolean#, 

            
#envioAutomatico,javaType=java.lang.Boolean,handler=com.isotrol.navantia.sms.accesoBD.dao.ManejadoresTipos.ManejadorTipoBoolean#, 

            #horarioEnvioAutomatico#,
            
#periodoRecepcion,javaType=java.lang.Integer,handler=com.isotrol.navantia.sms.accesoBD.dao.ManejadoresTipos.ManejadorTipoPeriodoRecepcion#,
            #horarioRecepcionDesde#, #horarioRecepcionHasta#)
           
    </insert>
   
    <update id="modificacion" parameterClass="Map">

        UPDATE GSM_V_OPERADORES SET
       
        <dynamic>
           
            <isNotEmpty property="telefono">   
                TELEFONO = #telefono#
            </isNotEmpty>
           
            <isNotEmpty property="nombre" prepend=", ">   
                NOMBRE = #nombre#
            </isNotEmpty>
       
            <isNotEqual property="perfil" compareValue="0" prepend=", ">
                ID_PERFIL = #perfil#
            </isNotEqual>   
           
            <isNotEmpty property="idParque" prepend=", ">   
                ID_PARQUE = #idParque#
            </isNotEmpty>
           
            <isNotNull property="habilitado" prepend=", ">   
                HABILITADO = 
#habilitado,javaType=java.lang.Boolean,handler=com.isotrol.navantia.sms.accesoBD.dao.ManejadoresTipos.ManejadorTipoBoolean#
            </isNotNull>
           
            <isNotNull property="envioAutomatico" prepend=", ">   
                ENVIO_AUTO = 
#envioAutomatico,javaType=java.lang.Boolean,handler=com.isotrol.navantia.sms.accesoBD.dao.ManejadoresTipos.ManejadorTipoBoolean#
            </isNotNull>
           
            <isNotEmpty property="horarioEnvioAutomatico" prepend=", ">   
                HORARIO_ENVIO_AUTO = #horarioEnvioAutomatico#
            </isNotEmpty>
           
            <isNotEmpty property="periodoRecepcion" prepend=", ">   
                DIAS_SEMANA = 
#periodoRecepcion,javaType=java.lang.Integer,handler=com.isotrol.navantia.sms.accesoBD.dao.ManejadoresTipos.ManejadorTipoPeriodoRecepcion#
            </isNotEmpty>
           
            <isNotEmpty property="horarioRecepcionDesde" prepend=", ">   
                HORA_INI = #horarioRecepcionDesde#
            </isNotEmpty>
           
            <isNotEmpty property="horarrioRecepcionHasta" prepend=", ">   
                HORA_FIN = #horarioRecepcionHasta#
            </isNotEmpty>
        </dynamic>
       
           
        WHERE TELEFONO = #telefono#
       
    </update>
   
    <delete id="baja" parameterClass="Map">
       
        DELETE FROM GSM_TELEFONOS
        WHERE TELEFONO = #telefono#
       
    </delete>
   
   
</sqlMap>

Niels Beekman escribi�:

>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�n Orill�n Chaparro [mailto:serafin.orillan@isotrol.com] 
>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 
>discomment out the cacheModel declaration, no matter if i use it in the 
>select statement or not.
>
><sqlMap namespace="operadores">
>   
>    <typeAlias alias="Map" type="java.util.Map" />
>   
>    <!--
>    <cacheModel id="cacheConsulta" type="LRU">
>        <flushInterval minutes="30" />
>        <flushOnExecute statement="alta"/>
>        <flushOnExecute statement="baja"/>
>        <flushOnExecute statement="modificacion"/>
>        <property name="size" value="100" />
>    </cacheModel>
>    -->
>   
>    <resultMap class="java.util.HashMap" id="resultadoOperador">
>        <result property="telefono" column="TELEFONO" 
>javaType="java.lang.String" jdbcType="VARCHAR"/>
>        <result property="nombre" column="NOMBRE" 
>javaType="java.lang.String" jdbcType="VARCHAR"/>
>        <result property="habilitado" column="HABILITADO" 
>javaType="boolean" jdbcType="INTEGER"
>            
>typeHandler="com.isotrol.navantia.sms.accesoBD.dao.ManejadoresTipos.ManejadorTipoBoolean"/>
>        <result property="periodo_recepcion" column="DIAS_SEMANA" 
>javaType="int" jdbcType="VARCHAR"
>            
>typeHandler="com.isotrol.navantia.sms.accesoBD.dao.ManejadoresTipos.ManejadorTipoPeriodoRecepcion" 
>/>
>        <result property="perfil" column="ID_PERFIL" javaType="int" 
>jdbcType="INTEGER"/>
>        <result property="id_parque" column="ID_PARQUE" 
>javaType="java.lang.String" jdbcType="VARCHAR"/>
>        <result property="horario_recepcion_desde" column="HORA_INI" 
>javaType="java.lang.String" jdbcType="VARCHAR"/>
>        <result property="horario_recepcion_hasta" column="HORA_FIN" 
>javaType="java.lang.String" jdbcType="VARCHAR"/>
>        <result property="envio_automatico" column="ENVIO_AUTO" 
>javaType="java.lang.String" jdbcType="VARCHAR"
>            
>typeHandler="com.isotrol.navantia.sms.accesoBD.dao.ManejadoresTipos.ManejadorTipoBoolean"/>
>        <result property="horario_envio_automatico" 
>column="HORARIO_ENVIO_AUTO" javaType="java.lang.String" jdbcType="VARCHAR"/>
>
>    </resultMap>
>   
>   
>    <select id="consulta" resultMap="resultadoOperador">
>    <!-- <select id="consulta" parameterClass="Map" 
>resultClass="java.util.HashMap" cacheModel="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>
>
>
>  
>

-- 
Seraf�n Orill�n Chaparro
Isotrol S.A.
Avda. de la Innovaci�n 1, 3� planta
+34 955 036 800
e-mail: serafin.orillan@isotrol.com